1 drop procedure if exists test.longprocedure;
2 drop table if exists t1;
3 create table t1 (a int);
4 insert into t1 values (1),(2),(3);
7 select length(routine_definition) from information_schema.routines where routine_schema = 'test' and routine_name = 'longprocedure';
8 length(routine_definition)
10 call test.longprocedure(@value);
14 drop procedure test.longprocedure;
16 create table t1 (f1 char(100) , f2 mediumint , f3 int , f4 real, f5 numeric);
17 insert into t1 (f1, f2, f3, f4, f5) values
18 ("This is a test case for for Bug#9819", 1, 2, 3.0, 4.598);
20 Note 1265 Data truncated for column 'f5' at row 1
21 create table t2 like t1;
22 select count(*) from t1;
25 select count(*) from t2;
28 drop procedure if exists p1;
31 declare done integer default 0;
32 declare vf1 char(100) ;
33 declare vf2 mediumint;
37 declare cur1 cursor for select f1,f2,f3,f4,f5 from t1;
38 declare continue handler for sqlstate '02000' set done = 1;
41 fetch cur1 into vf1, vf2, vf3, vf4, vf5;
43 insert into t2 values (vf1, vf2, vf3, vf4, vf5);
49 select count(*) from t1;
52 select count(*) from t2;
55 select f1 from t1 limit 1;
57 This is a test case for for Bug#9819
58 select f1 from t2 limit 1;
60 This is a test case for for Bug#9819