Details
-
Bug
-
Status: Closed (View Workflow)
-
Blocker
-
Resolution: Fixed
-
10.5, 10.6, 10.2(EOL), 10.3(EOL), 10.4(EOL), 10.7(EOL)
Description
MySQL 5.7.36 includes a bug fix with a test case:
Bug #33053297 VIRTUAL INDEX CORRUPTED DURING CASCADE UPDATE ON CHILD TABLE
The test case resembles MDEV-24041. A quick attempt to apply the patch (with some rewriting in row_ins_foreign_fill_virtual()) did not affect the outcome. There is a result difference:
@@ -918,7 +918,6 @@
|
1 NULL 2020-10-22 13:32:41 2020-
|
SELECT `date_sent` FROM `email_stats` WHERE `generated_sent_email` = '2020-';
|
date_sent
|
-2020-10-22 13:32:41
|
DROP TABLE `email_stats`;
|
DROP TABLE `emails`;
|
# test-case 4
|
@@ -956,7 +955,6 @@
|
1 NULL 2020-10-22 13:32:41 2020-
|
SELECT `date_sent` FROM `email_stats` WHERE `generated_sent_email` = '2020-';
|
date_sent
|
-2020-10-22 13:32:41
|
DROP TABLE `email_stats`;
|
DROP TABLE `emails`;
|
# End of 10.2 tests |
Curiously, if I add CHECK TABLE to the test, it will not report any corruption.
Attachments
Issue Links
- blocks
-
MDEV-26867 Merge new release of InnoDB 5.7.36 to 10.2
- Closed