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.

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

Allow trailing commas in expression list of SELECT query #48438

Merged
merged 2 commits into from
Apr 11, 2023

Conversation

evillique
Copy link
Member

Changelog category (leave one):

  • Improvement

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

Allow trailing commas in expression list of SELECT query, for example SELECT a, b, c, FROM table. Closes #37802

@robot-clickhouse-ci-1 robot-clickhouse-ci-1 added the pr-improvement Pull request with some product improvements label Apr 5, 2023
@nickitat nickitat self-assigned this Apr 5, 2023
@evillique evillique requested a review from nickitat April 9, 2023 18:10
SELECT 1, FROM numbers(1);
WITH 1 as a SELECT a, FROM numbers(1);
WITH 1 as from SELECT from, from + from, from in [0], FROM numbers(1);
SELECT n, FROM (SELECT 1 AS n);
Copy link
Member

Choose a reason for hiding this comment

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

maybe makes sense to add also some scalar subquery (like (select * from numbers(1)))
also smth like select [1, 2, from numbers(10) just in case.

@robot-ch-test-poll1 robot-ch-test-poll1 merged commit 028ccfd into ClickHouse:master Apr 11, 2023
139 checks passed
@evillique evillique deleted the add-trailing-commas branch April 12, 2023 11:27
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
pr-improvement Pull request with some product improvements
Projects
None yet
Development

Successfully merging this pull request may close these issues.

Feature request: allowing trailing commas
5 participants