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
|
# name: test/sql/catalog/function/struct_extract_macro.test
# description: Test struct extract on a macro
# group: [function]
statement ok
PRAGMA enable_verification
statement ok
CREATE MACRO my_extract(x) AS x.a.b
query I
SELECT my_extract({'a': {'b': 42}})
----
42
mode skip
# FIXME: this does not work yet due to the way in which macro functions are bound
# as it is not trivial to fix, for now we leave it as is
statement ok
CREATE MACRO my_subquery_extract(x) AS (SELECT x.a.b);
query I
SELECT my_subquery_extract({'a': {'b': 42}})
----
42
mode unskip
|
