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

SELECT with a complex WHERE clause is not using range access

    XMLWordPrintable

Details

    Description

      A single-table SELECT with a complex WHERE clause uses range access in MariaDB 5.2 and full table scan in MariaDB 10.3.22.

      (The query and table DDLs are available but they are customer' data. Dataset is not available but one doesn't need it to demonstrate the issue)

      Attachments

        Activity

          People

            mpflaum Maria M Pflaum
            psergei Sergei Petrunia
            Votes:
            2 Vote for this issue
            Watchers:
            6 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.