Debian Codegraph @

mysql-test/suite/sys_vars/r/max_sp_recursion_depth_func.result

raw
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
8 10
9 DROP PROCEDURE IF EXISTS sp_addRecords;
10 CREATE PROCEDURE sp_addRecords (IN var1 INT,IN var2 INT)
11 BEGIN
12 SELECT var1,var2;
13 IF var1 < var2 THEN
14 CALL sp_addRecords(var1+1,var2);
15 SELECT var1,var2;
16 END IF;
17 END //
18 CALL sp_addRecords(0,8);
19 var1 var2
20 0 8
21 var1 var2
22 1 8
23 var1 var2
24 2 8
25 var1 var2
26 3 8
27 var1 var2
28 4 8
29 var1 var2
30 5 8
31 var1 var2
32 6 8
33 var1 var2
34 7 8
35 var1 var2
36 8 8
37 var1 var2
38 7 8
39 var1 var2
40 6 8
41 var1 var2
42 5 8
43 var1 var2
44 4 8
45 var1 var2
46 3 8
47 var1 var2
48 2 8
49 var1 var2
50 1 8
51 var1 var2
52 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
59 4
60 DROP PROCEDURE IF EXISTS sp_addRecords1;
61 CREATE PROCEDURE sp_addRecords1 (IN var1 INT,IN var2 INT)
62 BEGIN
63 SELECT var1,var2;
64 IF var1 < var2 THEN
65 CALL sp_addRecords1(var1+1,var2);
66 SELECT var1,var2;
67 END IF;
68 END //
69 CALL sp_addRecords1(0,4);
70 var1 var2
71 0 4
72 var1 var2
73 1 4
74 var1 var2
75 2 4
76 var1 var2
77 3 4
78 var1 var2
79 4 4
80 var1 var2
81 3 4
82 var1 var2
83 2 4
84 var1 var2
85 1 4
86 var1 var2
87 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)
92 BEGIN
93 SELECT var1,var2;
94 IF var1 < var2 THEN
95 CALL sp_addRecords2(var1+1,var2);
96 SELECT var1,var2;
97 END IF;
98 END //
99 CALL sp_addRecords2(0,8);
100 var1 var2
101 0 8
102 var1 var2
103 1 8
104 var1 var2
105 2 8
106 var1 var2
107 3 8
108 var1 var2
109 4 8
110 var1 var2
111 5 8
112 var1 var2
113 6 8
114 var1 var2
115 7 8
116 var1 var2
117 8 8
118 var1 var2
119 7 8
120 var1 var2
121 6 8
122 var1 var2
123 5 8
124 var1 var2
125 4 8
126 var1 var2
127 3 8
128 var1 var2
129 2 8
130 var1 var2
131 1 8
132 var1 var2
133 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)
138 BEGIN
139 SELECT var1,var2;
140 IF var1 < var2 THEN
141 CALL sp_addRecords3(var1+1,var2);
142 SELECT var1,var2;
143 END IF;
144 END //
145 Expected error 'SP Recursion limit'
146 CALL sp_addRecords3(0,8);
147 var1 var2
148 0 8
149 var1 var2
150 1 8
151 var1 var2
152 2 8
153 var1 var2
154 3 8
155 var1 var2
156 4 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;