Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

filterNode with predicate value of "False" in the logical plan #2000

Closed
RahelehK opened this issue Nov 11, 2019 · 2 comments
Closed

filterNode with predicate value of "False" in the logical plan #2000

RahelehK opened this issue Nov 11, 2019 · 2 comments
Labels
bug Something isn't working

Comments

@RahelehK
Copy link

RahelehK commented Nov 11, 2019 •
edited by findepi
Loading

Execution of TPCDS q04 will result in a filterNode in the logical plan which has a predicate value of "false" as seen in below snapshot: (mysql connector)
image

Please note that this issue is also reproducible with builtin tpcds connector as well.
Furthermore, the predicate is also retained in the final plan as can be seen below:
image
@findepi findepi added the bug Something isn't working label Nov 11, 2019
@findepi
Copy link
Member

findepi commented Nov 11, 2019

@RahelehK thanks for reporting this.
Obviously, such a predicate should be "eliminated" (replaced with empty ValuesNode).

@findepi findepi mentioned this issue Nov 11, 2019
Closed
@findepi
Copy link
Member

findepi commented Nov 14, 2019

Fixed, thanks.

@findepi findepi closed this as completed Nov 14, 2019
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
bug Something isn't working
Milestone
No milestone
Development

No branches or pull requests
2 participants
@findepi @RahelehK