← Back to branch summary

~danielpvolpato/mysql-server/parallel-mysqldump

« back to all changes in this revision

Viewing changes to mysql-test/suite/funcs_1/r/ndb_storedproc_02.result

Merge from main 5.1 to 5.1-build

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/suite/funcs_1/r/ndb_storedproc_02.result
583
583
CALL h1();
584
584
x1      x2      x3      x4      x5      x6
585
585
1       1       1       1       1       1
 
586
This will fail, SQLSTATE 00000 is not allowed
586
587
CREATE PROCEDURE sp1()
587
588
begin1_label:BEGIN
588
589
declare exit handler for sqlstate '00000' set @var1 = 5;
594
595
END begin2_label;
595
596
SELECT @var1, @var2;
596
597
END begin1_label//
 
598
ERROR 42000: Bad SQLSTATE: '00000'
 
599
Verify SP wasn't created
597
600
CALL sp1();
598
 
@var3   @var4
599
 
NULL    8
600
 
@var1   @var2
601
 
NULL    6
 
601
ERROR 42000: PROCEDURE db_storedproc.sp1 does not exist
602
602
DROP PROCEDURE p1;
603
603
DROP PROCEDURE h1;
604
 
DROP PROCEDURE sp1;
 
604
DROP PROCEDURE IF EXISTS sp1;
605
605
DROP TABLE res_t1;
606
606
 
607
607
Testcase 3.1.2.50: