Bug: date_part function giving incorrect results

[gaurav8297]

Kùzu version

latest

What operating system are you using?

No response

What happened?

kuzu> MATCH (p:persons) WHERE date_part('year', p.birth_date) >= 1915 AND date_part('year', p.birth_date) < 1970 RETURN count(p);
┌──────────────┐
│ COUNT(p._ID) │
│ INT64        │
├──────────────┤
│ 0            │
└──────────────┘
(1 tuple)
(1 column)
Time: 0.20ms (compiling), 16.66ms (executing)
kuzu> MATCH (p:persons) RETURN date_part('year', p.birth_date) LIMIT 10;
┌──────────────────────────────┐
│ DATE_PART(year,p.birth_date) │
│ INT64                        │
├──────────────────────────────┤
│ 1903                         │
│ 1931                         │
│ 1927                         │
│ 1975                         │
│ 1927                         │
│ 1981                         │
│ 1946                         │
│ 1942                         │
│ 1973                         │
│ 1950                         │
└──────────────────────────────┘
(10 tuples)
(1 column)
Time: 0.13ms (compiling), 0.55ms (executing)

In the first query, filter returns 0 as count whereas as you see in the second query there are years which are less than 1970 and greater than 1915.

Are there known steps to reproduce?

No response