Skip to content

Support correlated subqueries in WHERE clause#76078

Merged
KochetovNicolai merged 52 commits intomasterfrom
analyzer-scalar-correlated-subqueries
Apr 20, 2025
Merged

Support correlated subqueries in WHERE clause#76078
KochetovNicolai merged 52 commits intomasterfrom
analyzer-scalar-correlated-subqueries

Conversation

@novikd
Copy link
Copy Markdown
Member

@novikd novikd commented Feb 13, 2025 •
edited
Loading

Changelog category (leave one):

  • New Feature

Changelog entry (a user-readable short description of the changes that goes to CHANGELOG.md):

Support correlated subqueries as an argument of EXISTS expression in the WHERE clause. Closes #72459.

Documentation entry for user-facing changes

  • Documentation is written (mandatory for new features)

@clickhouse-gh
Copy link
Copy Markdown
Contributor

clickhouse-gh bot commented Feb 13, 2025 •
edited
Loading

Workflow [PR], commit [ffe3ccd]

@qoega qoega added the pr-experimental Experimental Feature label Feb 13, 2025
@qoega qoega mentioned this pull request Feb 13, 2025
Merged
1 task
Algunenano
Algunenano reviewed Feb 13, 2025
View reviewed changes
@alexey-milovidov alexey-milovidov mentioned this pull request Feb 14, 2025
Closed
76 tasks
@qoega

This comment was marked as resolved.

Sign in to view
@novikd novikd force-pushed the analyzer-scalar-correlated-subqueries branch from 2f9f1f8 to f429c1c Compare February 14, 2025 14:53
@novikd

This comment was marked as resolved.

Sign in to view
@qoega

This comment was marked as resolved.

Sign in to view
@novikd novikd added pr-feature Pull request with new product feature and removed pr-experimental Experimental Feature labels Mar 13, 2025
kyligence-git pushed a commit to Kyligence/ClickHouse that referenced this pull request May 5, 2025
@liuneng1994
export processors getter in QueryPlanStep
65d1b43 
(cherry picked from commit e34c8b0)

Fix rebase issue:
- 20250421 ClickHouse#76078
@rschu1ze rschu1ze mentioned this pull request May 6, 2025
Merged
baibaichen pushed a commit to Kyligence/ClickHouse that referenced this pull request May 7, 2025
@liuneng1994
export processors getter in QueryPlanStep
4cf0b0b 
(cherry picked from commit e34c8b0)

Fix rebase issue:
- 20250421 ClickHouse#76078
kyligence-git pushed a commit to Kyligence/ClickHouse that referenced this pull request May 7, 2025
@liuneng1994
export processors getter in QueryPlanStep
b3639b8 
(cherry picked from commit e34c8b0)

Fix rebase issue:
- 20250421 ClickHouse#76078
kyligence-git pushed a commit to Kyligence/ClickHouse that referenced this pull request May 8, 2025
@liuneng1994
export processors getter in QueryPlanStep
ed515e1 
(cherry picked from commit e34c8b0)

Fix rebase issue:
- 20250421 ClickHouse#76078
kyligence-git pushed a commit to Kyligence/ClickHouse that referenced this pull request May 9, 2025
@liuneng1994
export processors getter in QueryPlanStep
9de5054 
(cherry picked from commit e34c8b0)

Fix rebase issue:
- 20250421 ClickHouse#76078
kyligence-git pushed a commit to Kyligence/ClickHouse that referenced this pull request May 10, 2025
@liuneng1994
export processors getter in QueryPlanStep
b7e9843 
(cherry picked from commit e34c8b0)

Fix rebase issue:
- 20250421 ClickHouse#76078
kyligence-git pushed a commit to Kyligence/ClickHouse that referenced this pull request May 11, 2025
@liuneng1994
export processors getter in QueryPlanStep
6ca6194 
(cherry picked from commit e34c8b0)

Fix rebase issue:
- 20250421 ClickHouse#76078
kyligence-git pushed a commit to Kyligence/ClickHouse that referenced this pull request May 12, 2025
@liuneng1994
export processors getter in QueryPlanStep
d68c159 
(cherry picked from commit e34c8b0)

Fix rebase issue:
- 20250421 ClickHouse#76078
kyligence-git pushed a commit to Kyligence/ClickHouse that referenced this pull request May 13, 2025
@liuneng1994
export processors getter in QueryPlanStep
cb9e137 
(cherry picked from commit e34c8b0)

Fix rebase issue:
- 20250421 ClickHouse#76078
Asm0deusss pushed a commit to Asm0deusss/ClickHouse that referenced this pull request May 14, 2025
@novikd
Follow up to ClickHouse#76078
5ff45ab
kyligence-git pushed a commit to Kyligence/ClickHouse that referenced this pull request May 14, 2025
@liuneng1994
export processors getter in QueryPlanStep
4aa9e75 
(cherry picked from commit e34c8b0)

Fix rebase issue:
- 20250421 ClickHouse#76078
kyligence-git pushed a commit to Kyligence/ClickHouse that referenced this pull request May 15, 2025
@liuneng1994
export processors getter in QueryPlanStep
82e48b2 
(cherry picked from commit e34c8b0)

Fix rebase issue:
- 20250421 ClickHouse#76078
kyligence-git pushed a commit to Kyligence/ClickHouse that referenced this pull request May 16, 2025
@liuneng1994
export processors getter in QueryPlanStep
6dff2a9 
(cherry picked from commit e34c8b0)

