Skip to content

unexpected parameterized view exception#1060

Merged
yokofly merged 1 commit intodevelopfrom
unexpected-parameterized-view-exception
Dec 15, 2025
Merged

unexpected parameterized view exception#1060
yokofly merged 1 commit intodevelopfrom
unexpected-parameterized-view-exception

Conversation

@yokofly
Copy link
Copy Markdown
Collaborator

@yokofly yokofly commented Dec 15, 2025 •
edited
Loading

PR checklist:

  • Did you run ClangFormat ?
  • Did you separate headers to a different section in existing community code base ?
  • Did you surround proton: starts/ends for new code in existing community code base ?

Please write user-readable short description of the changes:
fix

I created a parameterized view like this create view github_param_view as select * from github_events limit {limit:int8} I can query with select * from github_param_view(limit=2) but the error message if I don't set the param value is a bit confusing. It should show param(s) are not set
Code: 51. DB::Exception: Empty list of columns in SELECT query. (EMPTY_LIST_OF_COLUMNS_QUERIED)

before:

proton :) select * from github_param_view

SELECT
  *
FROM
  github_param_view

Query id: b7535caa-f40c-42b6-bc6d-fc29b97595d2


0 rows in set. Elapsed: 0.023 sec. 

Received exception from server (version 3.0.11):
Code: 51. DB::Exception: Received from localhost:8463. DB::Exception: Empty list of columns in SELECT query. (EMPTY_LIST_OF_COLUMNS_QUERIED)

proton :)

after:

SELECT
  *
FROM
  `99100_param_view`

Query id: 62b96c6a-6d7d-4fda-a01d-8baed2ab504c


0 rows in set. Elapsed: 0.011 sec. 

Received exception from server (version 3.0.11):
Code: 456. DB::Exception: Received from localhost:8463. DB::Exception: Query parameter(s) are not set: `limit`. (UNKNOWN_QUERY_PARAMETER)

@yokofly yokofly merged commit 3940d0a into develop Dec 15, 2025
8 of 11 checks passed
@yokofly yokofly deleted the unexpected-parameterized-view-exception branch January 29, 2026 08:12
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Reviewers

No reviews

Assignees

No one assigned

Labels

None yet

Projects

None yet

Milestone

No milestone

Development

Successfully merging this pull request may close these issues.

1 participant

@yokofly