You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Describe the bug
While reviewing #3408, I found an additional error when trying to evaluate select i_item_desc from test where d3_date > d1_date + INTERVAL '5 days' and d2_date > d1_date + INTERVAL '3 days':
apache/datafusion-sqlparser-rs#705 has been merged, but now it seems like the second condition of something like where d3_date > d1_date + INTERVAL '5 days' and d2_date > d1_date + INTERVAL '3 days' isn't being checked by DataFusion. Currently looking into this.
sqlparser-rs/sqlparser-rs#705 has been merged, but now it seems like the second condition of something like where d3_date > d1_date + INTERVAL '5 days' and d2_date > d1_date + INTERVAL '3 days' isn't being checked by DataFusion. Currently looking into this.
This turned out to just be an error with the data file I was working with. Everything seems to work as expected now.
I actually think this issue is not yet actually "fixed" in datafusion as we haven't updated the sqlparser version to 0.28 which includes the change. I will do so later today so reopening this issue
Activity
HaoYang670 commentedon Nov 7, 2022
I am not sure whether this is a bug in sql-parser, cc @andygrove . This is what I get
Dandandan commentedon Nov 7, 2022
Looks very similar to
#3408
sarahyurick commentedon Nov 28, 2022
apache/datafusion-sqlparser-rs#705 has been merged, but now it seems like the second condition of something likewhere d3_date > d1_date + INTERVAL '5 days' and d2_date > d1_date + INTERVAL '3 days'isn't being checked by DataFusion. Currently looking into this.sarahyurick commentedon Nov 28, 2022
This turned out to just be an error with the data file I was working with. Everything seems to work as expected now.
alamb commentedon Dec 9, 2022
I actually think this issue is not yet actually "fixed" in datafusion as we haven't updated the sqlparser version to 0.28 which includes the change. I will do so later today so reopening this issue
alamb commentedon Dec 9, 2022
#4568
alamb commentedon Dec 12, 2022
This is fixed -- I have a PR open to add some regression test coverage: #4569