sys_vars.max_sp_recursion_depth_func     [ fail ]

        Test ended at 2014-11-24 15:25:04

CURRENT_TEST: sys_vars.max_sp_recursion_depth_func

mysqltest: At line 64: query 'CALL sp_addRecords(0,8)' failed: 1436: Thread stack overrun:  172008 bytes used of a 294912 byte stack, and 128000 bytes needed.  Use 'mysqld --thread_stack=#' to specify a bigger stack.

The result from queries just before the failure was:

< snip >

** Connection test_con1 **

SET @@session.max_sp_recursion_depth = 10;

SELECT @@session.max_sp_recursion_depth;

@@session.max_sp_recursion_depth

10

DROP PROCEDURE IF EXISTS sp_addRecords;

CREATE PROCEDURE sp_addRecords (IN var1 INT,IN var2 INT)

BEGIN

SELECT var1,var2;

IF var1 < var2 THEN

CALL sp_addRecords(var1+1,var2);

SELECT var1,var2;

END IF;

END //

CALL sp_addRecords(0,8);

main.signal_demo3                        [ fail ]

        Test ended at 2014-11-24 15:19:00

CURRENT_TEST: main.signal_demo3

mysqltest: At line 107: query 'call proc_1()' failed with wrong errno 1436: 'Thread stack overrun:  172008 bytes used of a 294912 byte stack, and 128000 bytes needed.  Use 'mysqld --thread_stack=#' to specify a bigger stack.', instead of 1644...

The result from queries just before the failure was:

< snip >

resignal sqlstate '45000' set message_text='Oops in proc_7';

call proc_8();

end

$$

create procedure proc_8()

begin

declare exit handler for sqlexception

resignal sqlstate '45000' set message_text='Oops in proc_8';

call proc_9();

end

$$

create procedure proc_9()

begin

declare exit handler for sqlexception

resignal sqlstate '45000' set message_text='Oops in proc_9';

## Do something that fails, to see how errors are reported

drop table oops_it_is_not_here;

end

$$

call proc_1();