[CALCITE-4848] Adding a HAVING condition to a query with a dynamic parameter makes the result always empty

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.27.0
• Fix Version/s: 1.28.0
• Labels: pull-request-available
• Assignee: Thomas Rebele
• Reporter: Thomas Rebele
• Created: 12/Oct/21 12:42
• Updated: 20/Oct/21 05:24
• Resolved: 14/Oct/21 09:54

Description

The query

SELECT sal, COUNT(1) AS count_val
FROM emp t WHERE sal = ?
GROUP BY sal HAVING sal < 1000 

gets translated to the following logical plan:

LogicalFilter(condition=[<($0, 1000)])
  LogicalAggregate(group=[{0}], COUNT_VAL=[COUNT()])
    LogicalProject(SAL=[$5], $f1=[1])
      LogicalFilter(condition=[=($5, ?0)])
        LogicalTableScan(table=[[CATALOG, SALES, EMP]]) 

However, applying CoreRules.FILTER_REDUCE_EXPRESSIONS to the plan it just becomes

LogicalValues(tuples=[[]]) 

 

Issue Links

• is depended upon by: CALCITE-4835 Release Calcite 1.28.0
• relates to: CALCITE-2638 Constant reducer must not duplicate calls to non-deterministic functions
• links to: GitHub Pull Request #2581