1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
|
# name: test/sql/copy/csv/test_issue3562_assertion.test
# description: Test copy from with decimal type specifier
# group: [csv]
statement ok
PRAGMA enable_verification
statement ok
create table test as SELECT * FROM read_csv('{DATA_DIR}/csv/test/issue3562_assertion.csv.gz', columns={'OBJECTID': 'DECIMAL(18,3)', 'URL': 'TEXT', 'NAME': 'TEXT', 'the_geom':'TEXT', 'LINE': 'TEXT'});
query II
select objectid, name from test ORDER BY objectid limit 10
----
1.000 15th St & Kings Hwy at SE corner
2.000 15th St & Avenue U at SE corner
3.000 15th St & Gravesend Neck Rd at NE corner
4.000 15th St & Sheepshead Bay Rd at SE corner
5.000 NULL
6.000 Branch 7 St & Brighton Beach Rd at NE corner
7.000 Branch 7 St & Brighton Beach Rd at SE corner
8.000 Branch 7 St & Brighton Beach Rd at SE corner
9.000 Ocean Pkwy & Brighton Beach Rd at NE corner
10.000 Ocean Pkwy & Brighton Beach Rd at NE corner
|
