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

test_if_skip_sort_order() should catch the join types JT_EQ_REF, JT_CONST and JT_SYSTEM and skip sort order for these

Details

    Description

      In TODO-4276 a customer faced an issue when an efficient "eq_ref" access was replaced with "index" access due to present ORDER BY clause. Such replacements must not happen for JT_EQ_REF, JT_CONST and JT_SYSTEM join types.

      Attachments

        Activity

          Transition Time In Source Status Execution Times
          Oleg Smirnov made transition -
          Open In Progress
          		8m 52s 1
          Oleg Smirnov made transition -
          In Progress In Review
          		4d 8h 21m 1
          Oleg Smirnov made transition -
          Stalled In Review
          		3d 16h 40m 1
          Sergei Petrunia made transition -
          In Review Stalled
          		3d 1h 10m 2
          Oleg Smirnov made transition -
          Stalled Closed
          		2h 33m 1

          People

            oleg.smirnov Oleg Smirnov
            oleg.smirnov Oleg Smirnov
            Votes:
            0 Vote for this issue
            Watchers:
            3 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.