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

main.index_intersect_innodb view protocol test flaky

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 12.3.2
    • 12.3
    • Tests, MTR
    • None

    Description

      12.3 view protocol

      CURRENT_TEST: main.index_intersect_innodb
      --- /home/buildbot/amd64-debian-12-debug-embedded/build/mysql-test/main/index_intersect_innodb.result	2026-07-21 05:31:43.000000000 +0000
      +++ /home/buildbot/amd64-debian-12-debug-embedded/build/mysql-test/main/index_intersect_innodb.reject	2026-07-21 05:44:55.303420721 +0000
      @@ -491,7 +491,7 @@
       WHERE ID BETWEEN 3001 AND 4000 AND Population > 600000
       AND Country BETWEEN 'S' AND 'Z' ;
       id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
      -1	SIMPLE	City	index_merge	PRIMARY,Population,Country	PRIMARY,Population	4,4	NULL	#	Using sort_intersect(PRIMARY,Population); Using where
      +1	SIMPLE	City	range	PRIMARY,Population,Country	PRIMARY	4	NULL	#	Using where
       SELECT * FROM City USE INDEX ()
       WHERE ID BETWEEN 501 AND 1000 AND Population > 700000 AND Country LIKE 'C%';
       ID	Name	Country	Population
      Result length mismatch
      

      Looks like MDEV-39673 - a stable statistics problem

      [Cross reference results](https://buildbot.mariadb.org/cr/?branch=&revision=&platform=&dt=&max_dt=&bbnum=&typ=&info=&test_name=main.index_intersect_innodb&test_variant=&info_text=&failure_text=&limit=100&sort_order=desc#).

      A few non-view protcol failures. Also 12.3+ seems to be mostly aarch64. Might be statistics too.

      Attachments

        Issue Links

          Activity

            People

              danblack Daniel Black
              danblack Daniel Black
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:

                Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0d
                  0d
                  Logged:
                  Time Spent - 0.25d
                  0.25d

                  Git Integration

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