You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@calcite.apache.org by "terran2010 (Jira)" <ji...@apache.org> on 2026/03/09 09:08:00 UTC

[jira] [Created] (CALCITE-7438) The nullif function stops optimizing to case when

terran2010 created CALCITE-7438:
-----------------------------------

             Summary: The nullif function stops optimizing to case when
                 Key: CALCITE-7438
                 URL: https://issues.apache.org/jira/browse/CALCITE-7438
             Project: Calcite
          Issue Type: Improvement
          Components: core
    Affects Versions: 1.41.0
            Reporter: terran2010


When execute sql：
{code:java}
select NULLIF(count(brand_name),1) from product{code}
Calcite will make the following optimizations:
{code:java}
SELECT CASE WHEN COUNT(brand_name) = 1 THEN NULL ELSE COUNT(brand_name) END FROM foodmart.product{code}
During the actual execution of the above SQL, COUNT (brandname) will be executed twice. Can we consider disabling this optimization



--
This message was sent by Atlassian Jira
(v8.20.10#820010)