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/json/test_json_empty_object.test
# description: Test empty objects in JSON (DuckDB cannot have empty STRUCT)
# group: [json]
require json
statement ok
pragma enable_verification
# returns JSON instead of {}
query I
select json_structure('{}')
----
"JSON"
statement error
select json_transform('{}', '{}')
----
Binder Error: Empty object in JSON structure
# create a JSON file with an empty struct
statement ok
copy (select '{"a": {}}') to '__TEST_DIR__/my.json' (FORMAT CSV, quote '', header 0)
# auto-detection should not give back an empty struct
query T
select typeof(a) from '__TEST_DIR__/my.json'
----
MAP(VARCHAR, JSON)
# can't force it to have an empty struct
statement error
select * from read_json('__TEST_DIR__/my.json', columns={a: 'STRUCT()'})
----
Invalid Input Error: Value "STRUCT()" can not be converted to a DuckDB Type.
# test issue 6443
statement ok
copy (select unnest(['{"c1":"val11","c2":{"k1":"val11","k2":{}}}','{"c1":"val21","c2":{"k1":"val21","k2":{}}}'])) to '__TEST_DIR__/data.ndjson' (FORMAT CSV, quote '', header 0)
statement ok
CREATE OR REPLACE TABLE tbl AS SELECT * FROM read_ndjson_auto('__TEST_DIR__/data.ndjson');
# no empty struct here either
query II
select typeof(c1), typeof(c2) from tbl;
----
VARCHAR STRUCT(k1 VARCHAR, k2 MAP(VARCHAR, JSON))
VARCHAR STRUCT(k1 VARCHAR, k2 MAP(VARCHAR, JSON))
require parquet
statement ok
copy tbl to '__TEST_DIR__/data.parquet';
query II
select * from '__TEST_DIR__/data.parquet';
----
val11 {'k1': val11, 'k2': {}}
val21 {'k1': val21, 'k2': {}}
|
