Bug #15630 Test case failure in sp-dynamic, sp-error, and sp
Description:
The test cases sp-dynamic, sp-error, and sp fail repeatably on various 64-bit platforms:
10712: sp-dynamic [ fail ]
10713:
10714: Errors are (from /home/mysqldev/pegasos3-glibc23/test/mysql-max-5.0.17-linux-powerpc-glibc23/mysql-test/var/log/mysqltest-time) :
10715: mysqltest: Result length mismatch
10716: (the last lines may be the most important ones)
10717: Below are the diffs between actual and expected results:
10718: -------------------------------------------------------
10719: *** r/sp-dynamic.result 2005-12-08 08:59:38.000000000 +0300
10720: --- r/sp-dynamic.reject 2005-12-08 11:46:10.575001491 +0300
10721: ***************
10722: *** 49,59 ****
10723: ERROR HY000: The prepared statement contains a stored routine call that refers to that same statement. It's not allowed to execute a prepared statement in such a recursive manner
10724: set @@max_sp_recursion_depth=@SAVE_SP_RECURSION_LEVELS|
10725: call p1()|
10726: ! ERROR HY000: Recursive limit 0 (as set by the max_sp_recursion_depth variable) was exceeded for routine p1
10727: call p1()|
10728: ! ERROR HY000: Recursive limit 0 (as set by the max_sp_recursion_depth variable) was exceeded for routine p1
10729: call p1()|
10730: ! ERROR HY000: Recursive limit 0 (as set by the max_sp_recursion_depth variable) was exceeded for routine p1
10731: drop procedure p1|
10732: create procedure p1()
10733: begin
10734: --- 49,59 ----
10735: ERROR HY000: The prepared statement contains a stored routine call that refers to that same statement. It's not allowed to execute a prepared statement in such a recursive manner
10736: set @@max_sp_recursion_depth=@SAVE_SP_RECURSION_LEVELS|
10737: call p1()|
10738: ! ERROR HY000: Recursive limit 0 (as set by the max_sp_recursion_depth variable) was exceeded for routine ¾Ùè
10739: call p1()|
10740: ! ERROR HY000: Recursive limit 0 (as set by the max_sp_recursion_depth variable) was exceeded for routine ¾Ùè
10741: call p1()|
10742: ! ERROR HY000: Recursive limit 0 (as set by the max_sp_recursion_depth variable) was exceeded for routine ¾Ùè
10743: drop procedure p1|
10744: create procedure p1()
10745: begin
How to repeat:
run the test cases on the affected platforms: linux-powerpc, solaris-sparc.
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.056 sec. using MySQL 8.4.7-u6-cloud
Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the
respective copyright holders.
It is not reviewed in advance
by Oracle and does not necessarily represent the opinion of
Oracle or any other party.