Details
-
Technical task
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Won't Fix
-
10.2(EOL)
-
None
Description
https://github.com/MariaDB/server/tree/bb-10.2-alice/mysql-test/suite/innodb_fts/t/compatibility.test
test from mysql 5.7.
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');
|
also similar to compatibility_win.test https://github.com/MariaDB/server/blob/mdev-13626/mysql-test/suite/innodb_fts/t/compatibility_win.test