mihaibudiu commented on code in PR #4417: URL: https://github.com/apache/calcite/pull/4417#discussion_r2149015796
########## 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: yes, the sql is the same, but the conformance is different. that's the whole point: a query that is valid in all conformances should always produce the exact same result -- 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]
