[ https://issues.apache.org/jira/browse/CALCITE-1188?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16327937#comment-16327937 ]
Julian Hyde commented on CALCITE-1188: -------------------------------------- That pull request is currently empty - it has zero commits. Can you please make a commit of your test, and push it to your master branch at github. (Sorry for all the red tape. The ASF needs to see a commit in a pull request as an indication that you intend to contribute code.) > 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 > Priority: Major > Labels: newbie > > 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 (v7.6.3#76005)