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
|
# name: test/sql/copy/csv/test_copy_default.test
# description: Test copy statement with default values
# group: [csv]
statement ok
PRAGMA enable_verification
# load CSV file into a table
statement ok
CREATE TABLE test (a INTEGER, b VARCHAR DEFAULT('hello'), c INTEGER DEFAULT(3+4));
query I
COPY test (a) FROM '{DATA_DIR}/csv/test/test_default.csv';
----
5000
query I
COPY test (c) FROM '{DATA_DIR}/csv/test/test_default.csv';
----
5000
query IIIIIRR
SELECT COUNT(a), COUNT(b), COUNT(c), MIN(LENGTH(b)), MAX(LENGTH(b)), SUM(a), SUM(c) FROM test;
----
5000 10000 10000 5 5 12497500.000000 12532500.000000
|
