What happens?

Comparing between DATE and TIMESTAMP_MS values fails with error

Binder Error: Cannot compare values of type TIMESTAMP_MS and type DATE - an explicit cast is required

To Reproduce

v0.10.3 70fd6a8a24
Enter ".help" for usage hints.
Connected to a transient in-memory database.
Use ".open FILENAME" to reopen on a persistent database.

CREATE TABLE timestamps_ms(ts TIMESTAMP_MS);
INSERT INTO timestamps_ms VALUES ('1993-08-14 00:00:00'), ('1993-08-15 01:01:02'), ('1993-08-16 00:00:00');
SELECT * FROM  timestamps_ms WHERE ts >= date '1993-08-15';

OS:

MacOS 14.4.1 (aarch64)

DuckDB Version:

0.10.3

DuckDB Client:

cli

Full Name:

Andrey Koshchiy

Affiliation:

Pixonic

What is the latest build you tested with? If possible, we recommend testing with the latest nightly build.

I have tested with a stable release

Did you include all relevant data sets for reproducing the issue?

Yes

Did you include all code required to reproduce the issue?

• Yes, I have

Did you include all relevant configuration (e.g., CPU architecture, Python version, Linux distribution) to reproduce the issue?

• Yes, I have