fa zheng created CALCITE-3850:
---------------------------------
Summary: AssertionError when converts a SQL parse tree into a
relational algebra expression
Key: CALCITE-3850
URL: https://issues.apache.org/jira/browse/CALCITE-3850
Project: Calcite
Issue Type: Bug
Components: core
Affects Versions: 1.21.0
Reporter: fa zheng
I execute following sql with calcite 1.21.0 in flink 1.10. When the two
conditions of left outer join are like"ON t1.a=t2.a" and "ON t1.a=t3.a ", it
execute successfully. However, when the two conditions of left outer join are
like "ON IF(t1.a='...',STRING(RAND(123)),t1.a)=t2.a" and "ON
IF(t1.a='...',STRING(RAND(123)),t1.a)=t3.a", it gets a assert error in method
getRootField.
It also can execute successfully with "ON t1.a=t2.a" and "ON
IF(t1.a='...',STRING(RAND(123)),t1.a)=t3.a".
But failed with "ON IF(t1.a='...',STRING(RAND(123)),t1.a)=t2.a" and "ON
t1.a=t3.a"
SELECT
...
FROM
(
SELECT
...
) t1
LEFT OUTER JOIN
(
SELECT
...
) t2
ON ...
LEFT OUTER JOIN
(
SELECT
...
) t3
ON ...
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
