hannerwang opened a new pull request #2693: URL: https://github.com/apache/calcite/pull/2693
After this pr, JDBC adapter generates ORDER BY clause with the following preference: 1. if dialect conformance support sort by ordinal, prefer ORDER BY ordinal. 2. if dialect conformance support sort by alias, prefer ORDER BY alias. 3. resolve to ORDER BY SELECT ITEM without as. Exceptions: 1. if the ORDER BY clause is in WINDOW or WITHIN GROUP, always resolve to ORDER BY SELECT ITEM. 2. if the ORDER BY ordinal is greater than size of SELECT LIST, always resolve to ORDER BY SELECT ITEM. -- 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]
