diff options
author | Bernt M. Johnsen <bernt.johnsen@sun.com> | 2009-07-03 10:19:32 +0200 |
---|---|---|
committer | Bernt M. Johnsen <bernt.johnsen@sun.com> | 2009-07-03 10:19:32 +0200 |
commit | e0a3403b457a5458915131732561caad9d8c6871 (patch) | |
tree | 1a615bba1d904454d0caa832e21340036af62321 /mysql-test/r/sp-fib.result | |
parent | 3cd431d553d722ec56db2635d88b8bb17087952a (diff) | |
download | mariadb-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.result | 21 |
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| |