Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-38343

Test innodb_fts.misc_1 and other InnoDB full-text search tests fail on result mismatch on arch hppa and powerpc

    XMLWordPrintable

Details

    • Unexpected results

    Description

      While running big-test on MariaDB 11.8.5 I saw this failure in both hppa and powerpc:

      innodb_fts.misc_1 '16k'                  w2 [ fail ]
              Test ended at 2025-12-13 02:51:04
       
      CURRENT_TEST: innodb_fts.misc_1
      --- /build/reproducible-path/mariadb-11.8.5/mysql-test/suite/innodb_fts/r/misc_1.result	2025-11-13 08:45:30.000000000 +0000
      +++ /build/reproducible-path/mariadb-11.8.5/mysql-test/suite/innodb_fts/r/misc_1.reject	2025-12-13 02:51:04.317953087 +0000
      @@ -590,10 +590,15 @@
       AGAINST ('"proximity search"@2' IN BOOLEAN MODE);
       id	a	b
       8	test proximity search, test, proximity and phrase	search, with proximity innodb
      +9	test proximity fts search, test, proximity and phrase	search, with proximity innodb
      +10	test more proximity fts search, test, more proximity and phrase	search, with proximity innodb
       SELECT * FROM t1
       WHERE MATCH (a,b)
       AGAINST ('"proximity search"@1' IN BOOLEAN MODE);
       id	a	b
      +8	test proximity search, test, proximity and phrase	search, with proximity innodb
      +9	test proximity fts search, test, proximity and phrase	search, with proximity innodb
      +10	test more proximity fts search, test, more proximity and phrase	search, with proximity innodb
       SELECT * FROM t1
       WHERE MATCH (a,b)
       AGAINST ('"proximity search"@3' IN BOOLEAN MODE) ORDER BY id;
      @@ -612,6 +617,7 @@
       WHERE MATCH (a,b)
       AGAINST ('"more test proximity"@2' IN BOOLEAN MODE);
       id	a	b
      +10	test more proximity fts search, test, more proximity and phrase	search, with proximity innodb
       SELECT * FROM t1
       WHERE MATCH (a,b)
       AGAINST ('"more test proximity"@3' IN BOOLEAN MODE);
      @@ -715,6 +721,7 @@
       WHERE MATCH (a,b)
       AGAINST ('"あさきゆめみじ ゑひもせず"@1' IN BOOLEAN MODE);
       id	a	b
      +7	いろはにほへど ちりぬる	あさきゆめみじ ゑひもせず
       SELECT * FROM t1
       WHERE MATCH (a,b)
       AGAINST ('"あさきゆめみじ ゑひもせず"@2' IN BOOLEAN MODE);
       
      Result length mismatch
      

      Full logs

      Also these tests had result mismatches that I suspect all have the same root cause related to the architectures:

      • innodb_fts.basic
      • innodb_fts.fulltext
      • innodb_fts.innodb_fts_large_records
      • innodb_fts.innodb_fts_misc_1
      • innodb_fts.innodb_fts_multiple_index
      • innodb_fts.innodb_fts_proximity
      • innodb_fts.misc
      • innodb_fts.misc_1
      • innodb_fts.multiple_index
      • innodb_fts.opt
      • innodb_fts.phrase

      Attachments

        Activity

          People

            thiru Thirunarayanan Balathandayuthapani
            otto Otto Kekäläinen
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

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