diff options
| author | antony@ppcg5.local <> | 2007-02-07 14:22:19 -0800 |
|---|---|---|
| committer | antony@ppcg5.local <> | 2007-02-07 14:22:19 -0800 |
| commit | a3c3cda915e6a854728ba53354cde8614278ecc5 (patch) | |
| tree | 4f5de8bd64e14b001ea9fa5e51b872ee8433286b /mysql-test | |
| parent | 18ce758819212e1f835b2e4c8e0c74dc7b7e21ce (diff) | |
| download | mariadb-git-a3c3cda915e6a854728ba53354cde8614278ecc5.tar.gz | |
Bug#12204
"CONNECTION is a reserved keyword"
Allow connection to be used as an ordinary identifier
Tests included.
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/r/keywords.result | 13 | ||||
| -rw-r--r-- | mysql-test/t/keywords.test | 22 |
2 files changed, 35 insertions, 0 deletions
diff --git a/mysql-test/r/keywords.result b/mysql-test/r/keywords.result index 88a0ab8abd5..c14ae584c86 100644 --- a/mysql-test/r/keywords.result +++ b/mysql-test/r/keywords.result @@ -16,3 +16,16 @@ select events.binlog from events; binlog 1 drop table events; +create table t1 (connection int, b int); +create procedure p1() +begin +declare connection int; +select max(t1.connection) into connection from t1; +select concat("max=",connection) 'p1'; +end| +insert into t1 (connection) values (1); +call p1(); +p1 +max=1 +drop procedure p1; +drop table t1; diff --git a/mysql-test/t/keywords.test b/mysql-test/t/keywords.test index de0159a950e..46933a230ee 100644 --- a/mysql-test/t/keywords.test +++ b/mysql-test/t/keywords.test @@ -19,3 +19,25 @@ select events.binlog from events; drop table events; # End of 4.1 tests + + +# +# Bug#12204 - CONNECTION should not be a reserved word +# + +create table t1 (connection int, b int); +delimiter |; +create procedure p1() +begin + declare connection int; + select max(t1.connection) into connection from t1; + select concat("max=",connection) 'p1'; +end| +delimiter ;| +insert into t1 (connection) values (1); +call p1(); +drop procedure p1; +drop table t1; + + +# End of 5.0 tests |