[
https://issues.apache.org/jira/browse/IMPALA-14758?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Steve Carlin resolved IMPALA-14758.
-----------------------------------
Resolution: Fixed
> Calcite planner: Query with null return value in case statement crashes server
> ------------------------------------------------------------------------------
>
> Key: IMPALA-14758
> URL: https://issues.apache.org/jira/browse/IMPALA-14758
> Project: IMPALA
> Issue Type: Sub-task
> Reporter: Steve Carlin
> Assignee: Steve Carlin
> Priority: Major
>
> The following query is crashing the server because the return value in the
> "then" clause is null:
> SELECT a.id, a.int_col, a.string_col FROM alltypessmall a
> WHERE 1 NOT IN (SELECT CASE WHEN id = 1 then null ELSE id END FROM
> alltypestiny)
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
