Hi, I noticed unexpected behavior for Date type. If year value is less then 1000 then filtering do not work.
Steps:
create table test (date Date); insert into test values ('0001-01-01'); select * from test where date = '0001-01-01'
Returns 0 rows. Expected 1 row.
Comparison operators is also problematic