From ca78b386d6991efa3a5281d6b2b1fa692bf3a847 Mon Sep 17 00:00:00 2001
From: unknown <acurtis/antony@xiphis.org/ltantony.xiphis.org>
Date: Thu, 20 Jul 2006 12:54:01 -0700
Subject: Bug#19939   AUTHORS and CONTRIBUTORS are not reserved keywords.

mysql-test/r/keywords.result:
  Bug#19939
    Test for bug
mysql-test/t/keywords.test:
  Bug#19939
    Test for bug
---
 mysql-test/r/keywords.result | 16 ++++++++++++++++
 mysql-test/t/keywords.test   | 24 ++++++++++++++++++++++++
 2 files changed, 40 insertions(+)

(limited to 'mysql-test')

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
-- 
cgit v1.2.1