[CALCITE-4781] group by index is not support

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Not A Problem
• Affects Version/s: 1.24.0, 1.25.0
• Component/s: jdbc-adapter
• Assignee: Unassigned
• Reporter: zlzhang0122
• Created: 16/Sep/21 09:12
• Updated: 15/Oct/21 01:45
• Resolved: 16/Sep/21 23:27

Description

Now, the follow sql isn't support:

select empno, count(*) from emps group by 1;

will produce a problem,but:

select empno, count(*) from emps group by empno;

won't, this syntax maybe need to be support.

Issue Links

• causes: FLINK-24306 group by index throw SqlValidatorException