Skip to content

Support EXISTS(subquery)#29731

Merged
kssenii merged 2 commits intoClickHouse:masterfrom
kssenii:exists-subquery
Oct 5, 2021
Merged

Support EXISTS(subquery)#29731
kssenii merged 2 commits intoClickHouse:masterfrom
kssenii:exists-subquery

Conversation

@kssenii
Copy link
Copy Markdown
Member

@kssenii kssenii commented Oct 4, 2021

Changelog category (leave one):

  • New Feature

Changelog entry (a user-readable short description of the changes that goes to CHANGELOG.md):
Support EXISTS(subquery). Closes #6852.

@robot-clickhouse robot-clickhouse added doc-alert pr-feature Pull request with new product feature labels Oct 4, 2021
@CurtizJ CurtizJ self-assigned this Oct 4, 2021
if (!exists_expression)
return;

/// EXISTS(subquery) --> 1 IN (SELECT 1 FROM subquery LIMIT 1)
Copy link
Copy Markdown
Member

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Does LIMIT pushdown work alright?
CC @KochetovNicolai

Copy link
Copy Markdown
Member

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

LGTM nevertheless.

Copy link
Copy Markdown
Member

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

It should.
Some things may be still improved for exists, e.g. we don't have to wait for GROUP BY

@CurtizJ CurtizJ assigned alexey-milovidov and unassigned CurtizJ Oct 4, 2021
@alexey-milovidov
Copy link
Copy Markdown
Member

Cannot merge, tests have failed :(

@kssenii
Copy link
Copy Markdown
Member Author

kssenii commented Oct 5, 2021

Integration tests (thread) — fail: 67 -- docker problems..
Other failures also not related.

@kssenii kssenii merged commit 3663d23 into ClickHouse:master Oct 5, 2021
@alex-zaitsev alex-zaitsev mentioned this pull request Oct 5, 2021
24 tasks
@ka1bi4
Copy link
Copy Markdown
Contributor

ka1bi4 commented Nov 2, 2021

Internal documentation ticket: DOCSUP-17653

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

pr-feature Pull request with new product feature

Projects

None yet

Development

Successfully merging this pull request may close these issues.

WHERE EXISTS ( ... subquery ...) not supported and error message is confusing

6 participants