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

rocksdb.index_merge_rocksdb2 fails with a wrong execution plan

    XMLWordPrintable

Details

    Description

      The failure seems to be deterministic on all versions, although the mismatch can be different for different versions.

      10.3 8ad3d0d0

      rocksdb.index_merge_rocksdb2 'write_committed' [ fail ]
              Test ended at 2022-05-28 00:30:15
       
      CURRENT_TEST: rocksdb.index_merge_rocksdb2
      --- /mnt8t/bld/10.3-enterprise-rel-nightly/mysql-test/plugin/rocksdb/rocksdb/r/index_merge_rocksdb2.result	2022-05-26 09:22:11.000000000 +0300
      +++ /mnt8t/bld/10.3-enterprise-rel-nightly/mysql-test/plugin/rocksdb/rocksdb/r/index_merge_rocksdb2.reject	2022-05-28 00:30:15.249921104 +0300
      @@ -187,7 +187,7 @@
       or
       ((key3 >=5 or key5 < 2) and (key5 < 5 or key6 < 6));
       id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
      -1	SIMPLE	t0	index_merge	i1,i2,i3,i5,i6	i3,i5	0,4	NULL	#	Using sort_union(i3,i5); Using where
      +1	SIMPLE	t0	ALL	i1,i2,i3,i5,i6	NULL	NULL	NULL	#	Using where
       select * from t0 where key1 < 3 or key8 < 2 order by key1;
       key1	key2	key3	key4	key5	key6	key7	key8
       1	1	1	1	1	1	1	1023
       
      mysqltest: Result length mismatch
      

      Attachments

        Activity

          People

            psergei Sergei Petrunia
            elenst Elena Stepanova
            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.