Skip to content

ClickHouse: Support unparenthesized IN right-hand side#2385

Open
dinmukhamedm wants to merge 1 commit into
apache:mainfrom
lmnr-ai:clickhouse/allow-parse-in-no-paren
Open

ClickHouse: Support unparenthesized IN right-hand side#2385
dinmukhamedm wants to merge 1 commit into
apache:mainfrom
lmnr-ai:clickhouse/allow-parse-in-no-paren

Conversation

@dinmukhamedm

Copy link
Copy Markdown

Fixes #2384

Note: The fix is a little broader than just the parameterized ClickHouse queries, e.g. WHERE id IN {ids: Array(UUID)}.

After opening the issue, I experimented a little more with ClickHouse, and found that it wraps in parenthesis anything on the RHS of IN, even for singular values, e.g.

SELECT * from users WHERE name in 'a';
-- becomes
SELECT * from users WHERE name in ('a');

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

None yet

Projects

None yet

Development

Successfully merging this pull request may close these issues.

IN operator rejects a ClickHouse query-parameter placeholder as its right-hand side without parenthesis

1 participant