search

duckdb / duckdb_mysql

MIT License
45 stars 10 forks source link

Issue found turning on mysql_experimental_filter_pushdown variable #36

Closed renanbenedicto closed 5 months ago

renanbenedicto commented 6 months ago

I found an error when trying to enable the filter pushdown with mysql_experimental_filter_pushdown:

WHERE (`datetimeCol` < '2022-01-01 00:00:00'::TIMESTAMP AND `datetimeCol` IS NOT NULL)": 
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '::TIMESTAMP AND `datetimeCol` IS NOT NULL)' at line 1

I understand that is an internal error from duckdb that tries to rewrite the query before sending to MySQL. It happens only with DATETIME type (I've tried using INT by PK)

szarnyasg commented 6 months ago

Hello, this issue tracker collects issues with the DuckDB documentation. I'm transferring this issue to the duckdb_mysql repository.