1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
|
# name: test/sql/cast/string_to_list_roundtrip.test
# group: [cast]
query III
select $$[\"abc\", def, ghi]$$::VARCHAR[] a, a::VARCHAR::VARCHAR[] b, a == b
----
['"abc"', def, ghi] ['"abc"', def, ghi] true
statement ok
COPY (select $$[\"abc\", def, ghi]$$::VARCHAR[] a) TO '__TEST_DIR__/copy_test.csv' (FORMAT CSV);
query II
select a, a::VARCHAR[] from read_csv('__TEST_DIR__/copy_test.csv') t(a);
----
['"abc"', def, ghi] ['"abc"', def, ghi]
# Leading and trailing whitespace preservation
query III
select $$[" \"abc\" ", def, ghi]$$::VARCHAR[] a, a::VARCHAR::VARCHAR[] b, a == b
----
[' "abc" ', def, ghi] [' "abc" ', def, ghi] true
# Escaping backslashes
query III
select $$[\ \\abc\\ \ , def, ghi]$$::VARCHAR[] a, a::VARCHAR::VARCHAR[] b, a == b
----
[\ \\abc\\ \, def, ghi] [\ \\abc\\ \, def, ghi] true
# Escaping backslashes
query III
select $$["\ \\abc\\ \ ", def, ghi]$$::VARCHAR[] a, a::VARCHAR::VARCHAR[] b, a == b
----
[' \\abc\\ ', def, ghi] [' \\abc\\ ', def, ghi] true
# Escaping '{' and '}'
query III
select $$[{}]$$::VARCHAR[] a, a::VARCHAR::VARCHAR[] b, a == b
----
['{}'] ['{}'] true
|
