Skip to content

Allow columns with unknown table in CollectJoinOnKeysMatcher#22745

Closed
vdimir wants to merge 1 commit intoClickHouse:masterfrom
vdimir:fix-join-arrayjoin-unknown-col
Closed

Allow columns with unknown table in CollectJoinOnKeysMatcher#22745
vdimir wants to merge 1 commit intoClickHouse:masterfrom
vdimir:fix-join-arrayjoin-unknown-col

Conversation

@vdimir
Copy link
Copy Markdown
Member

@vdimir vdimir commented Apr 7, 2021

I hereby agree to the terms of the CLA available at: https://yandex.ru/legal/cla/?lang=en

Changelog category (leave one):

  • Bug Fix

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

Fix unknown column error for ARRAY JOIN with JOIN ON, close #22399.

Alternatively we can Revert "Move conditions from JOIN ON to WHERE", see #22753

@robot-clickhouse robot-clickhouse added the pr-bugfix Pull request with bugfix, not backported by default label Apr 7, 2021
@vdimir vdimir force-pushed the fix-join-arrayjoin-unknown-col branch from 856c372 to 351a48d Compare April 7, 2021 11:37
@vdimir
Copy link
Copy Markdown
Member Author

vdimir commented Apr 7, 2021

We will allow more cases in JOIN ON section, considering expressions from unknown table as from left table.

Previously it was forbidden in #15162, this PR relax some rules.

E.g. JOIN ON 1 = t2.x will be allowed

@vdimir
Copy link
Copy Markdown
Member Author

vdimir commented Apr 15, 2021

Decided to merge revert #22753

@vdimir vdimir closed this Apr 15, 2021
@vdimir vdimir deleted the fix-join-arrayjoin-unknown-col branch March 29, 2022 10:10
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

pr-bugfix Pull request with bugfix, not backported by default

Projects

None yet

Development

Successfully merging this pull request may close these issues.

DB::Exception: Cannot get JOIN keys from JOIN ON section

2 participants