[CALCITE-4411] RelNode to SQL lost the distinct when doing window aggregation

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.27.0
• Component/s: core
• Labels: pull-request-available
• Assignee: Jiatao Tao
• Reporter: Jiatao Tao
• Created: 20/Nov/20 03:06
• Updated: 03/Jun/21 22:32
• Resolved: 02/Dec/20 10:47

Description

The case see in: https://github.com/Aaaaaaron/calcite/tree/CALCITE-4411

org.apache.calcite.rel.rel2sql.RelToSqlConverterTest#testConvertWindowToSql

 

Query:  SELECT  count(distinct employee_id) over (order by hire_date) FROM  employee

Expected: SELECT COUNT(DISTINCT employee_id) OVER (ORDER BY hire_date RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) FROM foodmart.employee

Actual: SELECT COUNT(employee_id) OVER (ORDER BY hire_date RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) FROM foodmart.employee

Issue Links

• links to: GitHub Pull Request #2274