Re: decorrelate before subquery removing

2022-02-08 Thread stanilovsky evgeny
Looks like it useful remark, thanks ! Hi All IIUC, the current implementation may be problematic. Ignite disabled subquery rewriting in this PR( https://github.com/apache/ignite/pull/9251), and I think the correct process would be sqlnode => relnode => convert RexSubQuery to Correlate => d

Re: decorrelate before subquery removing

2022-02-07 Thread Alex Plehanov
Hello, Flag expand=false is required to support some types of subqueries. But we can also perform decorrelation explicitly after subquery rewriting. I've filled the ticket [1]. Thank you! [1]: https://issues.apache.org/jira/browse/IGNITE-16493 сб, 5 февр. 2022 г. в 14:50, Chang Chen : > Hi All

decorrelate before subquery removing

2022-02-05 Thread Chang Chen
Hi All IIUC, the current implementation may be problematic. Ignite disabled subquery rewriting in this PR( https://github.com/apache/ignite/pull/9251), and I think the correct process would be sqlnode => relnode => convert RexSubQuery to Correlate => decorrelateQuery, however, the last two steps