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

cross join + array join: not found column in block #11757

Closed
akuzm opened this issue Jun 18, 2020 · 0 comments · Fixed by #62185
Closed

cross join + array join: not found column in block #11757

akuzm opened this issue Jun 18, 2020 · 0 comments · Fixed by #62185
Labels
comp-alias-columns comp-joins JOINs st-hold We've paused the work on issue for some reason unexpected behaviour

Comments

@akuzm
Copy link
Contributor

akuzm commented Jun 18, 2020 

~3~ :) select * from (select [1, 2] a) aa cross join (select [3, 4] b) bb array join aa.a, bb.b;

Received exception from server (version 20.5.1):
Code: 10. DB::Exception: Received from localhost:9000. DB::Exception: Not found column b in block. There are only columns: a. Stack trace:
@akuzm akuzm added the bug Confirmed user-visible misbehaviour in official release label Jun 18, 2020
@4ertus2 4ertus2 added unexpected behaviour and removed bug Confirmed user-visible misbehaviour in official release labels Jul 15, 2020
@4ertus2 4ertus2 removed their assignment Oct 16, 2020
@alexey-milovidov alexey-milovidov added warmup task The task for new ClickHouse team members. Low risk, moderate complexity, no urgency. st-hold We've paused the work on issue for some reason and removed warmup task The task for new ClickHouse team members. Low risk, moderate complexity, no urgency. labels Aug 11, 2022
@alexey-milovidov alexey-milovidov mentioned this issue Aug 11, 2022
Closed
fm4v added a commit that referenced this issue Apr 3, 2024
@fm4v
Close: #11757
46da2d1
fm4v added a commit that referenced this issue Apr 3, 2024
@fm4v
Close: #11757
71d8565
@nikitamikhaylov nikitamikhaylov mentioned this issue Apr 3, 2024
Merged
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
comp-alias-columns comp-joins JOINs st-hold We've paused the work on issue for some reason unexpected behaviour
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

Add tests from all the issues analyzer fixes ClickHouse/ClickHouse
3 participants
@4ertus2 @alexey-milovidov @akuzm