[ https://issues.apache.org/jira/browse/CALCITE-1188?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Wei Hu updated CALCITE-1188: ---------------------------- 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 was: 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 item in WHERE-IN clause must have two or more items > NullPointerException in extract with where in clause if field has null value > ---------------------------------------------------------------------------- > > Key: CALCITE-1188 > URL: https://issues.apache.org/jira/browse/CALCITE-1188 > Project: Calcite > Issue Type: Bug > Affects Versions: 1.7.0 > Reporter: Wei Hu > Assignee: Julian Hyde > > 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 -- This message was sent by Atlassian JIRA (v6.3.4#6332)