Yes, it’s a Calcite issue.
The correct plan would create two Correlate instances, because the correlating
variables are set by different outer-loops.
I think you can defer decorrelation until after SqlToRel. That might work
better. In your test, add ".withDecorrelate(false)”. Then add another t
Hello,
First, thanks to this community for supporting this amazing project.
I’m using Calcite to convert sql statements into relational algebra, when
running my tests with assertions enabled I’m facing the following issue to a
specific statement:
java.lang.AssertionError: All correlation variab