[
https://issues.apache.org/jira/browse/CALCITE-6088?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17782967#comment-17782967
]
Jiajun Xie commented on CALCITE-6088:
-------------------------------------
Fixed in
[94dc167.|https://github.com/apache/calcite/commit/94dc1673da824174f9271677ead73cfae1aeb29b]
Thanks [~MasseGuillaume] and [~mbudiu].
> SqlItemOperator fails in RelToSqlConverter
> ------------------------------------------
>
> Key: CALCITE-6088
> URL: https://issues.apache.org/jira/browse/CALCITE-6088
> Project: Calcite
> Issue Type: Bug
> Components: core
> Affects Versions: 1.35.0
> Reporter: Guillaume Massé
> Assignee: Jiajun Xie
> Priority: Major
> Labels: pull-request-available
>
> We have an expression that looks like:
> {code:java}
> foo[1].bar {code}
> When we run RelToSqlConverter we get the following strack trace: (Calcite
> 1.35.0)
>
> {code:java}
> [info] java.lang.ClassCastException: class
> org.apache.calcite.sql.SqlBasicCall cannot be cast to class
> org.apache.calcite.sql.SqlIdentifier (org.apache.calcite.sql.SqlBasicCall and
> org.apache.calcite.sql.SqlIdentifier are in unnamed module of loader
> sbt.internal.FlatLoader @3de98cb6)
> [info] at
> org.apache.calcite.rel.rel2sql.SqlImplementor$Context.toSql(SqlImplementor.java:676)
> [info] at
> org.apache.calcite.rel.rel2sql.RelToSqlConverter.visit(RelToSqlConverter.java:458)
> [info] at
> java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> [info] at
> java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
> [info] at
> java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> [info] at java.base/java.lang.reflect.Method.invoke(Method.java:568)
> [info] at org.apache.calcite.util.ReflectUtil$2.invoke(ReflectUtil.java:532)
> [info] at
> org.apache.calcite.rel.rel2sql.RelToSqlConverter.dispatch(RelToSqlConverter.java:143)
> [info] at
> org.apache.calcite.rel.rel2sql.RelToSqlConverter.visitInput(RelToSqlConverter.java:151)
> [info] at
> org.apache.calcite.rel.rel2sql.SqlImplementor.visitInput(SqlImplementor.java:220)
> {code}
>
> This is because there is a missing case for the function
> {code:java}
> public SqlNode toSql(@Nullable RexProgram program, RexNode rex) {
> // ...
> switch (rex.getKind()){
> // ...
> case ITEM: // << missing
> // missing impl
> default:
> sqlIdentifier = (SqlIdentifier) toSql(program, referencedExpr);
> }{code}
>
> ```
> The rex kind is ITEM
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
