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
|
# name: test/sql/prepared/test_prepare_drop.test
# description: PREPARE and DROPping tables
# group: [prepared]
statement ok con1
CREATE TABLE a (i TINYINT)
statement ok con2
PREPARE p1 AS SELECT * FROM a
statement ok con2
EXECUTE p1
# only the conn which did the prepare can execute
statement error con1
EXECUTE p1
----
# we can drop the table though
statement ok con1
DROP TABLE a
# after dropping the table, the statement fails
statement error con2
EXECUTE p1
----
# but when we take the statement away
statement ok con2
DEALLOCATE p1
|
