-
Notifications
You must be signed in to change notification settings - Fork 6
http engine fails to parse arrays with quoted strings #142
Copy link
Copy link
Labels
bugSomething isn't workingSomething isn't workingdriversImprove binary and/or http driver supportImprove binary and/or http driver support
Description
Test:
SELECT clickhouse_raw_query('CREATE TABLE http_inserts_test.arrays (
c1 Int32, c2 Array(Int32), c3 Array(String)
) ENGINE = MergeTree PARTITION BY c1 ORDER BY (c1);
');
INSERT INTO arrays VALUES
(1, ARRAY[1,2], ARRAY['x']),
(2, ARRAY[3,4,5], ARRAY['😀', '🦁']),
(3, ARRAY[6,4], ARRAY['Oberlin', 'O''Berlin']),
(4, '{}'::int[], '{"[bracketed]"}'::text[]),
(5, ARRAY[0], ARRAY['[]']);
SELECT * FROM arrays ORDER BY c1;Output from the SELECT:
ERROR: malformed array literal: "{'{bracketed}'}"
DETAIL: Unexpected "{" character.
Spotted by @serprex.
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
bugSomething isn't workingSomething isn't workingdriversImprove binary and/or http driver supportImprove binary and/or http driver support