[CALCITE-3461] SqlToRelConverter substituteSubQuery problem

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Labels: pull-request-available
• Assignee: Danny Chen
• Reporter: TIsNotT
• Created: 30/Oct/19 13:31
• Updated: 08/Nov/19 01:55
• Resolved: 08/Nov/19 01:12

Description

final String sql = "select \n" + " case \n"
+ " when deptno in (1) then '1'\n"
+ "when deptno in (220) then '220' \n"
+ "else null end as deptno,\n"
+ "name,\n"
+ "count(distinct name)as num\n"
+ "from dept\n" + "\n"
+ "where \n"
+ "deptno in(1)\n"
+ " group by name,deptno ";

Sql like that ,SqlToRelConverter cannot convert from sql to node.
Bzc,substituteSubQuery handle wrong.

Issue Links

• is duplicated by: CALCITE-3456 AssertionError throws for aggregation with same digest IN subqueries in same scope
• links to: GitHub Pull Request #1549
• links to: GitHub Pull Request #1553