To reproduce

select now() as now FROM long_sequence(1) WHERE now() IN '$now-100s..$now';

This query returns a row on first execution, and then no rows on subsequent executions. To be coherent, I'd expect it to return a single row on every execution.

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