diff options
| author | pem@mysql.com <> | 2005-07-06 16:37:57 +0200 |
|---|---|---|
| committer | pem@mysql.com <> | 2005-07-06 16:37:57 +0200 |
| commit | 18d6dd56ef5ee37dd2f22411926a099f26fd87e4 (patch) | |
| tree | 215290f94361d6faa25eb8b539440f80c7b922c2 /mysql-test/t/sp.test | |
| parent | e28797220fabf4519f3d5a63e00acd4f9f6763be (diff) | |
| download | mariadb-git-18d6dd56ef5ee37dd2f22411926a099f26fd87e4.tar.gz | |
Fixed BUG#7088: Stored procedures: labels won't work if character set is utf8.
We used 'IDENT' for labels as a temporary fix for the parser conflicts
introduced if the proper rule 'ident' was used. Now a specially tailored
'label_ident' rule is used for labels instead.
Diffstat (limited to 'mysql-test/t/sp.test')
| -rw-r--r-- | mysql-test/t/sp.test | 33 |
1 files changed, 32 insertions, 1 deletions
diff --git a/mysql-test/t/sp.test b/mysql-test/t/sp.test index 7455bc139dc..da9f6be9aed 100644 --- a/mysql-test/t/sp.test +++ b/mysql-test/t/sp.test @@ -3800,6 +3800,38 @@ drop procedure bug11529| # +# BUG#6063: Stored procedure labels are subject to restrictions (partial) +# BUG#7088: Stored procedures: labels won't work if character set is utf8 +# +--disable_warnings +drop procedure if exists bug6063| +drop procedure if exists bug7088_1| +drop procedure if exists bug7088_2| +--enable_warnings + +create procedure bug6063() + l�bel: begin end| +call bug6063()| +# QQ Known bug: this will not show the label correctly. +show create procedure bug6063| + +set character set utf8| +create procedure bug7088_1() + label1: begin end label1| +create procedure bug7088_2() + läbel1: begin end| +call bug7088_1()| +call bug7088_2()| +set character set default| +show create procedure bug7088_1| +show create procedure bug7088_2| + +drop procedure bug6063| +drop procedure bug7088_1| +drop procedure bug7088_2| + + +# # BUG#NNNN: New bug synopsis # #--disable_warnings @@ -3812,4 +3844,3 @@ drop procedure bug11529| # practical, or create table t3, t4 etc temporarily (and drop them). delimiter ;| drop table t1,t2; - |