You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
{{ message }}
Repository navigation
Bug:CHECK INDEX assert failure on tables with FULLTEXT index #57
Running CHECK INDEX on an InnoDB table with a FULLTEXT index triggers an assert failure.
Root Cause
In ha_innobase::check_index(), the loop only skips indexes with DICT_FTS type flag, but does not skip the hidden FTS_DOC_ID_INDEX — a regular B-tree index created internally by InnoDB for FTS document ID lookups. When check_index tries to get physical info for this index, it asserts.
Reproduce
CREATE TABLE fts_test (
id bigint NOT NULL,
tran_time varchar(20) NOT NULL,
body text,
PRIMARY KEY (id, tran_time),
FULLTEXT KEY (tran_time, body)
) ENGINE=InnoDB;
CHECK INDEX FROM fts_test; -- assert failure
Fix
Skip FTS_DOC_ID_INDEX in the loop and emit a warning, same as done for DICT_FTS indexes.
Activity
huayichai commentedon Jun 4, 2026
#58