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

XML

Word

Printable

JSON

Details

Type: Bug
Status: Closed
Priority: Major
Resolution: Fixed
Affects Version/s: 1.27.0
Fix Version/s: 1.28.0
Component/s: None
Labels:
- pull-request-available

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=[[]])

Attachments

- Sort By Name
- Sort By Date
- Ascending
- Descending

CALCITE-4848.patch
12/Oct/21 12:42
4 kB
Thomas Rebele

Issue Links

is depended upon by

CALCITE-4835 Release Calcite 1.28.0

Closed

relates to

CALCITE-2638 Constant reducer must not duplicate calls to non-deterministic functions

Closed

links to

GitHub Pull Request #2581

Activity

People

Assignee:: Thomas Rebele

Reporter:: Thomas Rebele

Votes:: 0 Vote for this issue

Watchers:: 5 Start watching this issue

Dates

Created:: 12/Oct/21 12:42

Updated:: 20/Oct/21 05:24

Resolved:: 14/Oct/21 09:54

Time Tracking

Estimated:

Not Specified

Remaining:

Logged:

1h 40m