Bug #36726 Test funcs_1.<engine>_storedproc failing - Needs to be updated on 5.1+
Submitted: 14 May 2008 20:46 Modified: 28 Jul 2008 18:16
Reporter: Patrick Crews Email Updates:
Status: Closed Impact on me:
None 
Category:Tests: Server Severity:S3 (Non-critical)
Version:5.1+ OS:Any
Assigned to: Patrick Crews CPU Architecture:Any
Tags: funcs_1, SQLSTATE, stored procedure, Tests

[14 May 2008 20:46] Patrick Crews
Description:
Test funcs_1.<engine>_storedproc is failing due to work done for
Bug #8759	Stored Procedures: SQLSTATE '00000' should be illegal

The following statement from funcs_1/storedproc/storedproc_master.inc is failing as a result of the work done for Bug#8759
delimiter //;
CREATE PROCEDURE sp1()
BEGIN
    declare continue handler for sqlstate '00000'  set @var2 = 1;
    set @x=1;
          SELECT @var2;
END//
delimiter ;//

CALL sp1();

How to repeat:
Run the test on 5.1+
./mysql-test-run --suite=funcs_1 --do-test storedproc
You will see the following error:  +ERROR 42000: Bad SQLSTATE: '00000'
is now being issued.

Suggested fix:
Correct the test to expect the error message that should be issued and re-record the results file to account for this change.
[27 May 2008 23:31] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/47113
[28 Jul 2008 16:50] Bugs System
Pushed into 5.1.27  (revid:joerg@mysql.com-20080626161101-h5hsaluwtf05xdr2) (version source revid:joerg@mysql.com-20080626161101-h5hsaluwtf05xdr2) (pib:3)
[28 Jul 2008 17:58] Paul DuBois
Test case change. No 5.1.x changelog entry needed.

Setting report to Patch Queued pending push of fix into 6.0.x.
[28 Jul 2008 18:01] Patrick Crews
pushed into 5.1.25-rc
pushed in 6.0.6-alpha
[28 Jul 2008 18:16] Paul DuBois
Test case change. No 6.0.x changelog entry needed.