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

main.range_vs_index_merge_innodb is flaky

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Cannot Reproduce
    • 10.0.19
    • N/A
    • Tests, MTR
    • None

    Description

      The 'main.range_vs_index_merge_innodb' test relies upon EXPLAIN SELECT statements being deterministic, however with InnoDB this is not the case. Not only do the row counts given change (being estimates), but the query plan can as well.

      When, for instance, there are several possible indices, the query plan may select any of them:

      @@ -761,7 +761,7 @@
       EXPLAIN
       SELECT * FROM City WHERE Country='BRA';
       id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
      -1	SIMPLE	City	ref	Country,CountryPopulation,CountryName	Country	3	const	#	Using index condition
      +1	SIMPLE	City	ref	Country,CountryPopulation,CountryName	CountryPopulation	3	const	#	Using index condition

      Is the InnoDB version of this test required or would the normal 'main.range_vs_index_merge' test suffice for verifying the behaviour of the optimizer?

      Attachments

        Activity

          People

            psergei Sergei Petrunia
            davidgow David Gow
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

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