You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@calcite.apache.org by "Wei Hu (JIRA)" <ji...@apache.org> on 2016/04/05 13:57:25 UTC
[jira] [Updated] (CALCITE-1188) NullPointerException in extract
with where in clause if field has null value
[ 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)
was:
if there was a timestamp or date field F1, the queries below will throw nullpointer exception
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)
Summary: NullPointerException in extract with where in clause if field has null value (was: NullPointerException in extract with where in clause)
> 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)
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)