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
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
|
# name: test/sql/explain/explain_all_statements.test
# description: Test explain on various statements
# group: [explain]
statement ok
pragma enable_verification
statement ok
explain PRAGMA enable_verification
statement ok
explain CREATE TABLE integers(i INTEGER);
# oops we didn't actually create it
statement error
explain SELECT * FROM integers;
----
statement error
explain INSERT INTO integers VALUES (1);
----
statement ok
CREATE TABLE integers(i INTEGER);
statement ok
explain SELECT * FROM integers;
statement ok
explain INSERT INTO integers VALUES (1);
statement ok
INSERT INTO integers VALUES (1);
statement ok
explain DELETE FROM integers WHERE i=1
statement ok
explain UPDATE integers SET i=i+1
statement ok
explain CREATE INDEX i_index ON integers(i)
statement ok
explain ALTER TABLE integers RENAME TO integers2
statement ok
explain ALTER TABLE integers ADD COLUMN j INTEGER
statement ok
explain ALTER TABLE integers RENAME i TO k
query I
SELECT * FROM integers
----
1
statement ok
explain PREPARE v1 AS SELECT * FROM integers WHERE i=?
statement ok
PREPARE v1 AS SELECT * FROM integers WHERE i=?
statement ok
explain EXECUTE v1(1);
statement ok
explain DEALLOCATE v1
query I
EXECUTE v1(1)
----
1
statement ok
explain VACUUM
statement ok
explain CREATE SEQUENCE seq
statement ok
explain CREATE VIEW v1 AS SELECT * FROM integers
statement ok
explain DROP TABLE integers
statement ok
explain CHECKPOINT
statement ok
explain BEGIN TRANSACTION
statement ok
explain SET memory_limit='1GB'
statement ok
explain CREATE MACRO f(x) AS x+1
statement error
SELECT f(1)
----
statement ok
CREATE MACRO f(x) AS x+1
query I
SELECT f(1)
----
2
|
