1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
|
# name: test/sql/copy/csv/test_quote_default.test
# description: Test quote and escape are set as default quoted option
# group: [csv]
statement ok
PRAGMA enable_verification
query II
from read_csv('{DATA_DIR}/csv/test_default_option.csv', columns = {'a':'varchar', 'b':'integer'}, auto_detect = false, header = true) where b = 1
----
x,y 1
query II
from read_csv('{DATA_DIR}/csv/test_default_option_2.csv', columns = {'a':'varchar', 'b':'integer'}, auto_detect = false, header = true, delim = '|') where b = 1
----
x|y 1
|
