2
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
5
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
7
DROP PROCEDURE IF EXISTS test.p1;
8
DROP PROCEDURE IF EXISTS test.p2;
9
DROP PROCEDURE IF EXISTS test.p3;
10
DROP PROCEDURE IF EXISTS test.p4;
11
DROP TABLE IF EXISTS test.t1;
12
DROP TABLE IF EXISTS test.t2;
13
CREATE PROCEDURE test.p1()
15
INSERT INTO test.t1 VALUES(2);
17
CREATE PROCEDURE test.p2()
19
DROP TEMPORARY TABLE IF EXISTS test.t1;
20
CREATE TEMPORARY TABLE test.t1 (a int, PRIMARY KEY(a));
21
INSERT INTO test.t1 VALUES(1);
25
SELECT * FROM test.t1 ORDER BY a;
31
CREATE PROCEDURE test.p3()
33
INSERT INTO test.t2 VALUES(7);
35
CREATE PROCEDURE test.p4()
37
DROP TABLE IF EXISTS test.t2;
38
CREATE TABLE test.t2 (a int, PRIMARY KEY(a));
39
INSERT INTO test.t2 VALUES(6);
43
SELECT * FROM test.t2 ORDER BY a;
47
SELECT * FROM test.t2 ORDER BY a;
51
DROP PROCEDURE IF EXISTS test.p1;
52
DROP PROCEDURE IF EXISTS test.p2;
53
DROP PROCEDURE IF EXISTS test.p3;
54
DROP PROCEDURE IF EXISTS test.p4;
55
DROP TABLE IF EXISTS test.t1;
56
DROP TABLE IF EXISTS test.t2;