summaryrefslogtreecommitdiff
path: root/mysql-test/r/sp.result
diff options
context:
space:
mode:
authorBernt M. Johnsen <bernt.johnsen@sun.com>2009-06-04 13:38:53 +0200
committerBernt M. Johnsen <bernt.johnsen@sun.com>2009-06-04 13:38:53 +0200
commit5068840bd85e57862bbc4113b098624c535dc4f5 (patch)
tree445fdb73f9c6a80f420670136b498eb62fda6a7f /mysql-test/r/sp.result
parent1a1ffe7312d54247c4aa05bdedfd8fd15adf36a5 (diff)
downloadmariadb-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.result46
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