-
Notifications
You must be signed in to change notification settings - Fork 8.3k
FORMAT and SETTINGS parsing leads to errors #39712
Copy link
Copy link
Labels
minorPriority: minorPriority: minorunexpected behaviourResult is unexpected, but not entirely wrong at the same time.Result is unexpected, but not entirely wrong at the same time.
Description
Query parsing related to FORMAT and SETTINGS clauses is inconsistent.
select 1 settings log_comment='test' Format {{format}} works as intended
(select 1) settings log_comment='test' Format {{format}} and (select 1) union (select 2) settings log_comment='test' Format {{format}} give a parsing error:
Syntax error: failed at position 50 ('Format'):
(select 1) settings log_comment='prova valerio' Format JSONCompact
Expected end of query
Queries without the FORMAT clause work as intended.
Does it reproduce on recent release?
22.7.1.2484 is affected
How to reproduce
Connect to clickhouse-client and run the queries
Expected behavior
Same behaviour between different versions
If applicable, add screenshots to help explain your problem.
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
minorPriority: minorPriority: minorunexpected behaviourResult is unexpected, but not entirely wrong at the same time.Result is unexpected, but not entirely wrong at the same time.
