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

📘Fix missing ERROR: cannot push down this subquery in set_operations and subquery_in_where #7741

Open
colm-mchugh opened this issue Nov 13, 2024 · 0 comments · May be fixed by #7745
Open

📘Fix missing ERROR: cannot push down this subquery in set_operations and subquery_in_where #7741

colm-mchugh opened this issue Nov 13, 2024 · 0 comments · May be fixed by #7745
Assignees
@colm-mchugh

Comments

@colm-mchugh
Copy link
Contributor

colm-mchugh commented Nov 13, 2024 •
edited
Loading

This is the branch for the fix: https://github.com/citusdata/citus/tree/cmchugh/pg17-set_operations
@colm-mchugh colm-mchugh mentioned this issue Nov 13, 2024
Open
39 tasks
@colm-mchugh colm-mchugh self-assigned this Nov 13, 2024
@colm-mchugh colm-mchugh changed the title 📘Fix missing ERROR: cannot push down this subquery, could be the same issue as the above, seen in set_operations 📘Fix missing ERROR: cannot push down this subquery in set_operations and subquery_in_where Nov 13, 2024
colm-mchugh added a commit that referenced this issue Nov 14, 2024
@colm-mchugh
Fix Test Failure in subquery_in_where, set_operations in PG17 (#7741)
0cb74b8 
Change the queries causing the test failures so that the ANY subquery
cannot be folded to a join, preserving the expected output of the test.
@colm-mchugh colm-mchugh linked a pull request Nov 14, 2024 that will close this issue
Cmchugh/pg17 set operations #7743
Closed
This was referenced Nov 14, 2024
Closed
Open
@colm-mchugh colm-mchugh removed a link to a pull request Nov 14, 2024
Cmchugh/pg17 set operations #7743
Closed
@colm-mchugh colm-mchugh linked a pull request Nov 14, 2024 that will close this issue
Fix Test Failure in subquery_in_where, set_operations in PG17 (#7741) #7745
Open
colm-mchugh added a commit that referenced this issue Nov 14, 2024
@colm-mchugh
Fix Test Failure in subquery_in_where, set_operations, dml_recursive …
1a6ef7c 
…in PG17 (#7741)

Change the queries causing the test failures so that the ANY subquery
cannot be folded to a join, preserving the expected output of the test.
colm-mchugh added a commit that referenced this issue Nov 15, 2024
@colm-mchugh
Fix Test Failure in subquery_in_where, set_operations, dml_recursive …
7b7d2d0 
…in PG17 (#7741)

Change the queries causing the test failures so that the ANY subquery
cannot be folded to a join, preserving the expected output of the test.

Add pg17 regress test for pg17 features.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@colm-mchugh colm-mchugh

Labels
None yet
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

Fix Test Failure in subquery_in_where, set_operations in PG17 (#7741) citusdata/citus
1 participant
@colm-mchugh