1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
|
# name: test/sql/copy/csv/test_prefix_suffix.test
# description: Test prefix/suffix options
# group: [csv]
statement ok
PRAGMA enable_verification
statement error
copy (select 42) to '__TEST_DIR__/file.csv' (prefix 'a');
----
must have both PREFIX and SUFFIX
statement error
copy (select 42) to '__TEST_DIR__/file.csv' (prefix 'a', suffix 'b', header);
----
HEADER cannot be combined with PREFIX/SUFFIX
statement error
copy (select 42) to '__TEST_DIR__/file.csv' (escape 'null', null 'null');
----
The escape option cannot exceed a size of 1 byte.
|
