You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
I'm using pandahouse to execute query with where-condition using string that contains apostrophe in its value (e.g. Rock'n'Roll)
Normally I use double-quote in datagrip and all works just fine
But it seems to me read_clickhouse function just converts all double quotes into backquotes and it forces clickhouse to see this expression as a column
For example the sting that I'm passing to read_clickhouse function as follows:
select * from sometable
where genre == "Rock'n'Roll"
As a result of read_clickhouse function I got mistake that clickhouse doesn't see the column Rock'n'Roll, because it executes not the same string, but:
select * from sometable
where genre == `Rock'n'Roll`
Actually all queries that have double-quotes fall because of this mistake
I can't even use replaceAll(genre, "'", ' ') clickhouse-function, because it cannot see column ' - that is strange
Why is this happening?
The text was updated successfully, but these errors were encountered:
I'm using pandahouse to execute query with where-condition using string that contains apostrophe in its value (e.g. Rock'n'Roll)
Normally I use double-quote in datagrip and all works just fine
But it seems to me read_clickhouse function just converts all double quotes into backquotes and it forces clickhouse to see this expression as a column
For example the sting that I'm passing to read_clickhouse function as follows:
As a result of read_clickhouse function I got mistake that clickhouse doesn't see the column Rock'n'Roll, because it executes not the same string, but:
Actually all queries that have double-quotes fall because of this mistake
I can't even use replaceAll(genre, "'", ' ') clickhouse-function, because it cannot see column ' - that is strange
Why is this happening?
The text was updated successfully, but these errors were encountered: