Incorrect double null value returned in the select query. #5291
Description
To reproduce
qdb=> create table tab2 (ts timestamp, d double) timestamp(ts);
qdb=> insert into tab2 select x::timestamp, case when x % 3 = 0 THEN NULL ELSE x%5 END from long_sequence(7);
qdb=> select * from tab2;
ts | d
----------------------------+-----------------------
1970-01-01 00:00:00.000001 | 1.0
1970-01-01 00:00:00.000002 | 2.0
1970-01-01 00:00:00.000003 | -9.223372036854776E18
1970-01-01 00:00:00.000004 | 4.0
1970-01-01 00:00:00.000005 | 0.0
1970-01-01 00:00:00.000006 | -9.223372036854776E18
1970-01-01 00:00:00.000007 | 2.0
In which NULL value of d returned as -9.223372036854776E18
QuestDB version:
Master branch
OS, in case of Docker specify Docker and the Host OS:
Mac
File System, in case of Docker specify Host File System:
APFS
Full Name:
Victor
Affiliation:
None
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