summaryrefslogtreecommitdiff
path: root/mysql-test
diff options
context:
space:
mode:
authoracurtis@xiphis.org <>2005-05-31 19:21:08 +0100
committeracurtis@xiphis.org <>2005-05-31 19:21:08 +0100
commitfb10cfd08ddefb745db2d1ef3f0f262c94c4e9a3 (patch)
tree0d9527791e403f04ca0fc422ad2dfc5da8af7111 /mysql-test
parentcc0061a122336a74b439d14d1d3d1a4528af0f0b (diff)
parentc4f37eda6573e4c63d9d839b8a6c9396e729bb67 (diff)
downloadmariadb-git-fb10cfd08ddefb745db2d1ef3f0f262c94c4e9a3.tar.gz
Merge acurtis@bk-internal.mysql.com:/home/bk/mysql-4.1
into xiphis.org:/usr/home/antony/work2/p4-bug10413.2
Diffstat (limited to 'mysql-test')
-rw-r--r--mysql-test/r/create.result9
-rw-r--r--mysql-test/t/create.test13
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;