Merge bb-10.2-ext into 10.3

9 files changed, 509 insertions, 0 deletions

diff --git a/mysql-test/suite/innodb/r/innodb-autoinc.result b/mysql-test/suite/innodb/r/innodb-autoinc.result
index 1d61079dbd8..ee1adc07661 100644
--- a/mysql-test/suite/innodb/r/innodb-autoinc.result
+++ b/mysql-test/suite/innodb/r/innodb-autoinc.result
@@ -1363,3 +1363,9 @@ SELECT * FROM t1;
 c1
 1e19
 DROP TABLE t1;
+CREATE TABLE t1 (a DOUBLE PRIMARY KEY AUTO_INCREMENT) ENGINE=InnoDB;
+INSERT INTO t1 VALUES (-1);
+SELECT * FROM t1;
+a
+-1
+DROP TABLE t1;
diff --git a/mysql-test/suite/innodb/r/innodb-index-debug.result b/mysql-test/suite/innodb/r/innodb-index-debug.result
index beab075f3c8..1d0d5268fa9 100644
--- a/mysql-test/suite/innodb/r/innodb-index-debug.result
+++ b/mysql-test/suite/innodb/r/innodb-index-debug.result
@@ -112,6 +112,35 @@ t1	CREATE TABLE `t1` (
 ) ENGINE=InnoDB AUTO_INCREMENT=1023 DEFAULT CHARSET=latin1
 drop table t1;
 drop table t480;
+#
+# MDEV-12827 Assertion failure when reporting duplicate key error
+# in online table rebuild
+#
+CREATE TABLE t1 (j INT UNIQUE, i INT UNIQUE) ENGINE=InnoDB;
+connect  con1,localhost,root,,test;
+SET DEBUG_SYNC='row_log_table_apply1_before SIGNAL built WAIT_FOR log';
+ALTER TABLE t1 DROP j, FORCE;
+connection default;
+SET DEBUG_SYNC='now WAIT_FOR built';
+INSERT INTO t1 (i) VALUES (0),(0);
+ERROR 23000: Duplicate entry '0' for key 'i'
+SET DEBUG_SYNC='now SIGNAL log';
+connection con1;
+ERROR 23000: Duplicate entry '0' for key 'i'
+SET DEBUG_SYNC='row_log_table_apply1_before SIGNAL built2 WAIT_FOR log2';
+ALTER TABLE t1 DROP j, FORCE;
+connection default;
+SET DEBUG_SYNC='now WAIT_FOR built2';
+INSERT INTO t1 (i) VALUES (0),(1);
+UPDATE t1 SET i=0;
+ERROR 23000: Duplicate entry '0' for key 'i'
+SET DEBUG_SYNC='now SIGNAL log2';
+connection con1;
+ERROR 23000: Duplicate entry '0' for key 'i'
+disconnect con1;
+connection default;
+SET DEBUG_SYNC='RESET';
+DROP TABLE t1;
 SET DEBUG_SYNC='RESET';
 #
 #  BUG#21612714 ALTER TABLE SORTING SKIPPED WHEN CHANGE PK AND DROP
diff --git a/mysql-test/suite/innodb/r/innodb.result b/mysql-test/suite/innodb/r/innodb.result
index edac0d0ab69..f19929f8e17 100644
--- a/mysql-test/suite/innodb/r/innodb.result
+++ b/mysql-test/suite/innodb/r/innodb.result
@@ -3299,3 +3299,83 @@ show status like "handler_read_key";
 Variable_name	Value
 Handler_read_key	0
 drop table t1;
