diff options
| author | unknown <serg@serg.mylan> | 2004-07-26 10:52:40 +0200 |
|---|---|---|
| committer | unknown <serg@serg.mylan> | 2004-07-26 10:52:40 +0200 |
| commit | 65ba6aa2934e465fa31ed6185dcd22c714bc1403 (patch) | |
| tree | 11de9582d4e9e770a0d0623fc68537dabe094bb6 /mysql-test | |
| parent | 688089a213f93b5c4da19abacba401e5526887e7 (diff) | |
| download | mariadb-git-65ba6aa2934e465fa31ed6185dcd22c714bc1403.tar.gz | |
BUG#4717 - check for valid table names in ALTER TABLE ... RENAME
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/r/alter_table.result | 6 | ||||
| -rw-r--r-- | mysql-test/t/alter_table.test | 11 |
2 files changed, 17 insertions, 0 deletions
diff --git a/mysql-test/r/alter_table.result b/mysql-test/r/alter_table.result index c2fd5161353..e7a8d2c7cdf 100644 --- a/mysql-test/r/alter_table.result +++ b/mysql-test/r/alter_table.result @@ -380,3 +380,9 @@ t1 0 PRIMARY 1 Host A NULL NULL NULL BTREE t1 0 PRIMARY 2 User A 0 NULL NULL BTREE t1 1 Host 1 Host A NULL NULL NULL BTREE disabled DROP TABLE t1; +create table t1 (a int); +alter table t1 rename to `t1\\`; +Incorrect table name 't1\\' +rename table t1 to `t1\\`; +Incorrect table name 't1\\' +drop table t1; diff --git a/mysql-test/t/alter_table.test b/mysql-test/t/alter_table.test index 9a29ab3c2d7..11290134a71 100644 --- a/mysql-test/t/alter_table.test +++ b/mysql-test/t/alter_table.test @@ -243,3 +243,14 @@ LOCK TABLES t1 WRITE; ALTER TABLE t1 DISABLE KEYS; SHOW INDEX FROM t1; DROP TABLE t1; + +# +# BUG#4717 - check for valid table names +# +create table t1 (a int); +--error 1103 +alter table t1 rename to `t1\\`; +--error 1103 +rename table t1 to `t1\\`; +drop table t1; + |