CURRENT_TEST: innodb_fts.compatibility

mysqltest: At line 96: query 'SELECT * FROM t1 WHERE MATCH(a, b) AGAINST ('TEST2')' succeeded - should have failed with errno 1764...

The result from queries just before the failure was:

< snip >

FTS_0	test/FTS_AUX_INDEX_6

FTS_0	test/FTS_AUX_BEING_DELETED

FTS_0	test/FTS_AUX_BEING_DELETED_CACHE

FTS_0	test/FTS_AUX_CONFIG

FTS_0	test/FTS_AUX_DELETED

FTS_0	test/FTS_AUX_DELETED_CACHE

DROP TABLE t1;

# Non windows aux table flag failure and rebuild the corrupted index.

call mtr.add_suppression("\\[Warning\\] InnoDB: Parent table of FTS auxiliary table .* not found.");

call mtr.add_suppression("\\[Warning\\] InnoDB: Setting aux table .* to hex format failed.");

call mtr.add_suppression("\\[ERROR\\] InnoDB: Index .* of table .* is corrupted");

SET GLOBAL DEBUG_DBUG='+d,innodb_test_wrong_fts_aux_table_name';

CREATE TABLE t1(a TEXT, b TEXT, c TEXT, FULLTEXT `AB` (a, b), FULLTEXT `C1` (c));

INSERT INTO t1 VALUES('TEST1', 'TEST2', 'TEXT3');

INSERT INTO t1 VALUES('TEXT1', 'TEXT2', 'TEXT5');

SELECT * FROM t1 WHERE MATCH(a, b) AGAINST ('TEST2');

a	b	c

SELECT * FROM t1 WHERE MATCH(c) AGAINST ('TEXT5');

a	b	c

SELECT * FROM t1 WHERE MATCH(a, b) AGAINST ('TEST2');