Issue found turning on mysql_experimental_filter_pushdown variable

[renanbenedicto]

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]

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