[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 - Jira

XML

Word

Printable

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Affects Version/s: 10.4
Fix Version/s: 10.4.32, 10.5.23, 10.6.16, 10.10.7, 10.11.6, 11.0.4, 11.1.3
Component/s: Optimizer
Labels:
None

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

People

Assignee:: Oleg Smirnov

Reporter:: Oleg Smirnov

Votes:: 0 Vote for this issue

Watchers:: 3 Start watching this issue

Dates

Created:: 2023-10-14 05:17

Updated:: 2023-11-06 13:36

Resolved:: 2023-10-25 10:11

Git Integration

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