diff options
| author | unknown <acurtis@xiphis.org> | 2005-05-31 18:06:54 +0100 |
|---|---|---|
| committer | unknown <acurtis@xiphis.org> | 2005-05-31 18:06:54 +0100 |
| commit | 2b548fe935b126fb4c0c9bfd109ed7dee778382b (patch) | |
| tree | d1f6b58a051a3caa9b5379f40287853935d3c658 /mysql-test | |
| parent | 25841aa9addc20fc28c0392d5447b984b2bc230b (diff) | |
| download | mariadb-git-2b548fe935b126fb4c0c9bfd109ed7dee778382b.tar.gz | |
Bug#10413 - Invalid column name is not rejected
Stop ignoring name parts and check for validity
mysql-test/r/create.result:
Test for bug#10413
mysql-test/t/create.test:
Test for bug#10413
sql/sql_yacc.yy:
Bug#10413
Stop ignoring parts of fully qualified names.
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/r/create.result | 9 | ||||
| -rw-r--r-- | mysql-test/t/create.test | 13 |
2 files changed, 22 insertions, 0 deletions
diff --git a/mysql-test/r/create.result b/mysql-test/r/create.result index 103bed598ef..cae5e24df18 100644 --- a/mysql-test/r/create.result +++ b/mysql-test/r/create.result @@ -563,3 +563,12 @@ select * from t2; b 1 drop table t1,t2; +create table t1(column.name int); +ERROR 42000: Incorrect table name 'column' +create table t1(test.column.name int); +ERROR 42000: Incorrect table name 'column' +create table t1(xyz.t1.name int); +ERROR 42000: Incorrect database name 'xyz' +create table t1(t1.name int); +create table t2(test.t2.name int); +drop table t1,t2; diff --git a/mysql-test/t/create.test b/mysql-test/t/create.test index ce85e530569..dca662a415e 100644 --- a/mysql-test/t/create.test +++ b/mysql-test/t/create.test @@ -460,3 +460,16 @@ insert into t2 values (); select * from t1; select * from t2; drop table t1,t2; + +# +# Bug#10413: Invalid column name is not rejected +# +--error 1103 +create table t1(column.name int); +--error 1103 +create table t1(test.column.name int); +--error 1102 +create table t1(xyz.t1.name int); +create table t1(t1.name int); +create table t2(test.t2.name int); +drop table t1,t2; |