diff options
| author | unknown <knielsen@knielsen-hq.org> | 2009-11-13 22:26:08 +0100 |
|---|---|---|
| committer | unknown <knielsen@knielsen-hq.org> | 2009-11-13 22:26:08 +0100 |
| commit | 898f6f48b79d1f2c334fb559225b2b0fade5ea93 (patch) | |
| tree | 84df8eecd942b650f172cbd67050ee8984c0d52b /mysql-test/t/innodb-index.test | |
| parent | 275c0a7f96502b33f763fb9388dcc1c289e4792b (diff) | |
| parent | 2bde0c5e6d31583e5197e3b513f572a693161f62 (diff) | |
| download | mariadb-git-898f6f48b79d1f2c334fb559225b2b0fade5ea93.tar.gz | |
Merge XtraDB 8 into MariaDB.
Diffstat (limited to 'mysql-test/t/innodb-index.test')
| -rw-r--r-- | mysql-test/t/innodb-index.test | 24 |
1 files changed, 24 insertions, 0 deletions
diff --git a/mysql-test/t/innodb-index.test b/mysql-test/t/innodb-index.test index dd2c7f3f3c3..63fc5d5c7ad 100644 --- a/mysql-test/t/innodb-index.test +++ b/mysql-test/t/innodb-index.test @@ -515,4 +515,28 @@ SHOW CREATE TABLE t2; DROP TABLE t2; DROP TABLE t1; + +connect (a,localhost,root,,); +connect (b,localhost,root,,); +connection a; +CREATE TABLE t1 (a INT, b CHAR(1)) ENGINE=InnoDB; +INSERT INTO t1 VALUES (3,'a'),(3,'b'),(1,'c'),(0,'d'),(1,'e'); +connection b; +BEGIN; +SELECT * FROM t1; +connection a; +CREATE INDEX t1a ON t1(a); +connection b; +SELECT * FROM t1; +--error ER_TABLE_DEF_CHANGED +SELECT * FROM t1 FORCE INDEX(t1a) ORDER BY a; +SELECT * FROM t1; +COMMIT; +SELECT * FROM t1 FORCE INDEX(t1a) ORDER BY a; +connection default; +disconnect a; +disconnect b; + +DROP TABLE t1; + SET GLOBAL innodb_file_format_check=@save_innodb_file_format_check; |