# # Bug#32831765 CREATE FULLTEXT INDEX fails with ERROR 1062 (23000): # Duplicate entry 'NULL-NULL' # CREATE TABLE tt ( `col1` varchar(255) DEFAULT NULL, `col2` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; CREATE PROCEDURE populate() BEGIN SET @rows = 30000; REPEAT INSERT INTO tt (col1, col2) VALUES ( 'tokens which repeat in the the first and second columns at the same positions', 'tokens which repeat in the the first and second columns at the same positions' ); SET @rows = @rows-1; UNTIL @rows=0 END REPEAT; END% CALL POPULATE; CREATE FULLTEXT INDEX search ON tt (col1, col2); Warnings: Warning 124 InnoDB rebuilding table to add column FTS_DOC_ID DROP PROCEDURE populate; DROP TABLE tt;