[
https://issues.apache.org/jira/browse/CALCITE-1961?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16138838#comment-16138838
]
Julian Hyde commented on CALCITE-1961:
--------------------------------------
Yes, this is a bug. Although this occurs with NOT LIKE it would occur with any
condition that is not "=". The condition is being evaluated in a Project below
the Join, and so appears as a boolean column. RelToSqlConverter ought to be
able to handle that, or, better, merge the Join and Project into a SqlJoin.
> RelToSqlConverter error when join with NOT equals condition
> -----------------------------------------------------------
>
> Key: CALCITE-1961
> URL: https://issues.apache.org/jira/browse/CALCITE-1961
> Project: Calcite
> Issue Type: Bug
> Affects Versions: 1.11.0
> Reporter: Dongming Liu
> Assignee: Julian Hyde
>
> For SQL:
> {code:java}
> select c_custkey from customer join orders on c_custkey = o_custkey and
> o_comment not like '%unusual%accounts%';
> {code}
> Its RelNode has a JOIN that condition as follow:
> {code:java}
> condition = {RexCall@7367} "AND(=($0, $9), $17)"
> op = {SqlBinaryOperator@7377} "AND"
> operands = {RegularImmutableList@7378} size = 2
> 0 = {RexCall@7383} "=($0, $9)"
> 1 = {RexInputRef@7384} "$17"
> type = {BasicSqlType@7379} "BOOLEAN"
> digest = "AND(=($0, $9), $17)"
> {code}
> The second operand of AND is a RexInputRef.
> When I call the RelToSqlConverter to convert the RelNode to SqlNode, I have
> exception as follows:
> {code:java}
> java.lang.AssertionError: Internal error: While invoking method 'public
> org.apache.calcite.rel.rel2sql.SqlImplementor$Result
> org.apache.calcite.rel.rel2sql.RelToSqlConverter.visit(org.apache.calcite.rel.core.Project)'
> at org.apache.calcite.util.Util.newInternal(Util.java:795)
> ~[classes/:na]
> at org.apache.calcite.util.ReflectUtil$2.invoke(ReflectUtil.java:534)
> ~[classes/:na]
> at
> org.apache.calcite.rel.rel2sql.RelToSqlConverter.dispatch(RelToSqlConverter.java:88)
> ~[classes/:na]
> at
> org.apache.calcite.rel.rel2sql.RelToSqlConverter.visitChild(RelToSqlConverter.java:92)
> ~[classes/:na]
> {code}
> *convertConditionToSqlNode* be called to build the join condition by
> RelToSqlConverter, and it has follow code:
> {code:java}
> if (!(node instanceof RexCall)) {
> throw new AssertionError(node);
> }
> {code}
> RexInputRef is obviously not a RexCall.
> Is this a bug? And is there any methods to convert RelNode like this to
> SqlNode?
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
