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

Kotofosonline — Thu, 12 Aug 2021 17:05:40 GMT

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

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

Kotofosonline — Fri, 20 Aug 2021 12:37:24 GMT

Hm, seems to work now.