xiedeyantu commented on code in PR #5005: URL: https://github.com/apache/calcite/pull/5005#discussion_r3384738063
########## core/src/test/resources/sql/sort.iq: ########## @@ -533,4 +533,20 @@ SELECT * FROM emp ORDER BY deptno, null, empno; !ok +# [CALCITE-4353] Validator fails to expand order expression with dot operator +!use bookstore +select au."name" as author +from "bookstore"."authors" au +order by au."books"[1]."title"; Review Comment: Perhaps it would be better to write it this way. ``` !use bookstore select au."name" as author, au."books"[1]."title" title from "bookstore"."authors" au order by au."books"[1]."title"; +-------------------+-----------------+ | AUTHOR | TITLE | +-------------------+-----------------+ | Victor Hugo | Les Misérables | | Nikos Kazantzakis | Zorba the Greek | | Homer | | +-------------------+-----------------+ (3 rows) !ok ``` -- 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]
