1
SET @session_max_recursion_depth = @@SESSION.max_sp_recursion_depth;
2
'#--------------------FN_DYNVARS_099_01-------------------------#'
3
** Connecting test_con1 using username 'root' **
4
** Connection test_con1 **
5
SET @@session.max_sp_recursion_depth = 10;
6
SELECT @@session.max_sp_recursion_depth;
7
@@session.max_sp_recursion_depth
9
DROP PROCEDURE IF EXISTS sp_addRecords;
10
CREATE PROCEDURE sp_addRecords (IN var1 INT,IN var2 INT)
14
CALL sp_addRecords(var1+1,var2);
18
CALL sp_addRecords(0,8);
53
'#--------------------FN_DYNVARS_099_02-------------------------#'
54
** Connecting test_con2 using username 'root' **
55
** Connection test_con2 **
56
SET @@session.max_sp_recursion_depth = 4;
57
SELECT @@session.max_sp_recursion_depth;
58
@@session.max_sp_recursion_depth
60
DROP PROCEDURE IF EXISTS sp_addRecords1;
61
CREATE PROCEDURE sp_addRecords1 (IN var1 INT,IN var2 INT)
65
CALL sp_addRecords1(var1+1,var2);
69
CALL sp_addRecords1(0,4);
88
'#---------------------FN_DYNVARS_99_03----------------------#'
89
SET @@max_sp_recursion_depth = 10;
90
DROP PROCEDURE IF EXISTS sp_addRecords2;
91
CREATE PROCEDURE sp_addRecords2(IN var1 INT,IN var2 INT)
95
CALL sp_addRecords2(var1+1,var2);
99
CALL sp_addRecords2(0,8);
134
'#---------------------FN_DYNVARS_99_04----------------------#'
135
SET @@max_sp_recursion_depth = 4;
136
DROP PROCEDURE IF EXISTS sp_addRecords3;
137
CREATE PROCEDURE sp_addRecords3 (IN var1 INT,IN var2 INT)
141
CALL sp_addRecords3(var1+1,var2);
145
Expected error 'SP Recursion limit'
146
CALL sp_addRecords3(0,8);
157
ERROR HY000: Recursive limit 4 (as set by the max_sp_recursion_depth variable) was exceeded for routine sp_addRecords3
158
** Connection default **
159
** Disconnecting test_con1, test_con2 **
160
DROP PROCEDURE IF EXISTS sp_addRecords;
161
DROP PROCEDURE IF EXISTS sp_addRecords1;
162
DROP PROCEDURE IF EXISTS sp_addRecords2;
163
DROP PROCEDURE IF EXISTS sp_addRecords3;
164
SET @@SESSION.max_sp_recursion_depth = @session_max_recursion_depth;