diff options
author | Marko Mäkelä <marko.makela@mariadb.com> | 2017-09-17 13:46:51 +0300 |
---|---|---|
committer | Marko Mäkelä <marko.makela@mariadb.com> | 2017-09-17 13:46:51 +0300 |
commit | d6baf3d364ede93d589015245727100430f1e888 (patch) | |
tree | 271b8c2b2f4b9206d6ff837b98014386ac0bc16e /mysql-test/suite/innodb/r/innodb-table-online.result | |
parent | d9277732d7dbe7e3793c70cdc769ade16168695d (diff) | |
download | mariadb-git-d6baf3d364ede93d589015245727100430f1e888.tar.gz |
MDEV-12634 after-merge test fix: Exercise row_merge_write(), row_merge_read()
MySQL 5.7 introduced some optimizations to avoid file I/O during
ALGORITHM=INPLACE operations. While both innodb-index-online and
innodb-table-online will exercise both the merge sort files and
the online log files in 10.1, in 10.2 they would only exercise the
online log files.
Modify one test case in innodb.innodb-table-online so that
skip_pk_sort will not hold. In this way, this test case will
write and read the merge sort files. The other instrumented tests
in innodb-index-online and innodb-table-online will only write
and read online_log files.
Diffstat (limited to 'mysql-test/suite/innodb/r/innodb-table-online.result')
-rw-r--r-- | mysql-test/suite/innodb/r/innodb-table-online.result | 28 |
1 files changed, 14 insertions, 14 deletions
diff --git a/mysql-test/suite/innodb/r/innodb-table-online.result b/mysql-test/suite/innodb/r/innodb-table-online.result index 49f44c0f655..ec5199e4f52 100644 --- a/mysql-test/suite/innodb/r/innodb-table-online.result +++ b/mysql-test/suite/innodb/r/innodb-table-online.result @@ -321,7 +321,7 @@ ALTER TABLE t1 ADD PRIMARY KEY(c22f), CHANGE c2 c22f INT; ERROR 42000: Multiple primary key defined ALTER TABLE t1 DROP PRIMARY KEY, ADD PRIMARY KEY(c22f), CHANGE c2 c22f INT; ERROR 23000: Duplicate entry '5' for key 'PRIMARY' -ALTER TABLE t1 DROP PRIMARY KEY, ADD PRIMARY KEY(c1,c22f,c4(5)), +ALTER TABLE t1 DROP PRIMARY KEY, ADD PRIMARY KEY(c22f,c1,c4(5)), CHANGE c2 c22f INT, CHANGE c3 c3 CHAR(255) NULL, CHANGE c1 c1 INT AFTER c22f, ADD COLUMN c4 VARCHAR(6) DEFAULT 'Online', LOCK=NONE; # session default @@ -333,7 +333,7 @@ ddl_background_drop_indexes 0 ddl_background_drop_tables 0 ddl_online_create_index 1 ddl_pending_alter_table 1 -ddl_sort_file_alter_table 0 +ddl_sort_file_alter_table 2 ddl_log_file_alter_table 1 BEGIN; INSERT INTO t1 SELECT 320 + c1, c2, c3 FROM t1 WHERE c1 > 240; @@ -349,7 +349,7 @@ ddl_background_drop_indexes 0 ddl_background_drop_tables 0 ddl_online_create_index 1 ddl_pending_alter_table 1 -ddl_sort_file_alter_table 0 +ddl_sort_file_alter_table 2 ddl_log_file_alter_table 2 SET DEBUG_SYNC = 'now SIGNAL dml3_done'; # session con1 @@ -360,7 +360,7 @@ ddl_background_drop_indexes 0 ddl_background_drop_tables 0 ddl_online_create_index 0 ddl_pending_alter_table 0 -ddl_sort_file_alter_table 0 +ddl_sort_file_alter_table 2 ddl_log_file_alter_table 2 SELECT COUNT(c22f) FROM t1; COUNT(c22f) @@ -453,7 +453,7 @@ ddl_background_drop_indexes 0 ddl_background_drop_tables 0 ddl_online_create_index 0 ddl_pending_alter_table 0 -ddl_sort_file_alter_table 4 +ddl_sort_file_alter_table 6 ddl_log_file_alter_table 2 # session default connection default; @@ -464,15 +464,15 @@ ALTER TABLE t1 ROW_FORMAT=REDUNDANT; SELECT * FROM t1 LIMIT 10; c22f c1 c3 c4 5 1 1foo Online -6 2 2foofoo Online -7 3 3foofoofoo Online -8 4 4foofoofoofoo Online -9 5 5foofoofoofoofoo Online 5 6 6foofoofoofoofoofoo Online -6 7 7foofoofoofoofoofoofoo Online -7 8 8foofoofoofoofoofoofoofoo Online -8 9 9foofoofoofoofoofoofoofoofoo Online -9 10 10foofoofoofoofoofoofoofoofoofoo Online +5 11 11foofoofoofoofoofoofoofoofoofoofoo Online +5 16 16foofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoo Online +5 21 21foofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoo Online +5 26 26foofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoo Online +5 31 31foofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoo Online +5 36 36foofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoo Online +5 41 41foofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoo Online +5 46 46foofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoo Online # session con1 connection con1; ALTER TABLE t1 DISCARD TABLESPACE; @@ -487,7 +487,7 @@ t1 CREATE TABLE `t1` ( `c1` int(11) NOT NULL, `c3` char(255) NOT NULL, `c4` varchar(6) NOT NULL DEFAULT 'Online', - PRIMARY KEY (`c1`,`c22f`,`c4`(5)) + PRIMARY KEY (`c22f`,`c1`,`c4`(5)) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=REDUNDANT SET DEBUG_SYNC = 'RESET'; SET GLOBAL innodb_monitor_disable = module_ddl; |