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)
