1create table t1 (a int not null); 2drop procedure if exists p1| 3CREATE PROCEDURE p1() 4BEGIN 5DECLARE EXIT HANDLER FOR SQLEXCEPTION select a from t1; 6prepare s1 from ' 7 select a from t1 where a in ( 8 select a from t1 where a in ( 9 select a from t1 where a in ( 10 select a from t1 where a in ( 11 select a from t1 where a in ( 12 select a from t1 where a in ( 13 select a from t1 where a in ( 14 select a from t1 where a in ( 15 select a from t1 where a in ( 16 select a from t1 where a in ( 17 select a from t1 where a in ( 18 select a from t1 where a in ( 19 select a from t1 where a in ( 20 select a from t1 where a in ( 21 select a from t1 where a in ( 22 select a from t1 where a in ( 23 select a from t1 where a in ( 24 select a from t1 where a in ( 25 select a from t1 where a in ( 26 select a from t1 where a in ( 27 select a from t1 where a in ( 28 select a from t1 where a in ( 29 select a from t1 where a in ( 30 select a from t1 where a in ( 31 select a from t1 where a in ( 32 select a from t1 where a in ( 33 select a from t1 where a in ( 34 select a from t1 where a in ( 35 select a from t1 where a in ( 36 select a from t1 where a in ( 37 select a from t1 where a in ( 38 select a from t1 where a in ( 39 select a from t1 where a in ( 40 select a from t1 where a in ( 41 select a from t1 where a in ( 42 select a from t1 where a in ( 43 select a from t1 where a in ( 44 select a from t1 where a in ( 45 select a from t1 where a in ( 46 select a from t1 where a in ( 47 select a from t1 where a in ( 48 select a from t1 where a in ( 49 select a from t1 where a in ( 50 select a from t1 where a in ( 51 select a from t1 where a in ( 52 select a from t1 where a in ( 53 select a from t1 where a in ( 54 select a from t1 where a in ( 55 select a from t1 where a in ( 56 select a from t1 where a in ( 57 select a from t1 where a in ( 58 select a from t1 where a in ( 59 select a from t1 where a in ( 60 select a from t1 where a in ( 61 select a from t1 where a in ( 62 select a from t1 where a in ( 63 select a from t1 where a in ( 64 select a from t1 where a in ( 65 select a from t1 where a in ( 66 select a from t1 where a in ( 67 select a from t1 where a in ( 68 select a from t1 where a in ( select a from t1) 69 )))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))'; 70execute s1; 71END; 72| 73call p1(); 74a 75drop procedure p1; 76drop table t1; 77