summaryrefslogtreecommitdiff
path: root/mysql-test/r/sp-fib.result
diff options
context:
space:
mode:
authorBernt M. Johnsen <bernt.johnsen@sun.com>2009-07-03 10:19:32 +0200
committerBernt M. Johnsen <bernt.johnsen@sun.com>2009-07-03 10:19:32 +0200
commite0a3403b457a5458915131732561caad9d8c6871 (patch)
tree1a615bba1d904454d0caa832e21340036af62321 /mysql-test/r/sp-fib.result
parent3cd431d553d722ec56db2635d88b8bb17087952a (diff)
downloadmariadb-git-e0a3403b457a5458915131732561caad9d8c6871.tar.gz
Bug#15866 Prepared for push on 5.0
Diffstat (limited to 'mysql-test/r/sp-fib.result')
-rw-r--r--mysql-test/r/sp-fib.result21
1 files changed, 4 insertions, 17 deletions
diff --git a/mysql-test/r/sp-fib.result b/mysql-test/r/sp-fib.result
index c51aa7d7ad1..a26e104c1e8 100644
--- a/mysql-test/r/sp-fib.result
+++ b/mysql-test/r/sp-fib.result
@@ -10,24 +10,17 @@ 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);
+## Close the cursor AFTER the recursion to ensure that the stack
+## frame is somewhat intact.
+close c;
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)|
+call fib(4)|
select * from t3 order by f asc|
f
0
@@ -35,12 +28,6 @@ f
1
2
3
-5
-8
-13
-21
-34
-55
drop table t3|
drop procedure fib|
set @@max_sp_recursion_depth= 0|