Details
-
Bug
-
Status: Closed (View Workflow)
-
Blocker
-
Resolution: Fixed
-
10.2(EOL), 10.3(EOL), 10.4(EOL), 10.5, 10.6, 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
-
-
- Closed
-
Activity
| Transition | Time In Source Status | Execution Times |
|---|
|
3h | 1 |
|
12h 43m | 1 |
|
2d 23h 14m | 2 |
|
3d 3h 48m | 2 |
|
19h 3m | 1 |