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

Aliases imperfect for named subqueries. #25655

Closed
den-crane opened this issue Jun 23, 2021 · 1 comment · Fixed by #62185
Closed

Aliases imperfect for named subqueries. #25655

den-crane opened this issue Jun 23, 2021 · 1 comment · Fixed by #62185
Labels
duplicate st-hold We've paused the work on issue for some reason usability

Comments

@den-crane
Copy link
Contributor 

SELECT
  sum(t.b) / 1 a,
  sum(t.a)        
FROM ( SELECT 1 a, 2 b ) t;

DB::Exception: Unknown identifier 'a' in aggregate function 'sum(a)'
@den-crane den-crane added question Question? usability and removed question Question? labels Jun 23, 2021
@alexey-milovidov
Copy link
Member

#23194

@alexey-milovidov alexey-milovidov added duplicate st-hold We've paused the work on issue for some reason labels Jun 23, 2021
@alexey-milovidov alexey-milovidov mentioned this issue Jun 23, 2021
Closed
fm4v added a commit that referenced this issue Apr 3, 2024
@fm4v
Close: #25655
50309fb
fm4v added a commit that referenced this issue Apr 3, 2024
@fm4v
Close: #25655
e09187e
@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
duplicate st-hold We've paused the work on issue for some reason usability
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
2 participants
@alexey-milovidov @den-crane