diff options
| author | unknown <sanja@askmonty.org> | 2011-05-11 14:09:48 +0300 |
|---|---|---|
| committer | unknown <sanja@askmonty.org> | 2011-05-11 14:09:48 +0300 |
| commit | c94de8f0959c647becc3261e4f7a2a6d57d2a97b (patch) | |
| tree | 22d6d45d1f035091b578b5f74d64828f584d83de /mysql-test/r/create.result | |
| parent | 62da6c1675fd9970dcd68069dd9403b68441cf00 (diff) | |
| download | mariadb-git-c94de8f0959c647becc3261e4f7a2a6d57d2a97b.tar.gz | |
Bugfix: New table creation/renaming block added if old encoded table present.
mysql-test/r/create.result:
test of renaming
mysql-test/r/upgrade.result:
Now such behaviour prohibited to avoid problems.
mysql-test/t/create.test:
test of renaming
mysql-test/t/upgrade.test:
Now such behaviour prohibited to avoid problems.
sql/mysql_priv.h:
Function to test table name presence added.
sql/sql_rename.cc:
Rename fixed.
sql/sql_table.cc:
Function to test table name presence added.
Create fixed.
Diffstat (limited to 'mysql-test/r/create.result')
| -rw-r--r-- | mysql-test/r/create.result | 19 |
1 files changed, 19 insertions, 0 deletions
diff --git a/mysql-test/r/create.result b/mysql-test/r/create.result index e871d9526ca..720e7c1d24e 100644 --- a/mysql-test/r/create.result +++ b/mysql-test/r/create.result @@ -1890,5 +1890,24 @@ create table t3 (a int) row_format=page; drop table t1,t2,t3; # -- End of Bug#45829 +# new table creation/renaming blocked if old encoded table present +create table `t-1` (a int) engine=myisam; +insert into `t-1` values (1); +show tables; +Tables_in_test +t-1 +flush tables; +convert table files in mysql 5.0 file name encoding +show tables; +Tables_in_test +#mysql50#t-1 +create table `t-1` (a int); +ERROR 42S01: Table '#mysql50#t-1' already exists +create table t1 (a int); +alter table t1 rename `t-1`; +ERROR 42S01: Table '#mysql50#t-1' already exists +rename table t1 to `t-1`; +ERROR 42S01: Table '#mysql50#t-1' already exists +drop table `#mysql50#t-1`, t1; End of 5.1 tests |