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
61
62
63
64
65
66
67
68
69
70
71
72
73
|
# name: test/sql/catalog/function/test_macro_relpersistence_conflict.test
# description: Test Macro temporary/if exists/or replace
# group: [function]
load __TEST_DIR__/my_macro_database.db
statement ok
PRAGMA disable_checkpoint_on_shutdown
statement ok
PRAGMA wal_autocheckpoint='1TB';
statement ok
create macro test(a, b) as a + b
query T
select test(4, 2)
----
6
statement ok
create or replace macro test(a, b) as a + a
# should be different now
query T
select test(4, 2)
----
8
# should be ignored
statement ok
create macro if not exists test(a, b) as a + b
query T
select test(4, 2)
----
8
statement ok
drop macro test
# now let's do the same stuff with a temporary macro
statement ok
create temporary macro test(a, b) as a + b
query T
select test(4, 2)
----
6
statement ok
create or replace temporary macro test(a, b) as a + a
query T
select test(4, 2)
----
8
statement ok
create temporary macro if not exists test(a, b) as a + b
query T
select test(4, 2)
----
8
restart
# macro should be gone
statement error
select test(4, 2)
----
<REGEX>:.*Catalog Error.*does not exist.*
|
