diff options
author | Bernt M. Johnsen <bernt.johnsen@sun.com> | 2009-06-04 13:53:15 +0200 |
---|---|---|
committer | Bernt M. Johnsen <bernt.johnsen@sun.com> | 2009-06-04 13:53:15 +0200 |
commit | caa703b1e34d7a154d51ff93e5c03735405bc8a3 (patch) | |
tree | 456a359ee4d8d7c3ece954a454b0c560ae7a523a /mysql-test/r/sp.result | |
parent | 5fb8b93e98a57ee55143b8b1de9cefeaf6d7bb95 (diff) | |
parent | a3ac1f7e7832b92de2d3c9d05cc4b5046c5264f1 (diff) | |
download | mariadb-git-caa703b1e34d7a154d51ff93e5c03735405bc8a3.tar.gz |
Bug#15866 ported from 5.0-gca
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 9574841bc35..3ad556b8c30 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 where name like '%p%' and db='test'| Db Name Type Definer Modified Created Security_type Comment character_set_client collation_connection Database Collation -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 -truncate table 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 |