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

Confusing error message with dynamic column selection #63576

Closed
strtgbb opened this issue May 9, 2024 · 2 comments
Closed

Confusing error message with dynamic column selection #63576

strtgbb opened this issue May 9, 2024 · 2 comments
Labels
minor Priority: minor usability

Comments

@strtgbb
Copy link

strtgbb commented May 9, 2024

Describe what's wrong

The error message references a projection that was not created by the user.

https://fiddle.clickhouse.com/cc99e6e1-9c5d-4d36-99ed-02c3cc65a7dc

Does it reproduce on the most recent release?

yes

Enable crash reporting

n/a

How to reproduce

SELECT COLUMNS('idontexist') FROM users SETTINGS allow_experimental_analyzer=1;

Expected behavior

A less confusing error message.

Error message and/or stacktrace

Received exception from server (version 24.4.1):
Code: 51. DB::Exception: Received from localhost:9000. DB::Exception: Empty list of columns in projection. In scope SELECT COLUMNS('idontexist') FROM users SETTINGS allow_experimental_analyzer = 1. (EMPTY_LIST_OF_COLUMNS_QUERIED)
(query: SELECT COLUMNS('idontexist') FROM users SETTINGS allow_experimental_analyzer=1;)
@strtgbb strtgbb added the potential bug To be reviewed by developers and confirmed/rejected. label May 9, 2024
@Algunenano Algunenano changed the title Confusing error message with experimental analyzer and dynamic column selection Confusing error message with dynamic column selection May 9, 2024
@Algunenano Algunenano added usability minor Priority: minor and removed potential bug To be reviewed by developers and confirmed/rejected. labels May 9, 2024
@nikitamikhaylov
Copy link
Member

The error mentions projection from relational algebra, not a "data projection" you mean.

@UnamedRus
Copy link
Contributor

Do user need to know about relation algebra projections for understanding error messages?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
minor Priority: minor usability
Projects
None yet
Development

No branches or pull requests

4 participants