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
|
# name: test/sql/catalog/function/attached_macro.test
# description: Call a table function living in a different catalog.
# group: [function]
statement ok
ATTACH ':memory:' AS checksum_macro;
statement ok
CREATE MACRO checksum_macro.checksum(table_name) AS TABLE
SELECT bit_xor(md5_number(COLUMNS(*)::VARCHAR))
FROM query_table(table_name);
# Use 'query_table' with a schema-qualified table name.
statement ok
BEGIN
statement ok
CREATE TABLE tbl AS SELECT UNNEST([42, 43]) AS x;
statement ok
USE checksum_macro;
query I
SELECT * FROM checksum('memory.tbl');
----
60609334165039584609948387465088153270
statement ok
ABORT
# Call a table function that lives in a different catalog
statement ok
BEGIN
statement ok
USE memory;
statement ok
CREATE TABLE tbl AS SELECT UNNEST([42, 43]) AS x;
statement ok
SELECT * FROM checksum_macro.checksum('tbl');
statement ok
ABORT
|
