You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@impala.apache.org by "Steve Carlin (Jira)" <ji...@apache.org> on 2026/02/20 00:02:00 UTC

[jira] [Created] (IMPALA-14758) Calcite planner: Query with null return value in case statement crashes server

Steve Carlin created IMPALA-14758:
-------------------------------------

             Summary: 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


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)