1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
|
# name: test/sql/copy/csv/test_csv_column_count_mismatch.test_slow
# description: Test cranlogs broken gzip copy and temp table
# group: [csv]
statement ok
pragma enable_verification;
# We can read with auto just fine
statement ok
select * from read_csv_auto('{DATA_DIR}/csv/people.csv');
# Specifying columns, but not specifying the right amount throws an error
statement error
select * from read_csv_auto('{DATA_DIR}/csv/people.csv', columns={'a': 'VARCHAR'}, auto_detect = false, strict_mode=True)
----
Expected Number of Columns: 1 Found: 2
# When we do specify the right amount of columns, everything works
statement ok
select * from read_csv_auto('{DATA_DIR}/csv/people.csv', columns={'a': 'VARCHAR', 'b': 'VARCHAR'})
|
