diff options
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/r/keywords.result | 16 | ||||
| -rw-r--r-- | mysql-test/t/keywords.test | 24 |
2 files changed, 40 insertions, 0 deletions
diff --git a/mysql-test/r/keywords.result b/mysql-test/r/keywords.result index 88a0ab8abd5..597983dab7e 100644 --- a/mysql-test/r/keywords.result +++ b/mysql-test/r/keywords.result @@ -16,3 +16,19 @@ select events.binlog from events; binlog 1 drop table events; +create procedure p1() +begin +declare n int default 2; +authors: while n > 0 do +set n = n -1; +end while authors; +end| +create procedure p2() +begin +declare n int default 2; +contributors: while n > 0 do +set n = n -1; +end while contributors; +end| +drop procedure p1; +drop procedure p2; diff --git a/mysql-test/t/keywords.test b/mysql-test/t/keywords.test index de0159a950e..1af4a1354be 100644 --- a/mysql-test/t/keywords.test +++ b/mysql-test/t/keywords.test @@ -19,3 +19,27 @@ select events.binlog from events; drop table events; # End of 4.1 tests + +# +# Bug#19939 "AUTHORS is not a keyword" +# +delimiter |; +create procedure p1() +begin + declare n int default 2; + authors: while n > 0 do + set n = n -1; + end while authors; +end| +create procedure p2() +begin + declare n int default 2; + contributors: while n > 0 do + set n = n -1; + end while contributors; +end| +delimiter ;| +drop procedure p1; +drop procedure p2; + +# End of 5.1 tests |