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
|
# name: test/sql/export/export_quoted_structs.test
# description: Test export database
# group: [export]
# create a bunch of tables with data and views
statement ok
PRAGMA enable_verification
statement ok
BEGIN TRANSACTION
# 'end' is a keyword, this has to be quoted
statement ok
create table a (s STRUCT("end" VARCHAR));
statement ok
insert into a values ({"end":'hello'});
query I
select * from a
----
{'end': hello}
## -- We don't support exporting user defined types yet -- ##
#statement ok
#create type "table" as varchar;
## The type of the struct field can also be a user-defined type, which might need quotes
#statement ok
#create table b (s STRUCT(f1 "table"));
#statement ok
#insert into b values ({'a':'hello'});
#query I
#select * from b;
#----
#{'f1': hello}
# now export the db
statement ok
EXPORT DATABASE '__TEST_DIR__/export_test' (FORMAT CSV)
statement ok
ROLLBACK
statement ok
IMPORT DATABASE '__TEST_DIR__/export_test'
# Verify that the import was successful
query I
select * from a
----
{'end': hello}
#query I
#select * from b;
#----
#{'f1': hello}
|
