To reproduce

On demo, contrived example:

SELECT symbol, first((0::timestamp)::long) latest
  FROM trades
  WHERE timestamp IN today()
  ORDER BY latest DESC
  LIMIT 10;

QuestDB version:

9.1.0

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