Major Description
if there was a timestamp or date field F1, the queries below will throw nullpointer exception if F1 has null value
select extract(year from F1) from T where extract(year from F1) in (2004, 2005)
select extract(year from F1) , count(0) from T where extract(year from F1) in (2004, 2005) group by extract(year from F1)
the number of items in WHERE-IN clause must be equal or more than two
Attachments
Issue Links
- is related to
-
CALCITE-1054 NPE caused by wrong code generation for Timestamp fields
-
- Closed
-