COALESCE failing for NULL timestamps

[javier]

To reproduce

select
      coalesce(null :: timestamp, 1),
      coalesce(null, 1),
      coalesce(now(), 1),
      coalesce(null, null :: timestamp)

The first two coalesce statements should return 1, but the first one returns the incorrect value of 1970-01-01T00:00:00.000001Z. The other two coalesce statements are there just to show with non-null values, or when the null::timestamp is used as a return value it all works as expected.

Maybe related to this issue

QuestDB version:

7.4.3

OS, in case of Docker specify Docker and the Host OS:

OSx

File System, in case of Docker specify Host File System:

ext4

Full Name:

javier ramirez

Affiliation:

questdb

Have you followed Linux, MacOs kernel configuration steps to increase Maximum open files and Maximum virtual memory areas limit?

• Yes, I have

Additional context

No response