Details

    • Technical task
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Won't Fix
    • 10.2(EOL)
    • N/A
    • Tests
    • 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

      Attachments

        Activity

          People

            marko Marko Mäkelä
            alice Alice Sherepa
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.