Fix rebase issue:
- 20250421 ClickHouse#76078
kyligence-git pushed a commit to Kyligence/ClickHouse that referenced this pull request May 17, 2025
@liuneng1994
export processors getter in QueryPlanStep
2304337 
(cherry picked from commit e34c8b0)

Fix rebase issue:
- 20250421 ClickHouse#76078
kyligence-git pushed a commit to Kyligence/ClickHouse that referenced this pull request May 18, 2025
@liuneng1994
export processors getter in QueryPlanStep
6a42ac1 
(cherry picked from commit e34c8b0)

Fix rebase issue:
- 20250421 ClickHouse#76078
kyligence-git pushed a commit to Kyligence/ClickHouse that referenced this pull request May 19, 2025
@liuneng1994
export processors getter in QueryPlanStep
5b9dd82 
(cherry picked from commit e34c8b0)

Fix rebase issue:
- 20250421 ClickHouse#76078
kyligence-git pushed a commit to Kyligence/ClickHouse that referenced this pull request May 20, 2025
@liuneng1994
export processors getter in QueryPlanStep
1fb327d 
(cherry picked from commit e34c8b0)

Fix rebase issue:
- 20250421 ClickHouse#76078
kyligence-git pushed a commit to Kyligence/ClickHouse that referenced this pull request May 21, 2025
@liuneng1994
export processors getter in QueryPlanStep
f269ff7 
(cherry picked from commit e34c8b0)

Fix rebase issue:
- 20250421 ClickHouse#76078
kyligence-git pushed a commit to Kyligence/ClickHouse that referenced this pull request May 22, 2025
@liuneng1994
export processors getter in QueryPlanStep
ab28f87 
(cherry picked from commit e34c8b0)

Fix rebase issue:
- 20250421 ClickHouse#76078
kyligence-git pushed a commit to Kyligence/ClickHouse that referenced this pull request May 23, 2025
@liuneng1994
export processors getter in QueryPlanStep
2de6c3a 
(cherry picked from commit e34c8b0)

Fix rebase issue:
- 20250421 ClickHouse#76078
kyligence-git pushed a commit to Kyligence/ClickHouse that referenced this pull request May 24, 2025
@liuneng1994
export processors getter in QueryPlanStep
bb2afe6 
(cherry picked from commit e34c8b0)

Fix rebase issue:
- 20250421 ClickHouse#76078
kyligence-git pushed a commit to Kyligence/ClickHouse that referenced this pull request May 25, 2025
@liuneng1994
export processors getter in QueryPlanStep
2143d18 
(cherry picked from commit e34c8b0)

Fix rebase issue:
- 20250421 ClickHouse#76078
kyligence-git pushed a commit to Kyligence/ClickHouse that referenced this pull request May 26, 2025
@liuneng1994
export processors getter in QueryPlanStep
78c9908 
(cherry picked from commit e34c8b0)

Fix rebase issue:
- 20250421 ClickHouse#76078
kyligence-git pushed a commit to Kyligence/ClickHouse that referenced this pull request May 27, 2025
@liuneng1994
export processors getter in QueryPlanStep
47cf312 
(cherry picked from commit e34c8b0)

Fix rebase issue:
- 20250421 ClickHouse#76078
baibaichen pushed a commit to Kyligence/ClickHouse that referenced this pull request May 29, 2025
@liuneng1994
export processors getter in QueryPlanStep
21fc9ad 
(cherry picked from commit e34c8b0)

Fix rebase issue:
- 20250421 ClickHouse#76078
kyligence-git pushed a commit to Kyligence/ClickHouse that referenced this pull request May 29, 2025
@liuneng1994
export processors getter in QueryPlanStep
e8b50ec 
(cherry picked from commit e34c8b0)

Fix rebase issue:
- 20250421 ClickHouse#76078
kyligence-git pushed a commit to Kyligence/ClickHouse that referenced this pull request May 30, 2025
@liuneng1994
export processors getter in QueryPlanStep
76723d8 
(cherry picked from commit e34c8b0)

Fix rebase issue:
- 20250421 ClickHouse#76078
kyligence-git pushed a commit to Kyligence/ClickHouse that referenced this pull request May 31, 2025
@liuneng1994
export processors getter in QueryPlanStep
302b963 
(cherry picked from commit e34c8b0)

Fix rebase issue:
- 20250421 ClickHouse#76078
@alexey-milovidov alexey-milovidov mentioned this pull request Mar 1, 2026
Closed
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Reviewers

@Algunenano Algunenano Algunenano left review comments

@KochetovNicolai KochetovNicolai KochetovNicolai approved these changes

Assignees

@KochetovNicolai KochetovNicolai

Labels

pr-backports-created Backport PRs are successfully created, it won't be processed by CI script anymore pr-backports-created-cloud deprecated label, NOOP pr-feature Pull request with new product feature pr-must-backport-synced The `*-must-backport` labels are synced into the cloud Sync PR pr-synced-to-cloud The PR is synced to the cloud repo

Projects

None yet

Milestone

No milestone

Development

Successfully merging this pull request may close these issues.

[Correlated subqueries] (NOT) EXISTS in other table

8 participants

@novikd @qoega @KochetovNicolai @Algunenano @robot-clickhouse @robot-ch-test-poll3 @rschu1ze @robot-clickhouse-ci-2