[
https://issues.apache.org/jira/browse/CALCITE-7427?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18062582#comment-18062582
]
Zhen Chen commented on CALCITE-7427:
------------------------------------
If you have no plan to solve this issue, I can take a look at it.
> Query with "ORDER BY NULL" throws "NoSuchMethodException: compareNullsLast"
> ---------------------------------------------------------------------------
>
> Key: CALCITE-7427
> URL: https://issues.apache.org/jira/browse/CALCITE-7427
> Project: Calcite
> Issue Type: Bug
> Reporter: Julian Hyde
> Priority: Major
>
> A query with the NULL literal in its ORDER BY clause throws. For example,
> {{{}dummy.iq{}}}:
> {noformat}
> !use scott
> SELECT * FROM emp ORDER BY deptno, null, empno;
> !ok {noformat}
> gives error
> {noformat}
> java.sql.SQLException: Error while executing SQL "SELECT * FROM emp ORDER BY
> deptno, null, empno": Unable to implement EnumerableCalc
> ...
> Caused by: java.lang.NoSuchMethodException:
> org.apache.calcite.runtime.Utilities.compareNullsLast(java.lang.Void,java.lang.Void)
> at java.base/java.lang.Class.getMethod(Class.java:2395)
> at
> org.apache.calcite.linq4j.tree.Types.lookupMethod(Types.java:288){noformat}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
