diff options
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; |