diff options
author | Bernt M. Johnsen <bernt.johnsen@sun.com> | 2009-06-04 13:38:53 +0200 |
---|---|---|
committer | Bernt M. Johnsen <bernt.johnsen@sun.com> | 2009-06-04 13:38:53 +0200 |
commit | 5068840bd85e57862bbc4113b098624c535dc4f5 (patch) | |
tree | 445fdb73f9c6a80f420670136b498eb62fda6a7f /mysql-test/r/sp.result | |
parent | 1a1ffe7312d54247c4aa05bdedfd8fd15adf36a5 (diff) | |
download | mariadb-git-5068840bd85e57862bbc4113b098624c535dc4f5.tar.gz |
Bug#15866 main.sp-fib split from main.sp
Diffstat (limited to 'mysql-test/r/sp.result')
-rw-r--r-- | mysql-test/r/sp.result | 46 |
1 files changed, 0 insertions, 46 deletions
diff --git a/mysql-test/r/sp.result b/mysql-test/r/sp.result index 236fa3d8681..f66d31a3295 100644 --- a/mysql-test/r/sp.result +++ b/mysql-test/r/sp.result @@ -1337,52 +1337,6 @@ drop procedure opp| drop procedure ip| show procedure status like '%p%'| Db Name Type Definer Modified Created Security_type Comment -drop table if exists t3| -create table t3 ( f bigint unsigned not null )| -drop procedure if exists fib| -create procedure fib(n int unsigned) -begin -if n > 1 then -begin -declare x, y bigint unsigned; -declare c cursor for select f from t3 order by f desc limit 2; -open c; -fetch c into y; -fetch c into x; -close c; -insert into t3 values (x+y); -call fib(n-1); -end; -end if; -end| -set @@max_sp_recursion_depth= 20| -insert into t3 values (0), (1)| -call fib(3)| -select * from t3 order by f asc| -f -0 -1 -1 -2 -delete from t3| -insert into t3 values (0), (1)| -call fib(10)| -select * from t3 order by f asc| -f -0 -1 -1 -2 -3 -5 -8 -13 -21 -34 -55 -drop table t3| -drop procedure fib| -set @@max_sp_recursion_depth= 0| drop procedure if exists bar| create procedure bar(x char(16), y int) comment "111111111111" sql security invoker |