1 -- source include/have_ndb.inc
2 -- source include/not_embedded.inc
5 drop table if exists t1;
9 a int not null primary key,
12 insert into t1 values (1,10), (2,20), (3,100), (4, 100);
15 create procedure test_proc1 (in var_in int)
17 select * from t1 where a = var_in;
19 create procedure test_proc2 (out var_out int)
21 select b from t1 where a = 1 into var_out;
23 create procedure test_proc3 (inout var_inout int)
25 select b from t1 where a = var_inout into var_inout;
30 call test_proc2(@test_var);
33 call test_proc3(@test_var);
35 alter procedure test_proc1 comment 'new comment';
36 show create procedure test_proc1;
37 drop procedure test_proc1;
38 drop procedure test_proc2;
39 drop procedure test_proc3;
42 --echo End of 5.1 tests