strongduanmu commented on issue #22170: URL: https://github.com/apache/shardingsphere/issues/22170#issuecomment-1319503531
According to oracle document——https://docs.oracle.com/javadb/10.6.2.1/ref/rrefsqlj13658.html, If the null ordering is not specified then the handling of the null values is: NULLS LAST if the sort is ASC, NULLS FIRST if the sort is DESC. If neither ascending nor descending order is specified, and the null ordering is also not specified, then both defaults are used and thus the order will be ascending with NULLS LAST. ```SQL SELECT * FROM test2 ORDER BY content2 ASC; -- ID CONTENT2 -- 2 TEST -- 1 - SELECT * FROM test2 ORDER BY content2 DESC; -- ID CONTENT2 -- 1 - -- 2 TEST SELECT * FROM test2 ORDER BY content2 DESC NULLS LAST; -- 2 TEST -- 1 - ``` -- 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]
