[
https://issues.apache.org/jira/browse/CALCITE-7427?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18062724#comment-18062724
]
Zhen Chen commented on CALCITE-7427:
------------------------------------
I think there are two possible reasons why these cases are throwing errors:
First, many rules are only used to verify rule changes but are not actually
applied in execution. Second, many newly added rules were not added to the
default rule group to avoid breaking Calcite's default behavior, so they were
not used when executing "!ok".
> 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
> Assignee: Zhen Chen
> 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)
