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)