mirror of
https://github.com/MariaDB/server.git
synced 2025-02-05 21:32:18 +01:00
d6baf3d364
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.
20 lines
774 B
Text
20 lines
774 B
Text
--- innodb-table-online.result
|
|
+++ innodb-table-online,crypt.reject
|
|
@@ -291,7 +291,7 @@
|
|
@merge_encrypt_1>@merge_encrypt_0, @merge_decrypt_1>@merge_decrypt_0,
|
|
@rowlog_encrypt_1>@rowlog_encrypt_0;
|
|
sort_balance @merge_encrypt_1>@merge_encrypt_0 @merge_decrypt_1>@merge_decrypt_0 @rowlog_encrypt_1>@rowlog_encrypt_0
|
|
-0 0 0 0
|
|
+0 0 0 1
|
|
SET DEBUG_SYNC = 'now SIGNAL dml2_done';
|
|
# session con1
|
|
connection con1;
|
|
@@ -393,7 +393,7 @@
|
|
@rowlog_encrypt_2-@rowlog_encrypt_1>0 as log_encrypted,
|
|
@rowlog_decrypt_2-@rowlog_decrypt_1>0 as log_decrypted;
|
|
sort_encrypted sort_decrypted log_encrypted log_decrypted
|
|
-0 0 0 0
|
|
+1 1 1 1
|
|
ALTER TABLE t1 DROP PRIMARY KEY, ADD PRIMARY KEY c3p5(c3(5));
|
|
ERROR 23000: Duplicate entry '' for key 'PRIMARY'
|
|
UPDATE t1 SET c3 = NULL WHERE c3 = '';
|