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
|
# name: test/sql/copy/csv/struct_padding.test
# description: Verify that whitespace padding in struct VARCHAR fields are properly removed
# group: [csv]
statement ok
PRAGMA enable_verification
query I
SELECT * FROM read_csv('{DATA_DIR}/csv/test/struct_padding.csv', columns={'col': 'STRUCT(val VARCHAR)'}) ORDER BY 1;
----
{'val': ''}
{'val': ''}
{'val': ''}
{'val': ''}
{'val': ''}
{'val': ''}
{'val': ''}
{'val': x}
{'val': x}
{'val': x}
{'val': x}
{'val': y}
{'val': y}
{'val': y}
{'val': y}
|
