diff options
| author | Sergei Golubchik <sergii@pisem.net> | 2013-04-09 15:35:07 +0200 |
|---|---|---|
| committer | Sergei Golubchik <sergii@pisem.net> | 2013-04-09 15:35:07 +0200 |
| commit | 87a9d60ec625c8f1e8563de648105b36add9e940 (patch) | |
| tree | c652d83dd0ae47c0f2910183ff21508e9668e34a /mysql-test/t/upgrade.test | |
| parent | b9f42f4b7a08d4f6d46ecaba3595b38af0a6525d (diff) | |
| download | mariadb-git-87a9d60ec625c8f1e8563de648105b36add9e940.tar.gz | |
revert
"
revision-id: sanja@askmonty.org-20110511110948-4kdevwzomvk56y1w
committer: sanja@askmonty.org
branch nick: work-maria-5.1-CREATE-merge
timestamp: Wed 2011-05-11 14:09:48 +0300
Bugfix: New table creation/renaming block added if old encoded table present
"
the old behavior was less inconsistent than the new one.
In the new one the error message was sometimes different (under LOCK TABLES e.g.),
and there were race conditions (if this CREATE happened when a concurrent ALTER
has renamed the old table away but haven't put the new table in place)
The old one was like "(when using old table names) for DML #mysql50# prefix
is optional, for DDL it's required".
Diffstat (limited to 'mysql-test/t/upgrade.test')
| -rw-r--r-- | mysql-test/t/upgrade.test | 7 |
1 files changed, 2 insertions, 5 deletions
diff --git a/mysql-test/t/upgrade.test b/mysql-test/t/upgrade.test index a8c875ef764..c6d01a16f49 100644 --- a/mysql-test/t/upgrade.test +++ b/mysql-test/t/upgrade.test @@ -33,18 +33,15 @@ drop database `mysqltest-1`; # # Bug#17142: Crash if create with encoded name # ---disable_warnings -drop table if exists `txu@0023p@0023p1`; -drop table if exists `txu#p#p1`; ---enable_warnings create table `txu#p#p1` (s1 int); insert into `txu#p#p1` values (1); --error 1146 select * from `txu@0023p@0023p1`; ---error ER_TABLE_EXISTS_ERROR create table `txu@0023p@0023p1` (s1 int); +show tables; select * from `txu#p#p1`; drop table `txu#p#p1`; +drop table `txu@0023p@0023p1`; --echo # --echo # Bug#37631 Incorrect key file for table after upgrading from 5.0 to 5.1 |