Bug Report: Date type with year less than 1000 (years 1-999) in spark sql where [solved]

[Kotofosonline]

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

[Kotofosonline]

Hm, seems to work now.