[MDEV-34993] Incorrect cardinality estimation causes poor query plan - Jira

XML

Word

Printable

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Affects Version/s: 10.5
Fix Version/s: 10.5.27, 10.6.20, 10.11.10, 11.2.6, 11.4.4
Component/s: Optimizer
Labels:
None

Description

Filing this based on investigation in TODO-4922.

There is a class of known issues one can observe with optimizer_use_condition_selectivity=3 setting. MariaDB 11.0 has a rewrite of relevant code.

This MDEV is about making a minimal fix to stop pre-11.0 versions from picking very poor query plans.

Attachments

Issue Links

causes

MDEV-35074 main.selectivity_notembedded and main.selectivity_innodb_notembedded fail with view protocol

Closed

Activity

People

Assignee:: Sergei Petrunia

Reporter:: Sergei Petrunia

Votes:: 0 Vote for this issue

Watchers:: 5 Start watching this issue

Dates

Created:: 2024-09-24 05:13

Updated:: 2024-10-16 13:46

Resolved:: 2024-10-04 09:28

Git Integration

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