clickhouse icon indicating copy to clipboard operation
clickhouse copied to clipboard
verified publisher icon TimonKK

Passing an apostrophe to values causes error

Open B3none opened this issue 3 years ago • 5 comments

For an Array(String) column type passing an apostrophe within the string value causes an error

B3none avatar Jun 29 '22 15:06 B3none

Could you please to show code example with this bug?

TimonKK avatar Jul 11 '22 19:07 TimonKK

Steps to re-create:

  1. Create a table with a metaKey column with type Array(String)
  2. Perform an insert and pass an array value [“doesn’t work”] to the column metaKey
  3. See clickhouse error as the apostrophe isn’t correctly escaped

B3none avatar Jul 11 '22 20:07 B3none

this can fix: https://github.com/TimonKK/clickhouse/commit/a60cbc0972e00d1c1db4dbc8a32f1d9e72801dc3

SEA99 avatar Aug 15 '22 08:08 SEA99

https://github.com/TimonKK/clickhouse/pull/134 will solve

SEA99 avatar Aug 24 '22 07:08 SEA99

merged (and included into tests), try on latest version

SEA99 avatar Aug 26 '22 11:08 SEA99