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 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107
|
# name: test/sql/copy/csv/test_afl.test
# description: Test the sniffer properly detects quotes values
# group: [csv]
statement ok
PRAGMA enable_verification
statement maybe
FROM read_csv('{DATA_DIR}/csv/afl/1.csv', force_not_null=012%0);
----
statement maybe
FROM read_csv('{DATA_DIR}/csv/afl/2.csv', max_line_size=-9151315542319464311);
----
statement maybe
FROM read_csv('{DATA_DIR}/csv/afl/3.csv', max_line_size=-1003718790012071149, ignore_errors=true);
----
statement maybe
FROM read_csv('{DATA_DIR}/csv/afl/4.csv', max_line_size=-432344490485710328, all_varchar=false);
----
statement maybe
FROM read_csv('{DATA_DIR}/csv/afl/5.csv', max_line_size=-68088296696312078);
----
statement maybe
FROM read_csv('{DATA_DIR}/csv/afl/6.csv', buffer_size=42);
----
statement maybe
FROM read_csv('{DATA_DIR}/csv/afl/7.csv', buffer_size=42);
----
statement maybe
FROM read_csv('{DATA_DIR}/csv/afl/8.csv', buffer_size=42);
----
statement maybe
FROM read_csv('{DATA_DIR}/csv/afl/9.csv', buffer_size=42);
----
statement maybe
FROM read_csv('{DATA_DIR}/csv/afl/10.csv', buffer_size=42);
----
statement maybe
FROM read_csv('{DATA_DIR}/csv/afl/11.csv', max_line_size=-7987305294711008699, rejects_limit=42);
----
statement maybe
FROM read_csv('{DATA_DIR}/csv/afl/12.csv', rejects_table='d');
----
statement maybe
FROM read_csv('{DATA_DIR}/csv/afl/13.csv', rejects_table='d');
----
statement maybe
FROM read_csv('{DATA_DIR}/csv/afl/14.csv', rejects_table='d');
----
statement maybe
FROM read_csv('{DATA_DIR}/csv/afl/15.csv', rejects_table='d');
----
statement maybe
FROM read_csv('{DATA_DIR}/csv/afl/16.csv', rejects_table='d');
----
statement maybe
FROM read_csv('{DATA_DIR}/csv/afl/17.csv', rejects_table='d');
----
statement maybe
FROM read_csv('{DATA_DIR}/csv/afl/18.csv', rejects_table='d');
----
statement maybe
FROM read_csv('{DATA_DIR}/csv/afl/19.csv', rejects_table='d');
----
statement maybe
FROM read_csv('{DATA_DIR}/csv/afl/20.csv', rejects_table='d');
----
statement maybe
FROM read_csv('{DATA_DIR}/csv/afl/21.csv', rejects_table='d');
----
statement maybe
FROM read_csv('{DATA_DIR}/csv/afl/22.csv', rejects_table='d');
----
statement maybe
FROM read_csv('{DATA_DIR}/csv/afl/23.csv', buffer_size=42);
----
statement maybe
FROM read_csv('{DATA_DIR}/csv/afl/24.csv', buffer_size=26, delim=';', header=true, allow_quoted_nulls=true, allow_quoted_nulls=true);
----
statement maybe
FROM read_csv('{DATA_DIR}/csv/afl/25.csv', buffer_size=734771105608237082, max_line_size=-8825501086615982989, allow_quoted_nulls=true);
----
|