To reproduce

Ok:

SELECT * FROM generate_series('2025-01-01', '2025-01-02', '1h');

Not ok:

DECLARE @lo := '2025-01-01', @hi := '2025-01-02', @unit := '1h'
SELECT * FROM generate_series(@lo, @hi, @unit);

QuestDB version:

Master

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

N/A

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

N/A

Full Name:

Nick Woolmer

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