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

main.desc_index_range fails in bb, result length mismatch

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.8
    • 10.11
    • Optimizer, Tests
    • None

    Description

      https://buildbot.askmonty.org/buildbot/builders/winx64-packages/builds/30249

      main.desc_index_range 'innodb'           w4 [ fail ]
              Test ended at 2022-03-01 11:23:04
       
      CURRENT_TEST: main.desc_index_range
      --- D:/winx64-packages/build/src/mysql-test/main/desc_index_range.result	2022-03-01 10:22:18.000000000 +0000
      +++ D:\winx64-packages\build\src\mysql-test\main\desc_index_range.reject	2022-03-01 11:23:04.506052100 +0000
      @@ -207,7 +207,7 @@
       # Must use ROR-intersect:
       explain select * from t1 where b = 255 AND a IS NULL;
       id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
      -1	SIMPLE	t1	index_merge	a,b	b,a	5,5	NULL	1	Using intersect(b,a); Using where; Using index
      +1	SIMPLE	t1	ref	a,b	b	5	const	2	Using where
       select * from t1 where b = 255 AND a IS NULL;
       pk	a	b
       10000	NULL	255
       
      mysqltest: Result length mismatch
      

      Attachments

        Activity

          People

            psergei Sergei Petrunia
            alice Alice Sherepa
            Votes:
            0 Vote for this issue
            Watchers:
            3 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.