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 TABLE IF EXISTS test.t1;
9 DROP TABLE IF EXISTS test.t2;
10 CREATE TABLE test.t1 (a INT, PRIMARY KEY(a));
11 INSERT INTO test.t1 VALUES (1),(2),(3),(4);
12 CREATE TABLE test.t2 (a INT, PRIMARY KEY(a));
13 CREATE PROCEDURE test.p1 (arg1 CHAR(1))
18 DECLARE cur1 CURSOR FOR SELECT A FROM test.t1 WHERE a % 2;
19 DECLARE continue handler for not found set b = 1;
27 INSERT INTO test.t2 VALUES (c);
35 DECLARE cur2 CURSOR FOR SELECT a FROM test.t1 WHERE NOT a % 2;
36 DECLARE continue handler for not found set b = 1;
44 INSERT INTO test.t2 VALUES (c);
52 SELECT * FROM test.t2 ORDER BY a;
56 SELECT * FROM test.t2 ORDER BY a;
62 select * from test.t2 ORDER BY a;
66 SELECT * FROM test.t2 ORDER BY a;
71 SELECT * FROM test.t2 ORDER BY a;
73 SELECT * FROM test.t2 ORDER BY a;
75 DROP PROCEDURE test.p1;