Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-13626 Merge InnoDB test cases from MySQL 5.7
  3. MDEV-14232

innodb_fts.index_table test failed, result mismatch

    XMLWordPrintable

    Details

      Description

      https://github.com/MariaDB/server/tree/bb-10.2-alice/mysql-test/suite/innodb_fts/t/index_table.test
      results from mysql 5.7 differ from MariaDB, needs a check which of them are correct

      CURRENT_TEST: innodb_fts.index_table
      --- /home/alice/aliska/10.2/mysql-test/suite/innodb_fts/r/index_table.result	2017-06-22 16:13:19.000000000 +0200
      +++ /home/alice/aliska/10.2/mysql-test/suite/innodb_fts/r/index_table.reject	2017-10-31 13:38:33.669007403 +0100
      @@ -16,111 +16,111 @@
       SET GLOBAL innodb_ft_aux_table="test/articles";
       SELECT * FROM INFORMATION_SCHEMA.INNODB_FT_INDEX_CACHE;
       WORD	FIRST_DOC_ID	LAST_DOC_ID	DOC_COUNT	DOC_ID	POSITION
      -1001	6	6	1	6	0
      -after	4	4	1	4	22
      -database	3	3	1	3	37
      -dbms	3	3	1	3	15
      -engine	6	7	2	6	46
      -engine	6	7	2	7	44
      -full	6	7	2	6	29
      -full	6	7	2	7	27
      -mysql	3	7	5	3	0
      -mysql	3	7	5	3	31
      -mysql	3	7	5	4	11
      -mysql	3	7	5	5	11
      -mysql	3	7	5	6	5
      -mysql	3	7	5	7	3
      -optimizing	5	5	1	5	0
      -search	6	7	2	6	39
      -search	6	7	2	7	37
      -show	5	5	1	5	42
      -stands	3	3	1	3	20
      -text	6	7	2	6	34
      -text	6	7	2	7	32
      -through	4	4	1	4	37
      -tricks	6	7	2	6	11
      -tricks	6	7	2	7	9
      -tutorial	3	5	2	3	6
      -tutorial	3	5	2	5	25
      -use	4	7	3	4	7
      -use	4	7	3	6	25
      -use	4	7	3	7	23
      -well	4	4	1	4	17
      -went	4	4	1	4	32
      -you	4	4	1	4	28
      +1001	5	5	1	5	0
      +after	3	3	1	3	22
      +database	2	2	1	2	37
      +dbms	2	2	1	2	15
      +engine	5	6	2	5	46
      +engine	5	6	2	6	44
      +full	5	6	2	5	29
      +full	5	6	2	6	27
      +mysql	2	6	5	2	0
      +mysql	2	6	5	2	31
      +mysql	2	6	5	3	11
      +mysql	2	6	5	4	11
      +mysql	2	6	5	5	5
      +mysql	2	6	5	6	3
      +optimizing	4	4	1	4	0
      +search	5	6	2	5	39
      +search	5	6	2	6	37
      +show	4	4	1	4	42
      +stands	2	2	1	2	20
      +text	5	6	2	5	34
      +text	5	6	2	6	32
      +through	3	3	1	3	37
      +tricks	5	6	2	5	11
      +tricks	5	6	2	6	9
      +tutorial	2	4	2	2	6
      +tutorial	2	4	2	4	25
      +use	3	6	3	3	7
      +use	3	6	3	5	25
      +use	3	6	3	6	23
      +well	3	3	1	3	17
      +went	3	3	1	3	32
      +you	3	3	1	3	28
       OPTIMIZE TABLE articles;
       Table	Op	Msg_type	Msg_text
       test.articles	optimize	status	OK
       SELECT * FROM INFORMATION_SCHEMA.INNODB_FT_INDEX_TABLE;
       WORD	FIRST_DOC_ID	LAST_DOC_ID	DOC_COUNT	DOC_ID	POSITION
      -1001	6	6	1	6	0
      -after	4	4	1	4	22
      -database	3	3	1	3	37
      -dbms	3	3	1	3	15
      -engine	6	7	2	6	46
      -engine	6	7	2	7	44
      -full	6	7	2	6	29
      -full	6	7	2	7	27
      -mysql	3	7	5	3	0
      -mysql	3	7	5	3	31
      -mysql	3	7	5	4	11
      -mysql	3	7	5	5	11
      -mysql	3	7	5	6	5
      -mysql	3	7	5	7	3
      -optimizing	5	5	1	5	0
      -search	6	7	2	6	39
      -search	6	7	2	7	37
      -show	5	5	1	5	42
      -stands	3	3	1	3	20
      -text	6	7	2	6	34
      -text	6	7	2	7	32
      -through	4	4	1	4	37
      -tricks	6	7	2	6	11
      -tricks	6	7	2	7	9
      -tutorial	3	5	2	3	6
      -tutorial	3	5	2	5	25
      -use	4	7	3	4	7
      -use	4	7	3	6	25
      -use	4	7	3	7	23
      -well	4	4	1	4	17
      -went	4	4	1	4	32
      -you	4	4	1	4	28
      -SET SESSION debug="+d,fts_instrument_result_cache_limit";
      +1001	5	5	1	5	0
      +after	3	3	1	3	22
      +database	2	2	1	2	37
      +dbms	2	2	1	2	15
      +engine	5	6	2	5	46
      +engine	5	6	2	6	44
      +full	5	6	2	5	29
      +full	5	6	2	6	27
      +mysql	2	6	5	2	0
      +mysql	2	6	5	2	31
      +mysql	2	6	5	3	11
      +mysql	2	6	5	4	11
      +mysql	2	6	5	5	5
      +mysql	2	6	5	6	3
      +optimizing	4	4	1	4	0
      +search	5	6	2	5	39
      +search	5	6	2	6	37
      +show	4	4	1	4	42
      +stands	2	2	1	2	20
      +text	5	6	2	5	34
      +text	5	6	2	6	32
      +through	3	3	1	3	37
      +tricks	5	6	2	5	11
      +tricks	5	6	2	6	9
      +tutorial	2	4	2	2	6
      +tutorial	2	4	2	4	25
      +use	3	6	3	3	7
      +use	3	6	3	5	25
      +use	3	6	3	6	23
      +well	3	3	1	3	17
      +went	3	3	1	3	32
      +you	3	3	1	3	28
      +SET SESSION debug_dbug="+d,fts_instrument_result_cache_limit";
       SELECT * FROM INFORMATION_SCHEMA.INNODB_FT_INDEX_TABLE;
       WORD	FIRST_DOC_ID	LAST_DOC_ID	DOC_COUNT	DOC_ID	POSITION
      -1001	6	6	1	6	0
      -after	4	4	1	4	22
      -database	3	3	1	3	37
      -dbms	3	3	1	3	15
      -engine	6	7	2	6	46
      -engine	6	7	2	7	44
      -full	6	7	2	6	29
      -full	6	7	2	7	27
      -mysql	3	7	5	3	0
      -mysql	3	7	5	3	31
      -mysql	3	7	5	4	11
      -mysql	3	7	5	5	11
      -mysql	3	7	5	6	5
      -mysql	3	7	5	7	3
      -optimizing	5	5	1	5	0
      -search	6	7	2	6	39
      -search	6	7	2	7	37
      -show	5	5	1	5	42
      -stands	3	3	1	3	20
      -text	6	7	2	6	34
      -text	6	7	2	7	32
      -through	4	4	1	4	37
      -tricks	6	7	2	6	11
      -tricks	6	7	2	7	9
      -tutorial	3	5	2	3	6
      -tutorial	3	5	2	5	25
      -use	4	7	3	4	7
      -use	4	7	3	6	25
      -use	4	7	3	7	23
      -well	4	4	1	4	17
      -went	4	4	1	4	32
      -you	4	4	1	4	28
      -SET SESSION debug="-d,fts_instrument_result_cache_limit";
      +1001	5	5	1	5	0
      +after	3	3	1	3	22
      +database	2	2	1	2	37
      +dbms	2	2	1	2	15
      +engine	5	6	2	5	46
      +engine	5	6	2	6	44
      +full	5	6	2	5	29
      +full	5	6	2	6	27
      +mysql	2	6	5	2	0
      +mysql	2	6	5	2	31
      +mysql	2	6	5	3	11
      +mysql	2	6	5	4	11
      +mysql	2	6	5	5	5
      +mysql	2	6	5	6	3
      +optimizing	4	4	1	4	0
      +search	5	6	2	5	39
      +search	5	6	2	6	37
      +show	4	4	1	4	42
      +stands	2	2	1	2	20
      +text	5	6	2	5	34
      +text	5	6	2	6	32
      +through	3	3	1	3	37
      +tricks	5	6	2	5	11
      +tricks	5	6	2	6	9
      +tutorial	2	4	2	2	6
      +tutorial	2	4	2	4	25
      +use	3	6	3	3	7
      +use	3	6	3	5	25
      +use	3	6	3	6	23
      +well	3	3	1	3	17
      +went	3	3	1	3	32
      +you	3	3	1	3	28
      +SET SESSION debug_dbug="-d,fts_instrument_result_cache_limit";
       DROP TABLE articles;
       SET GLOBAL innodb_ft_result_cache_limit=default;
       CREATE TABLE articles (
      @@ -140,76 +140,76 @@
       ('Go MySQL Tricks','How to use full text search engine');
       SELECT * FROM INFORMATION_SCHEMA.INNODB_FT_INDEX_CACHE;
       WORD	FIRST_DOC_ID	LAST_DOC_ID	DOC_COUNT	DOC_ID	POSITION
      -1001	6	6	1	6	0
      -mysql	3	7	5	3	0
      -mysql	3	7	5	4	11
      -mysql	3	7	5	5	11
      -mysql	3	7	5	6	5
      -mysql	3	7	5	7	3
      -optimizing	5	5	1	5	0
      -tricks	6	7	2	6	11
      -tricks	6	7	2	7	9
      -tutorial	3	3	1	3	6
      -use	4	4	1	4	7
      -well	4	4	1	4	17
      -after	4	4	1	4	0
      -database	3	3	1	3	22
      -dbms	3	3	1	3	0
      -engine	6	7	2	6	28
      -engine	6	7	2	7	28
      -full	6	7	2	6	11
      -full	6	7	2	7	11
      -mysql	3	3	1	3	16
      -search	6	7	2	6	21
      -search	6	7	2	7	21
      -show	5	5	1	5	25
      -stands	3	3	1	3	5
      -text	6	7	2	6	16
      -text	6	7	2	7	16
      -through	4	4	1	4	15
      -tutorial	5	5	1	5	8
      -use	6	7	2	6	7
      -use	6	7	2	7	7
      -went	4	4	1	4	10
      -you	4	4	1	4	6
      +1001	5	5	1	5	0
      +mysql	2	6	5	2	0
      +mysql	2	6	5	3	11
      +mysql	2	6	5	4	11
      +mysql	2	6	5	5	5
      +mysql	2	6	5	6	3
      +optimizing	4	4	1	4	0
      +tricks	5	6	2	5	11
      +tricks	5	6	2	6	9
      +tutorial	2	2	1	2	6
      +use	3	3	1	3	7
      +well	3	3	1	3	17
      +after	3	3	1	3	0
      +database	2	2	1	2	22
      +dbms	2	2	1	2	0
      +engine	5	6	2	5	28
      +engine	5	6	2	6	28
      +full	5	6	2	5	11
      +full	5	6	2	6	11
      +mysql	2	2	1	2	16
      +search	5	6	2	5	21
      +search	5	6	2	6	21
      +show	4	4	1	4	25
      +stands	2	2	1	2	5
      +text	5	6	2	5	16
      +text	5	6	2	6	16
      +through	3	3	1	3	15
      +tutorial	4	4	1	4	8
      +use	5	6	2	5	7
      +use	5	6	2	6	7
      +went	3	3	1	3	10
      +you	3	3	1	3	6
       SET GLOBAL innodb_ft_aux_table="test/articles";
       OPTIMIZE TABLE articles;
       Table	Op	Msg_type	Msg_text
       test.articles	optimize	status	OK
       SELECT * FROM INFORMATION_SCHEMA.INNODB_FT_INDEX_TABLE;
       WORD	FIRST_DOC_ID	LAST_DOC_ID	DOC_COUNT	DOC_ID	POSITION
      -1001	6	6	1	6	0
      -mysql	3	7	5	3	0
      -mysql	3	7	5	4	11
      -mysql	3	7	5	5	11
      -mysql	3	7	5	6	5
      -mysql	3	7	5	7	3
      -optimizing	5	5	1	5	0
      -tricks	6	7	2	6	11
      -tricks	6	7	2	7	9
      -tutorial	3	3	1	3	6
      -use	4	4	1	4	7
      -well	4	4	1	4	17
      -after	4	4	1	4	0
      -database	3	3	1	3	22
      -dbms	3	3	1	3	0
      -engine	6	7	2	6	28
      -engine	6	7	2	7	28
      -full	6	7	2	6	11
      -full	6	7	2	7	11
      -mysql	3	3	1	3	16
      -search	6	7	2	6	21
      -search	6	7	2	7	21
      -show	5	5	1	5	25
      -stands	3	3	1	3	5
      -text	6	7	2	6	16
      -text	6	7	2	7	16
      -through	4	4	1	4	15
      -tutorial	5	5	1	5	8
      -use	6	7	2	6	7
      -use	6	7	2	7	7
      -went	4	4	1	4	10
      -you	4	4	1	4	6
      +1001	5	5	1	5	0
      +mysql	2	6	5	2	0
      +mysql	2	6	5	3	11
      +mysql	2	6	5	4	11
      +mysql	2	6	5	5	5
      +mysql	2	6	5	6	3
      +optimizing	4	4	1	4	0
      +tricks	5	6	2	5	11
      +tricks	5	6	2	6	9
      +tutorial	2	2	1	2	6
      +use	3	3	1	3	7
      +well	3	3	1	3	17
      +after	3	3	1	3	0
      +database	2	2	1	2	22
      +dbms	2	2	1	2	0
      +engine	5	6	2	5	28
      +engine	5	6	2	6	28
      +full	5	6	2	5	11
      +full	5	6	2	6	11
      +mysql	2	2	1	2	16
      +search	5	6	2	5	21
      +search	5	6	2	6	21
      +show	4	4	1	4	25
      +stands	2	2	1	2	5
      +text	5	6	2	5	16
      +text	5	6	2	6	16
      +through	3	3	1	3	15
      +tutorial	4	4	1	4	8
      +use	5	6	2	5	7
      +use	5	6	2	6	7
      +went	3	3	1	3	10
      +you	3	3	1	3	6
       DROP TABLE articles;
       SET NAMES utf8;
       CREATE TABLE articles (
      @@ -224,19 +224,19 @@
       SET GLOBAL innodb_ft_aux_table="test/articles";
       SELECT * FROM INFORMATION_SCHEMA.INNODB_FT_INDEX_CACHE;
       WORD	FIRST_DOC_ID	LAST_DOC_ID	DOC_COUNT	DOC_ID	POSITION
      -充满可爱	5	5	1	5	0
      -怜香惜爱	4	4	1	4	0
      -爱恨交织	6	6	1	6	0
      -相亲相爱	3	3	1	3	0
      +充满可爱	4	4	1	4	0
      +怜香惜爱	3	3	1	3	0
      +爱恨交织	5	5	1	5	0
      +相亲相爱	2	2	1	2	0
       OPTIMIZE TABLE articles;
       Table	Op	Msg_type	Msg_text
       test.articles	optimize	status	OK
       SELECT * FROM INFORMATION_SCHEMA.INNODB_FT_INDEX_TABLE;
       WORD	FIRST_DOC_ID	LAST_DOC_ID	DOC_COUNT	DOC_ID	POSITION
      -充满可爱	5	5	1	5	0
      -怜香惜爱	4	4	1	4	0
      -爱恨交织	6	6	1	6	0
      -相亲相爱	3	3	1	3	0
      +充满可爱	4	4	1	4	0
      +怜香惜爱	3	3	1	3	0
      +爱恨交织	5	5	1	5	0
      +相亲相爱	2	2	1	2	0
       DROP TABLE articles;
       CREATE TABLE articles (
       id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
      @@ -250,19 +250,19 @@
       SET GLOBAL innodb_ft_aux_table="test/articles";
       SELECT * FROM INFORMATION_SCHEMA.INNODB_FT_INDEX_CACHE;
       WORD	FIRST_DOC_ID	LAST_DOC_ID	DOC_COUNT	DOC_ID	POSITION
      -爱恨交织	6	6	1	6	0
      -充满可爱	5	5	1	5	0
      -怜香惜爱	4	4	1	4	0
      -相亲相爱	3	3	1	3	0
      +爱恨交织	5	5	1	5	0
      +充满可爱	4	4	1	4	0
      +怜香惜爱	3	3	1	3	0
      +相亲相爱	2	2	1	2	0
       OPTIMIZE TABLE articles;
       Table	Op	Msg_type	Msg_text
       test.articles	optimize	status	OK
       SELECT * FROM INFORMATION_SCHEMA.INNODB_FT_INDEX_TABLE;
       WORD	FIRST_DOC_ID	LAST_DOC_ID	DOC_COUNT	DOC_ID	POSITION
      -怜香惜爱	4	4	1	4	0
      -充满可爱	5	5	1	5	0
      -相亲相爱	3	3	1	3	0
      -爱恨交织	6	6	1	6	0
      +怜香惜爱	3	3	1	3	0
      +充满可爱	4	4	1	4	0
      +相亲相爱	2	2	1	2	0
      +爱恨交织	5	5	1	5	0
       DROP TABLE articles;
       SET GLOBAL innodb_ft_aux_table=default;
       SET GLOBAL INNODB_OPTIMIZE_FULLTEXT_ONLY=default;
       
      mysqltest: Result length mismatch
      
      

        Attachments

          Activity

            People

            Assignee:
            Unassigned Unassigned
            Reporter:
            alice Alice Sherepa
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.