summaryrefslogtreecommitdiff
path: root/mysql-test/t/create.test
diff options
context:
space:
mode:
authorunknown <vva@eagle.mysql.r18.ru>2004-03-05 22:13:33 +0400
committerunknown <vva@eagle.mysql.r18.ru>2004-03-05 22:13:33 +0400
commit8550c7abebe81d102fb74bd82b1db2b098e22330 (patch)
treee3022f508e6b88ed24bf0ed9eb0eda2843a7a121 /mysql-test/t/create.test
parent15d8e9d06435f582125657f03e8ee294c04c0995 (diff)
downloadmariadb-git-8550c7abebe81d102fb74bd82b1db2b098e22330.tar.gz
fixed Bug #2985
"Table truncated when creating another table name with Spaces" added to check_db_name, check_table_name and check_column_name test for end space mysql-test/r/create.result: added test for Bug #2985 "Table truncated when creating another table name with Spaces" mysql-test/t/create.test: added test for Bug #2985 "Table truncated when creating another table name with Spaces" sql/sql_db.cc: cancel strip end spaces for database name sql/sql_parse.cc: cancel strip end spaces for database name sql/table.cc: added to check_db_name, check_table_name and check_column_name test for end space
Diffstat (limited to 'mysql-test/t/create.test')
-rw-r--r--mysql-test/t/create.test12
1 files changed, 12 insertions, 0 deletions
diff --git a/mysql-test/t/create.test b/mysql-test/t/create.test
index 8aee586268f..94c2f24dffc 100644
--- a/mysql-test/t/create.test
+++ b/mysql-test/t/create.test
@@ -179,3 +179,15 @@ create table if not exists t1 select 3 as 'a',4 as 'b';
create table if not exists t1 select 3 as 'a',3 as 'b';
select * from t1;
drop table t1;
+
+#
+# Test for Bug #2985
+# "Table truncated when creating another table name with Spaces"
+#
+
+--error 1103
+create table `t1 `(a int);
+--error 1102
+create database `db1 `;
+--error 1166;
+create table t1(`a ` int);