SAMPLE BY breaks with last(timestamp)

[nwoolmer]

To reproduce

-- 717 rows
select timestamp, symbol,  first(price) as open, last(price) as close, max(price) as high, min(price) as low, sum(amount) AS volume
from trades w where timestamp > dateadd('d', -1, now()) sample by 1h;

-- 771,098 rows
select timestamp, symbol,  first(price) as open, last(price) as close, max(price) as high, min(price) as low, sum(amount) AS volume, last(timestamp) as last_timestamp
from trades w where timestamp > dateadd('d', -1, now()) sample by 1h;

Similar to: #4315

QuestDB version:

7.4.2

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

Demo

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

ext4

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