[
https://issues.apache.org/jira/browse/CALCITE-1188?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16327741#comment-16327741
]
Julian Hyde commented on CALCITE-1188:
--------------------------------------
Your test works for me too. I suspect that the issue was fixed long ago by code
generation changes. Can you create a PR for your test case? I will commit it
and we can mark this bug as "fixed".
(By the way, there is other work occurring on CALCITE-1054 which may improve
things further.)
> 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)
