xiedeyantu commented on code in PR #4417: URL: https://github.com/apache/calcite/pull/4417#discussion_r2149019488
########## core/src/test/resources/sql/misc.iq: ########## @@ -2460,24 +2460,288 @@ FROM "hr"."emps"; !ok -!use post +!use scott # [CALCITE-4512] GROUP BY expression with argument name same with SELECT field and alias causes validation error SELECT floor(empno/2) as empno -FROM emps +FROM emp +GROUP BY floor(empno/2); ++-------+ +| EMPNO | ++-------+ +| 3684 | +| 3749 | +| 3760 | +| 3783 | +| 3827 | +| 3849 | +| 3891 | +| 3894 | +| 3919 | +| 3922 | +| 3938 | +| 3950 | +| 3951 | +| 3967 | ++-------+ +(14 rows) + +!ok + +!use scott-lenient + +# Result should be the same as above +# Validated using MySQL +SELECT floor(empno/2) as empno Review Comment: You are right, I missed the `!use scott-lenient`. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
