To reproduce

A query that should return filtered + sorted rows instead returns zero rows when using ORDER BY timestamp DESC LIMIT N.

Example:
SELECT * FROM ticks WHERE timestamp < '2021-01-01' ORDER BY timestamp DESC LIMIT 10;
Result: 0 rows

But both of these return rows as expected:
SELECT * FROM ticks WHERE timestamp < '2021-01-01';
SELECT * FROM ticks WHERE timestamp < '2021-01-01' ORDER BY timestamp DESC;

Expected behavior:
ORDER BY … DESC LIMIT should return the last N rows matching the filter.

Actual behavior:
Returns zero rows even when matching rows exist.

QuestDB version:

9.2.2

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

Docker on Debian

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

btfs

Full Name:

Ron de Groot

Affiliation:

Self employed

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