I had hoped and expected that it would do B (push down project and
filter expressions) or C (push down project expressions) but in fact
it does A (keep expressions in the same place, but add a project to
the input that just narrows the columns to just those needed.
I agree with Stamatis' that for
Hello,
I looked into the rule recently but to be honest I already forgot what it
really does.
Expect: B
Hope: A
Comments:
Judging by the name I would expect B, pushing as much as possible from the
top project but not altering the filter.
In the end it is just a transpose.
On the other hand, I
As part of https://issues.apache.org/jira/browse/CALCITE-3975, I've
been looking into what ProjectFilterTransposeRule does with
expressions. It's one of our oldest rules, and I thought I knew what
it did. But the rule does not do what I expect. I've like to conduct a
straw poll to see what other