What happens?

I've encountered an issue when trying to compare a TIMESTAMP WITH TIME ZONE value with a DATE value. Here's the SQL that reproduces the issue:

This works:

set time zone 'UTC';
select date_trunc('day', '2024-05-06 16:09:28+05:00'::timestamptz) == '2024-05-06 17:19:18+05:20'::date as r;

Output:

┌─────────┐
│    r    │
│ boolean │
├─────────┤
│ true    │
└─────────┘

But this does not:

set time zone 'UTC';
select date_trunc('day', '2024-05-06 16:09:28+05:00'::timestamptz) >= '2024-05-06 17:19:18+05:20'::date as r;

Output:

BinderException: Binder Error: Cannot compare values of type TIMESTAMP WITH TIME ZONE and type DATE - an explicit cast is required

To Reproduce

set time zone 'UTC';
select date_trunc('day', '2024-05-06 16:09:28+05:00'::timestamptz) >= '2024-05-06 17:19:18+05:20'::date as r;

OS:

Ubuntu 20.04.5 LTS

DuckDB Version:

0.10.2

DuckDB Client:

python

Full Name:

Arif Aslam

Affiliation:

Mammoth Analytics Inc.

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