Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
11.4, 11.8, 12.3, 13.0, 13.1
-
Can result in unexpected behaviour
Description
--source include/have_innodb.inc |
--source include/have_debug_sync.inc |
--echo # |
--echo # Online ADD INDEX on a virtual column which is not part of any index yet. |
--echo # A concurrent INSERT writes NULL for the virtual column into the new index. |
--echo # |
CREATE TABLE t (id INT PRIMARY KEY, k INT NOT NULL, v INT AS (k + 3) VIRTUAL) ENGINE=InnoDB; |
INSERT INTO t (id, k) VALUES (1, 1); |
--connect (con1,localhost,root,,test) |
SET DEBUG_SYNC = 'row_log_apply_before SIGNAL built WAIT_FOR go'; |
--send ALTER TABLE t ADD KEY iv (v) |
--connection default |
SET DEBUG_SYNC = 'now WAIT_FOR built'; |
INSERT INTO t (id, k) VALUES (2, 10); |
SET DEBUG_SYNC = 'now SIGNAL go'; |
--connection con1 |
--reap |
--disconnect con1 |
--connection default |
SET DEBUG_SYNC = 'RESET'; |
--echo # Correct result: (1,4) and (2,13) |
SELECT id, v FROM t FORCE INDEX (iv); |
CHECK TABLE t EXTENDED; |
DROP TABLE t; |
Leads to:
2026-09-23 7:20:01 4 [ERROR] InnoDB: Flagged corruption of `iv` in table `test`.`t` in CHECK TABLE; Wrong count
|
|
Bug Detection Matrix |
Rel o/d Build Commit UniqueID observed
|
CS 10.11 dbg 090926 2753b5919a10abd32ba822877c6a1cbf602d3748 No bug found
|
CS 10.11 opt 090926 2753b5919a10abd32ba822877c6a1cbf602d3748 No bug found
|
CS 11.4 dbg 090926 42038e1145dd43b3910055c364fb720a8a152d61 INNODB_ERROR|Flagged corruption of `iv` in table X.X in CHECK TABLE; Wrong count
|
CS 11.4 opt 090926 42038e1145dd43b3910055c364fb720a8a152d61 No bug found
|
CS 11.8 dbg 090926 e2e060ce3d8c3ce11b6c7ba28ced0f1a30c50a54 INNODB_ERROR|Flagged corruption of `iv` in table X.X in CHECK TABLE; Wrong count
|
CS 11.8 opt 090926 e2e060ce3d8c3ce11b6c7ba28ced0f1a30c50a54 No bug found
|
CS 12.3 dbg 090926 e9f84a1fdf7093191e55b55dc14b08b9d4ebaa20 INNODB_ERROR|Flagged corruption of `iv` in table X.X in CHECK TABLE; Wrong count
|
CS 12.3 opt 090926 e9f84a1fdf7093191e55b55dc14b08b9d4ebaa20 No bug found
|
CS 13.0 dbg 090926 b2c4e675049e23ce8c7346985f40840fcd4e583f INNODB_ERROR|Flagged corruption of `iv` in table X.X in CHECK TABLE; Wrong count
|
CS 13.0 opt 090926 b2c4e675049e23ce8c7346985f40840fcd4e583f No bug found
|
CS 13.1 dbg 090926 02c842c30dcb05a962eaac58c69920e6be3369cf INNODB_ERROR|Flagged corruption of `iv` in table X.X in CHECK TABLE; Wrong count
|
CS 13.1 opt 090926 02c842c30dcb05a962eaac58c69920e6be3369cf No bug found
|
ES 10.6 dbg 090926 aa3fb9800c358182ee2a1f8cca8ffbdd6d0a37eb INNODB_ERROR|Flagged corruption of `iv` in table X.X in CHECK TABLE; Wrong count
|
ES 10.6 opt 090926 aa3fb9800c358182ee2a1f8cca8ffbdd6d0a37eb No bug found
|
ES 11.4 dbg 090926 32807340954440071ca8ae8e2de51fb180d134c6 INNODB_ERROR|Flagged corruption of `iv` in table X.X in CHECK TABLE; Wrong count
|
ES 11.4 opt 090926 32807340954440071ca8ae8e2de51fb180d134c6 No bug found
|
ES 11.8 dbg 090926 c4af6f687a2dd983072457429aa2294f11957650 INNODB_ERROR|Flagged corruption of `iv` in table X.X in CHECK TABLE; Wrong count
|
ES 11.8 opt 090926 c4af6f687a2dd983072457429aa2294f11957650 No bug found
|
ES 12.3 dbg 090926 c3bd5108d81f19e33efb93f7b6ae971293732fd0 INNODB_ERROR|Flagged corruption of `iv` in table X.X in CHECK TABLE; Wrong count
|
ES 12.3 opt 090926 c3bd5108d81f19e33efb93f7b6ae971293732fd0 No bug found
|