+CREATE TABLE t1 (c1 INT) ENGINE=InnoDB;
+CREATE TEMPORARY TABLE t2 (c1 INT) ENGINE=InnoDB;
+START TRANSACTION READ ONLY;
+INSERT INTO t2 VALUES(0);
+INSERT INTO t1 VALUES(0);
+ERROR 25006: Cannot execute statement in a READ ONLY transaction
+ROLLBACK;
+SELECT * FROM t1;
+c1
+SELECT * FROM t2;
+c1
+START TRANSACTION READ ONLY;
+INSERT INTO t1 VALUES(0);
+ERROR 25006: Cannot execute statement in a READ ONLY transaction
+INSERT INTO t2 VALUES(1);
+COMMIT;
+SET TRANSACTION READ ONLY;
+START TRANSACTION;
+INSERT INTO t2 VALUES(3);
+INSERT INTO t1 VALUES(0);
+ERROR 25006: Cannot execute statement in a READ ONLY transaction
+COMMIT;
+SELECT * FROM t1;
+c1
+SELECT * FROM t2;
+c1
+1
+3
+DROP TABLE t2;
+CREATE TEMPORARY TABLE t2 (
+c1 INT AUTO_INCREMENT PRIMARY KEY,
+c2 INT, INDEX idx(c2)) ENGINE=InnoDB;
+SHOW CREATE TABLE t2;
+Table	Create Table
+t2	CREATE TEMPORARY TABLE `t2` (
+  `c1` int(11) NOT NULL AUTO_INCREMENT,
+  `c2` int(11) DEFAULT NULL,
+  PRIMARY KEY (`c1`),
+  KEY `idx` (`c2`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1
+START TRANSACTION READ ONLY;
+INSERT INTO t2 VALUES(NULL,1),(NULL,2),(NULL,3);
+INSERT INTO t1 VALUES(0);
+ERROR 25006: Cannot execute statement in a READ ONLY transaction
+ROLLBACK;
+SELECT * FROM t1;
+c1
+SELECT * FROM t2;
+c1	c2
+START TRANSACTION READ ONLY;
+INSERT INTO t1 VALUES(0);
+ERROR 25006: Cannot execute statement in a READ ONLY transaction
+INSERT INTO t2 VALUES(NULL,1),(NULL,2),(NULL,3);
+COMMIT;
+SET TRANSACTION READ ONLY;
+START TRANSACTION;
+INSERT INTO t2 VALUES(NULL,1),(NULL,2),(NULL,3);
+INSERT INTO t1 VALUES(0);
+ERROR 25006: Cannot execute statement in a READ ONLY transaction
+COMMIT;
+SHOW CREATE TABLE t2;
+Table	Create Table
+t2	CREATE TEMPORARY TABLE `t2` (
+  `c1` int(11) NOT NULL AUTO_INCREMENT,
+  `c2` int(11) DEFAULT NULL,
+  PRIMARY KEY (`c1`),
+  KEY `idx` (`c2`)
+) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+SELECT * FROM t1;
+c1
+SELECT * FROM t2;
+c1	c2
+4	1
+7	1
+5	2
+8	2
+6	3
+9	3
+DROP TABLE t1;
+DROP TABLE t2;
diff --git a/mysql-test/suite/innodb/r/purge_secondary.result b/mysql-test/suite/innodb/r/purge_secondary.result
new file mode 100644
index 00000000000..2312434a2bd
--- /dev/null
+++ b/mysql-test/suite/innodb/r/purge_secondary.result
@@ -0,0 +1,148 @@
+SET @saved_frequency = @@GLOBAL.innodb_purge_rseg_truncate_frequency;
+SET GLOBAL innodb_purge_rseg_truncate_frequency = 1;
+CREATE TABLE t1 (
+a SERIAL, b CHAR(255) NOT NULL DEFAULT '', c BOOLEAN DEFAULT false,
+l LINESTRING NOT NULL DEFAULT ST_linefromtext('linestring(448 -689,
+  453 -684,451 -679,453 -677,458 -681,463 -681,468 -678,470 -676,470 -678,
+  468 -675,472 -675,472 -675,474 -674,479 -676,477 -675,473 -676,475 1324,
+  479 1319,484 1322,483 1323,486 1323,491 1328,492 1325,496 1325,498 1325,
+  501 1330,498 1331,500 1331,504 1330,508 1329,512 1332,513 1337,518 1339,
+  518 1339,513 1344,513 1344,512 1346,514 1351,515 1353,519 1358,518 1362,
+  522 1365,525 1360,526 1362,527 1362,528 1367,525 1371,528 1366,532 1369,
+  536 1374,539 1377,543 1379,539 1381,541 1382,543 1383,546 1388,549 1393,
+  554 1393,554 1395,554 1392,550 1394,550 1392,546 1394,549 1397,550 1393,
+  549 1394,554 1390,554 1391,549 1396,551 1396,547 1400,547 1402,551 1407,
+  554 1412,554 1415,558 1418,463 -681,465 -677,465 -675,470 -670,470 -665,
+  470 -660,470 -659,473 -656,476 -656,481 -655,482 -652,486 -654,486 -652,
+  486 -648,491 -646,490 -651,494 -646,493 -644,493 -644,490 -644,491 2356,
+  495 2359,495 2364,500 2359,503 5359,504 5364,509 5368,504 5367,499 5368,
+  498 5371,498 5369,500 5370,504 5370,508 5370,511 5370,507 5374,508 5378,
+  511 5382,507 5387,509 5389,512 5388,515 5393,520 5396,517 5397,517 5402,
+  515 5404,520 5402,521 5405,525 5405,526 5408,530 7408,535 7413,533 7415,
+  529 7412,532 7416,4532 7416,4534 7421,4533 7417,4536 7413,4536 7418,
+  4540 3418,4545 3418,4549 3415,4551 3419,4554 3421,4559 3423,4559 3426,
+  4557 3424,4561 3428,4558 3428,4563 3431,4565 3435,4569 3439,4569 3439,
+  4569 3444,4567 3444,4572 3446,4577 3447,4581 3444,4581 3448,4584 3448,
+  4579 3447,4580 3450,4583 3449,4583 3453,4587 3455,4588 3458,4593 3463,
+  4598 3465,4601 3468,4598 3464,4598 3460,4593 5460,4595 5461,4600 5464,
+  4600 5465,4601 5466,4606 5466,4608 5466,4605 5464,4608 5467,4607 5468,
+  4609 5465,4614 5461,4618 5463,4621 5467,4623 5470,4622 5470,4622 5470,
+  4625 6470,4627 6471,4627 6472,4627 6473,6627 6474,6625 6474,6628 6477,
+  6633 6481,6633 6480,6637 6475,7637 6479,7638 6482,7643 6487,7644 6492,
+  7647 6492,7648 6495,7646 6498,7650 6499,7646 6494,7644 6499,7644 6497,
+  7644 6499,7647 6502,7649 6504,7650 6501,7647 6503,7649 6504,7650 6508,
+  7651 6503,7652 6508,7655 6508,7650 6511,7655 6515,7658 6513,7663 6513,
+  7665 6514,7669 6512,7667 6510,7664 6510,472 -675,477 -670,479 -666,
+  482 -663,484 -668,484 -666,485 -664,481 -664,479 -659,482 -659,484 -658,
+  483 -659,488 2341,493 2339,489 2338,491 2342,491 2346,494 2346,490 2348,
+  493 2348,498 2349,498 2350,499 2349,502 2350,503 2348,506 2348,506 2348,
+  507 2353,507 2355,504 2359,504 2364,504 2361,499 2365,502 2360,502 2358,
+  503 2357,504 2353,504 2357,500 2356,497 2355,498 2355,500 2359,502 2361,
+  505 2364,508 2364,506 2368,506 2370,504 2373,499 2373,496 2372,493 2377,
+  497 2380,495 2383,496 7383,493 7386,497 7391,494 7387,495 7389,498 7392,
+  498 7392,495 7395,493 7398,498 7401,498 7403,503 7400,498 8400,501 8401,
+  503 8401,503 8401,501 10401,496 10396,491 10401,492 10399,493 10403,
+  496 10403,491 10403,493 10407,489 10410,493 10407,489 10403,498 7403,
+  497 7399,496 7403,500 7405,500 7407,503 7411,508 7415,511 7415,511 7420,
+  515 7420,520 7423,523 7423,520 7427,523 7427,523 7427,522 7432,525 4432,
+  527 4434,530 4437,534 4441,529 4446,529 4441,534 4436,537 4436,535 4437,
+  532 4437,534 4432,535 4429,538 4430,542 4427,542 4431,538 4431,541 4431,
+  541 4433,543 4433,545 4432,549 4428,552 4426,556 4427,557 4423,560 4427,
+  561 4428,558 4430,559 4434,559 4432,561 4434,561 4437,563 4435,559 4430,
+  561 4435,4561 4437,4566 4441,4568 4446,4568 4450,4569 4455,4565 4458,
+  4561 4463,4561 9463,4564 9463,4565 9461,9565 9463,9560 9467,9560 9466,
+  9555 9469,9555 9471,9559 9469,9557 9473,9553 9478,9555 9480,9557 9481,
+  9557 9481,9557 9483,9562 9487,9558 9487,9558 9490,9561 9493,9562 9493,
+  9557 9493,9560 9496,9555 9501,9553 9503,9553 9506,9557 9510,9558 9511,
+  9561 9514,9563 9512,9568 9514,9567 9514,9567 13514,9570 13517,9566 13521,
+  9571 13521,9571 13526,9573 13521,9571 13521,9576 10521,9580 10526,9582 10525,
+  9584 10528,9584 10531,9584 10533,9589 10533,9588 10537,9588 10541,9589 10542,
+  9593 10544,9595 10540,9597 10541,9600 10545,9601 15545,9603 15549,9605 15553,
+  9601 15558,9601 15553,9605 15551,9605 15550,9605 15554,9607 15556,9605 15556,
+  9604 15561,9607 15559,9603 15559,9603 15562,9604 15563,9608 15566,9612 15570,
+  9617 15565,9622 15568,9627 15566,9628 15564,9629 15564,9633 15569,9636 15569,
+  9634 15571,9634 15572,9636 15574,9634 15570,9629 15570,9631 15567,9629 15570,
+  9626 15574,9626 15575,498 7401,502 7401,506 7397,506 7395,502 7398,497 7401,
+  502 7402,505 7397,508 7400,504 7404,3504 7409,3505 7405,3508 7410,3511 7413,
+  3511 7416,3511 7419,3511 7419,3513 7421,3517 7424,3519 7426,3520 11426,
+  3523 11421,3527 11418,3530 11415,3530 11416,3533 11418,7533 11415,7531 11415,
+  7531 11417,7536 11420,7541 11424,7543 11425,7543 11427,7543 11429,7540 11429,
+  7542 11425,7541 11420,7542 11421,7542 11422,7540 11424,7540 11423,7543 11422,
+  7546 11426,7550 11431,7553 11436,7555 16436,7553 16438,7558 16438,7559 16438,
+  7560 16439,7565 16437,7560 16435,7563 16435,7566 16440,7566 16444,7564 16447,
+  7559 16443,7561 16443,7566 16448,7570 16451,7574 16456,7578 16459,
+  12578 16459,12578 20459,12577 20456,12581 20454,12585 20456,12585 20456,
+  12585 20456,12583 20456,12579 20459,12580 20461,12580 20462,12580 20460,
+  12585 20465,12586 20467,12590 20470,12590 20470,12589 20471,12584 20471,
+  12589 20471,9589 20472,9594 20472,9595 20472,9596 20477,9598 20482,
+  9603 20480,9608 20484,9613 20484,9610 20486,9608 20488,9608 20489,9610 20489,
+  9614 20486,9619 20481,9620 20481,9618 21481,9621 21483,9626 21483,9628 21485,
+  9623 21487,9622 21490,9626 21493,9621 21495,9626 21498,9622 21499,9624 21504,
+  9625 21499,9629 21501,9633 21498,9637 21495,9639 21498,9644 21501,9557 9481,
+  9560 9485,9561 9490,9563 9488,9560 9486,9558 9488,9561 9492,9563 9495,
+  9567 9492,9567 9488,9564 9490,9559 9495,9559 9498,9557 9502,9562 9506,
+  9564 9509,9569 9512,9569 9516,9569 9518,9569 9515,9571 9513,9571 9512,
+  9573 9513,9578 9516,9581 9516,9585 11516,9585 11521,9590 10521,9586 10524,
+  9589 10529,9589 10527,9589 10527,9594 10532,9594 10534,9598 10536,9598 10540,
+  9600 10542,9604 10538,9607 10538,9609 10543,9613 10538,9613 10533,9613 10537,
+  9610 10537,9614 10542,9609 10542,9610 10543,9610 10548,9611 10553,9616 7553,
+  9620 7553,9621 7557,9618 7559,9618 7554,9622 7557,9622 7561,9622 7556,
+  9622 7560,9619 7560,9620 7565,9622 7563,9627 7566,9630 7570,9630 7571,
+  9632 7573,9637 7576,9639 7578,9640 7576,9640 7579,9640 7575,9642 7570,
+  9646 7570,9651 7574,9653 7577,9652 7572,9653 7576,9653 7576,9651 7581,
+  9656 7585,9660 7586,9659 7591,9657 7594,9661 7598,9664 7602,9668 12602,
+  9673 12604,9676 12606,9679 12602,9682 12605,9677 12610,9674 12606,9674 12601,
+  9674 12603,9672 9603,9668 9605,9671 9606,9668 9611,9668 9606,9671 9611,
+  9675 9615,9677 9620,9678 9622,9679 9624,9684 9626,9685 9627,9685 9622,
+  9685 9626,9689 9628,9694 9633,9699 9637,9699 9637,9704 9636,9708 9637,
+  9709 9638,9707 9639,9705 9642,9707 9647,9710 9649,9711 9653,9716 9649,
+  9716 9648,9720 9650,9721 9648,9723 9648,9726 4648,12726 4653,12731 4655,
+  12734 4660,12730 4661,12733 4664,12733 4665,12735 4670,12737 4674,12741 4674,
+  12738 4675,12740 4675,12737 4675,12742 4678,12743 4681,12746 4677)'),
+INDEX(b,c), SPATIAL INDEX(l)
+) ENGINE=InnoDB ROW_FORMAT=REDUNDANT;
+INSERT INTO t1 () VALUES (),(),(),(),(),(),(),(),(),(),(),(),(),(),(),(),();
+SELECT LENGTH(l) FROM t1;
+LENGTH(l)
+11197
+11197
+11197
+11197
+11197
+11197
+11197
+11197
+11197
+11197
+11197
+11197
+11197
+11197
+11197
+11197
+11197
+INSERT INTO t1 (a) SELECT NULL FROM t1;
+INSERT INTO t1 (a) SELECT NULL FROM t1;
+CHECK TABLE t1;
+Table	Op	Msg_type	Msg_text
+test.t1	check	status	OK
+UPDATE t1 SET c=true, l=ST_linefromtext('linestring(0 0,1 1,2 2)');
+DELETE FROM t1;
+CHECK TABLE t1;
+Table	Op	Msg_type	Msg_text
+test.t1	check	status	OK
+InnoDB		0 transactions not purged
+ANALYZE TABLE t1;
+Table	Op	Msg_type	Msg_text
+test.t1	analyze	status	OK
+SELECT OTHER_INDEX_SIZE FROM INFORMATION_SCHEMA.INNODB_SYS_TABLESTATS
+WHERE NAME='test/t1';
+OTHER_INDEX_SIZE
+1
+# Note: The OTHER_INDEX_SIZE does not cover any SPATIAL INDEX.
+# To test that all indexes were emptied, replace DROP TABLE
+# with the following, and examine the root pages in t1.ibd:
+# FLUSH TABLES t1 FOR EXPORT;
+# UNLOCK TABLES;
+DROP TABLE t1;
+SET GLOBAL innodb_purge_rseg_truncate_frequency = @saved_frequency;
diff --git a/mysql-test/suite/innodb/t/innodb-autoinc.test b/mysql-test/suite/innodb/t/innodb-autoinc.test
index fe7ac2c9657..db265ff8f67 100644
--- a/mysql-test/suite/innodb/t/innodb-autoinc.test
+++ b/mysql-test/suite/innodb/t/innodb-autoinc.test
@@ -695,3 +695,8 @@ CREATE TABLE t1 (
 INSERT INTO t1 VALUES ();
 SELECT * FROM t1;
 DROP TABLE t1;
+
+CREATE TABLE t1 (a DOUBLE PRIMARY KEY AUTO_INCREMENT) ENGINE=InnoDB;
+INSERT INTO t1 VALUES (-1);
+SELECT * FROM t1;
+DROP TABLE t1;
diff --git a/mysql-test/suite/innodb/t/innodb-index-debug.test b/mysql-test/suite/innodb/t/innodb-index-debug.test
index de598740e6a..e680fb719cc 100644
--- a/mysql-test/suite/innodb/t/innodb-index-debug.test
+++ b/mysql-test/suite/innodb/t/innodb-index-debug.test
@@ -114,6 +114,45 @@ connection default;
 show create table t1;
 drop table t1;
 drop table t480;
+--echo #
+--echo # MDEV-12827 Assertion failure when reporting duplicate key error
+--echo # in online table rebuild
+--echo #
+
+CREATE TABLE t1 (j INT UNIQUE, i INT UNIQUE) ENGINE=InnoDB;
+--connect (con1,localhost,root,,test)
+SET DEBUG_SYNC='row_log_table_apply1_before SIGNAL built WAIT_FOR log';
+--send
+ALTER TABLE t1 DROP j, FORCE;
+
+--connection default
+SET DEBUG_SYNC='now WAIT_FOR built';
+--error ER_DUP_ENTRY
+INSERT INTO t1 (i) VALUES (0),(0);
+SET DEBUG_SYNC='now SIGNAL log';
+
+--connection con1
+--error ER_DUP_ENTRY
+reap;
+SET DEBUG_SYNC='row_log_table_apply1_before SIGNAL built2 WAIT_FOR log2';
+--send
+ALTER TABLE t1 DROP j, FORCE;
+
+--connection default
+SET DEBUG_SYNC='now WAIT_FOR built2';
+INSERT INTO t1 (i) VALUES (0),(1);
+--error ER_DUP_ENTRY
+UPDATE t1 SET i=0;
+SET DEBUG_SYNC='now SIGNAL log2';
+
+--connection con1
+--error ER_DUP_ENTRY
+reap;
+--disconnect con1
+--connection default
+SET DEBUG_SYNC='RESET';
+DROP TABLE t1;
+
 SET DEBUG_SYNC='RESET';
 --source include/wait_until_count_sessions.inc
 
diff --git a/mysql-test/suite/innodb/t/innodb.test b/mysql-test/suite/innodb/t/innodb.test
index a4ba60ec94c..9781d284636 100644
--- a/mysql-test/suite/innodb/t/innodb.test
+++ b/mysql-test/suite/innodb/t/innodb.test
@@ -2583,6 +2583,76 @@ select f1 from t1;
 show status like "handler_read_key";
 drop table t1;
 
+#
+# Test handling of writes to TEMPORARY tables for read-only transactions
+#
+CREATE TABLE t1 (c1 INT) ENGINE=InnoDB;
+CREATE TEMPORARY TABLE t2 (c1 INT) ENGINE=InnoDB;
+
+# Check that the rollback works
+START TRANSACTION READ ONLY;
+INSERT INTO t2 VALUES(0);
+--error ER_CANT_EXECUTE_IN_READ_ONLY_TRANSACTION
+INSERT INTO t1 VALUES(0);
+ROLLBACK;
+
+SELECT * FROM t1;
+SELECT * FROM t2;
+
+START TRANSACTION READ ONLY;
+--error ER_CANT_EXECUTE_IN_READ_ONLY_TRANSACTION
+INSERT INTO t1 VALUES(0);
+INSERT INTO t2 VALUES(1);
+COMMIT;
+
+SET TRANSACTION READ ONLY;
+START TRANSACTION;
+INSERT INTO t2 VALUES(3);
+--error ER_CANT_EXECUTE_IN_READ_ONLY_TRANSACTION
+INSERT INTO t1 VALUES(0);
+COMMIT;
+
+SELECT * FROM t1;
+SELECT * FROM t2;
+
+DROP TABLE t2;
+
+# This time with some indexes
+CREATE TEMPORARY TABLE t2 (
+	c1 INT AUTO_INCREMENT PRIMARY KEY,
+	c2 INT, INDEX idx(c2)) ENGINE=InnoDB;
+
+SHOW CREATE TABLE t2;
+
+# Check that the rollback works
+START TRANSACTION READ ONLY;
+INSERT INTO t2 VALUES(NULL,1),(NULL,2),(NULL,3);
+--error ER_CANT_EXECUTE_IN_READ_ONLY_TRANSACTION
+INSERT INTO t1 VALUES(0);
+ROLLBACK;
+
+SELECT * FROM t1;
+SELECT * FROM t2;
+
+START TRANSACTION READ ONLY;
+--error ER_CANT_EXECUTE_IN_READ_ONLY_TRANSACTION
+INSERT INTO t1 VALUES(0);
+INSERT INTO t2 VALUES(NULL,1),(NULL,2),(NULL,3);
+COMMIT;
+
+SET TRANSACTION READ ONLY;
+START TRANSACTION;
+INSERT INTO t2 VALUES(NULL,1),(NULL,2),(NULL,3);
+--error ER_CANT_EXECUTE_IN_READ_ONLY_TRANSACTION
+INSERT INTO t1 VALUES(0);
+COMMIT;
+
+SHOW CREATE TABLE t2;
+SELECT * FROM t1;
+SELECT * FROM t2;
+
+DROP TABLE t1;
+DROP TABLE t2;
 #######################################################################
 #                                                                     #
 # Please, DO NOT TOUCH this file as well as the innodb.result file.   #
diff --git a/mysql-test/suite/innodb/t/purge_secondary.opt b/mysql-test/suite/innodb/t/purge_secondary.opt
new file mode 100644
index 00000000000..99bf0e5a28b
--- /dev/null
+++ b/mysql-test/suite/innodb/t/purge_secondary.opt
@@ -0,0 +1 @@
+--innodb-sys-tablestats
diff --git a/mysql-test/suite/innodb/t/purge_secondary.test b/mysql-test/suite/innodb/t/purge_secondary.test
new file mode 100644
index 00000000000..47cfaec41ca
--- /dev/null
+++ b/mysql-test/suite/innodb/t/purge_secondary.test
@@ -0,0 +1,131 @@
+--source include/have_innodb.inc
+
+# Ensure that the history list length will actually be decremented by purge.
+SET @saved_frequency = @@GLOBAL.innodb_purge_rseg_truncate_frequency;
+SET GLOBAL innodb_purge_rseg_truncate_frequency = 1;
+
+CREATE TABLE t1 (
+  a SERIAL, b CHAR(255) NOT NULL DEFAULT '', c BOOLEAN DEFAULT false,
+  l LINESTRING NOT NULL DEFAULT ST_linefromtext('linestring(448 -689,
+  453 -684,451 -679,453 -677,458 -681,463 -681,468 -678,470 -676,470 -678,
+  468 -675,472 -675,472 -675,474 -674,479 -676,477 -675,473 -676,475 1324,
+  479 1319,484 1322,483 1323,486 1323,491 1328,492 1325,496 1325,498 1325,
+  501 1330,498 1331,500 1331,504 1330,508 1329,512 1332,513 1337,518 1339,
+  518 1339,513 1344,513 1344,512 1346,514 1351,515 1353,519 1358,518 1362,
+  522 1365,525 1360,526 1362,527 1362,528 1367,525 1371,528 1366,532 1369,
+  536 1374,539 1377,543 1379,539 1381,541 1382,543 1383,546 1388,549 1393,
+  554 1393,554 1395,554 1392,550 1394,550 1392,546 1394,549 1397,550 1393,
+  549 1394,554 1390,554 1391,549 1396,551 1396,547 1400,547 1402,551 1407,
+  554 1412,554 1415,558 1418,463 -681,465 -677,465 -675,470 -670,470 -665,
+  470 -660,470 -659,473 -656,476 -656,481 -655,482 -652,486 -654,486 -652,
+  486 -648,491 -646,490 -651,494 -646,493 -644,493 -644,490 -644,491 2356,
+  495 2359,495 2364,500 2359,503 5359,504 5364,509 5368,504 5367,499 5368,
+  498 5371,498 5369,500 5370,504 5370,508 5370,511 5370,507 5374,508 5378,
+  511 5382,507 5387,509 5389,512 5388,515 5393,520 5396,517 5397,517 5402,
+  515 5404,520 5402,521 5405,525 5405,526 5408,530 7408,535 7413,533 7415,
+  529 7412,532 7416,4532 7416,4534 7421,4533 7417,4536 7413,4536 7418,
+  4540 3418,4545 3418,4549 3415,4551 3419,4554 3421,4559 3423,4559 3426,
+  4557 3424,4561 3428,4558 3428,4563 3431,4565 3435,4569 3439,4569 3439,
+  4569 3444,4567 3444,4572 3446,4577 3447,4581 3444,4581 3448,4584 3448,
+  4579 3447,4580 3450,4583 3449,4583 3453,4587 3455,4588 3458,4593 3463,
+  4598 3465,4601 3468,4598 3464,4598 3460,4593 5460,4595 5461,4600 5464,
+  4600 5465,4601 5466,4606 5466,4608 5466,4605 5464,4608 5467,4607 5468,
+  4609 5465,4614 5461,4618 5463,4621 5467,4623 5470,4622 5470,4622 5470,
+  4625 6470,4627 6471,4627 6472,4627 6473,6627 6474,6625 6474,6628 6477,
+  6633 6481,6633 6480,6637 6475,7637 6479,7638 6482,7643 6487,7644 6492,
+  7647 6492,7648 6495,7646 6498,7650 6499,7646 6494,7644 6499,7644 6497,
+  7644 6499,7647 6502,7649 6504,7650 6501,7647 6503,7649 6504,7650 6508,
+  7651 6503,7652 6508,7655 6508,7650 6511,7655 6515,7658 6513,7663 6513,
+  7665 6514,7669 6512,7667 6510,7664 6510,472 -675,477 -670,479 -666,
+  482 -663,484 -668,484 -666,485 -664,481 -664,479 -659,482 -659,484 -658,
+  483 -659,488 2341,493 2339,489 2338,491 2342,491 2346,494 2346,490 2348,
+  493 2348,498 2349,498 2350,499 2349,502 2350,503 2348,506 2348,506 2348,
+  507 2353,507 2355,504 2359,504 2364,504 2361,499 2365,502 2360,502 2358,
+  503 2357,504 2353,504 2357,500 2356,497 2355,498 2355,500 2359,502 2361,
+  505 2364,508 2364,506 2368,506 2370,504 2373,499 2373,496 2372,493 2377,
+  497 2380,495 2383,496 7383,493 7386,497 7391,494 7387,495 7389,498 7392,
+  498 7392,495 7395,493 7398,498 7401,498 7403,503 7400,498 8400,501 8401,
+  503 8401,503 8401,501 10401,496 10396,491 10401,492 10399,493 10403,
+  496 10403,491 10403,493 10407,489 10410,493 10407,489 10403,498 7403,
+  497 7399,496 7403,500 7405,500 7407,503 7411,508 7415,511 7415,511 7420,
+  515 7420,520 7423,523 7423,520 7427,523 7427,523 7427,522 7432,525 4432,
+  527 4434,530 4437,534 4441,529 4446,529 4441,534 4436,537 4436,535 4437,
+  532 4437,534 4432,535 4429,538 4430,542 4427,542 4431,538 4431,541 4431,
+  541 4433,543 4433,545 4432,549 4428,552 4426,556 4427,557 4423,560 4427,
+  561 4428,558 4430,559 4434,559 4432,561 4434,561 4437,563 4435,559 4430,
+  561 4435,4561 4437,4566 4441,4568 4446,4568 4450,4569 4455,4565 4458,
+  4561 4463,4561 9463,4564 9463,4565 9461,9565 9463,9560 9467,9560 9466,
+  9555 9469,9555 9471,9559 9469,9557 9473,9553 9478,9555 9480,9557 9481,
+  9557 9481,9557 9483,9562 9487,9558 9487,9558 9490,9561 9493,9562 9493,
+  9557 9493,9560 9496,9555 9501,9553 9503,9553 9506,9557 9510,9558 9511,
+  9561 9514,9563 9512,9568 9514,9567 9514,9567 13514,9570 13517,9566 13521,
+  9571 13521,9571 13526,9573 13521,9571 13521,9576 10521,9580 10526,9582 10525,
+  9584 10528,9584 10531,9584 10533,9589 10533,9588 10537,9588 10541,9589 10542,
+  9593 10544,9595 10540,9597 10541,9600 10545,9601 15545,9603 15549,9605 15553,
+  9601 15558,9601 15553,9605 15551,9605 15550,9605 15554,9607 15556,9605 15556,
+  9604 15561,9607 15559,9603 15559,9603 15562,9604 15563,9608 15566,9612 15570,
+  9617 15565,9622 15568,9627 15566,9628 15564,9629 15564,9633 15569,9636 15569,
+  9634 15571,9634 15572,9636 15574,9634 15570,9629 15570,9631 15567,9629 15570,
+  9626 15574,9626 15575,498 7401,502 7401,506 7397,506 7395,502 7398,497 7401,
+  502 7402,505 7397,508 7400,504 7404,3504 7409,3505 7405,3508 7410,3511 7413,
+  3511 7416,3511 7419,3511 7419,3513 7421,3517 7424,3519 7426,3520 11426,
+  3523 11421,3527 11418,3530 11415,3530 11416,3533 11418,7533 11415,7531 11415,
+  7531 11417,7536 11420,7541 11424,7543 11425,7543 11427,7543 11429,7540 11429,
+  7542 11425,7541 11420,7542 11421,7542 11422,7540 11424,7540 11423,7543 11422,
+  7546 11426,7550 11431,7553 11436,7555 16436,7553 16438,7558 16438,7559 16438,
+  7560 16439,7565 16437,7560 16435,7563 16435,7566 16440,7566 16444,7564 16447,
+  7559 16443,7561 16443,7566 16448,7570 16451,7574 16456,7578 16459,
+  12578 16459,12578 20459,12577 20456,12581 20454,12585 20456,12585 20456,
+  12585 20456,12583 20456,12579 20459,12580 20461,12580 20462,12580 20460,
+  12585 20465,12586 20467,12590 20470,12590 20470,12589 20471,12584 20471,
+  12589 20471,9589 20472,9594 20472,9595 20472,9596 20477,9598 20482,
+  9603 20480,9608 20484,9613 20484,9610 20486,9608 20488,9608 20489,9610 20489,
+  9614 20486,9619 20481,9620 20481,9618 21481,9621 21483,9626 21483,9628 21485,
+  9623 21487,9622 21490,9626 21493,9621 21495,9626 21498,9622 21499,9624 21504,
+  9625 21499,9629 21501,9633 21498,9637 21495,9639 21498,9644 21501,9557 9481,
+  9560 9485,9561 9490,9563 9488,9560 9486,9558 9488,9561 9492,9563 9495,
+  9567 9492,9567 9488,9564 9490,9559 9495,9559 9498,9557 9502,9562 9506,
+  9564 9509,9569 9512,9569 9516,9569 9518,9569 9515,9571 9513,9571 9512,
+  9573 9513,9578 9516,9581 9516,9585 11516,9585 11521,9590 10521,9586 10524,
+  9589 10529,9589 10527,9589 10527,9594 10532,9594 10534,9598 10536,9598 10540,
+  9600 10542,9604 10538,9607 10538,9609 10543,9613 10538,9613 10533,9613 10537,
+  9610 10537,9614 10542,9609 10542,9610 10543,9610 10548,9611 10553,9616 7553,
+  9620 7553,9621 7557,9618 7559,9618 7554,9622 7557,9622 7561,9622 7556,
+  9622 7560,9619 7560,9620 7565,9622 7563,9627 7566,9630 7570,9630 7571,
+  9632 7573,9637 7576,9639 7578,9640 7576,9640 7579,9640 7575,9642 7570,
+  9646 7570,9651 7574,9653 7577,9652 7572,9653 7576,9653 7576,9651 7581,
+  9656 7585,9660 7586,9659 7591,9657 7594,9661 7598,9664 7602,9668 12602,
+  9673 12604,9676 12606,9679 12602,9682 12605,9677 12610,9674 12606,9674 12601,
+  9674 12603,9672 9603,9668 9605,9671 9606,9668 9611,9668 9606,9671 9611,
+  9675 9615,9677 9620,9678 9622,9679 9624,9684 9626,9685 9627,9685 9622,
+  9685 9626,9689 9628,9694 9633,9699 9637,9699 9637,9704 9636,9708 9637,
+  9709 9638,9707 9639,9705 9642,9707 9647,9710 9649,9711 9653,9716 9649,
+  9716 9648,9720 9650,9721 9648,9723 9648,9726 4648,12726 4653,12731 4655,
+  12734 4660,12730 4661,12733 4664,12733 4665,12735 4670,12737 4674,12741 4674,
+  12738 4675,12740 4675,12737 4675,12742 4678,12743 4681,12746 4677)'),
+  INDEX(b,c), SPATIAL INDEX(l)
+) ENGINE=InnoDB ROW_FORMAT=REDUNDANT;
+INSERT INTO t1 () VALUES (),(),(),(),(),(),(),(),(),(),(),(),(),(),(),(),();
+SELECT LENGTH(l) FROM t1;
+INSERT INTO t1 (a) SELECT NULL FROM t1;
+INSERT INTO t1 (a) SELECT NULL FROM t1;
+CHECK TABLE t1;
+UPDATE t1 SET c=true, l=ST_linefromtext('linestring(0 0,1 1,2 2)');
+DELETE FROM t1;
+CHECK TABLE t1;
+
+source include/wait_all_purged.inc;
+
+ANALYZE TABLE t1;
+SELECT OTHER_INDEX_SIZE FROM INFORMATION_SCHEMA.INNODB_SYS_TABLESTATS
+WHERE NAME='test/t1';
+
+--echo # Note: The OTHER_INDEX_SIZE does not cover any SPATIAL INDEX.
+--echo # To test that all indexes were emptied, replace DROP TABLE
+--echo # with the following, and examine the root pages in t1.ibd:
+--echo # FLUSH TABLES t1 FOR EXPORT;
+--echo # UNLOCK TABLES;
+
+DROP TABLE t1;
+
+SET GLOBAL innodb_purge_rseg_truncate_frequency = @saved_frequency;