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
|
# name: test/sql/json/test_json_export.test
# description: Test Json Export
# group: [json]
require json
statement ok
PRAGMA enable_verification
statement ok
create table text(i varchar);
statement ok
insert into text values ('bla');
statement ok
export database '__TEST_DIR__/test_export' (FORMAT JSON);
statement ok
drop table text;
statement ok
import database '__TEST_DIR__/test_export';
query I
select * from text;
----
bla
statement ok
COPY text TO '__TEST_DIR__/text.json' (ARRAY)
statement ok
drop table text;
statement ok
create table text(i varchar);
statement ok
COPY text from '__TEST_DIR__/text.json' (ARRAY)
query I
select * from text;
----
bla
query I
select * from '__TEST_DIR__/text.json';
----
bla
|
