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

10.5 ab15628bbc052d342c2cffa16c9e6c725f1b3563
main.selectivity_innodb_notembedded [ fail ]
Test ended at 2024-10-04 11:15:08

CURRENT_TEST: main.selectivity_innodb_notembedded
--- /mnt8t/bld/10.5-asan/mysql-test/main/selectivity_innodb_notembedded.result 2024-10-03 02:00:21.540538373 +0300
+++ /mnt8t/bld/10.5-asan/mysql-test/main/selectivity_innodb_notembedded.reject 2024-10-04 11:15:07.574245325 +0300
@@ -265,17 +265,17 @@
"considered_access_paths":
[
{
- "access_type": "range",
- "resulting_rows": 5,
- "cost": 6.666533161,
+ "access_type": "scan",
+ "resulting_rows": 2,
+ "cost": 2,
"chosen": true
}
],
"chosen_access_method":
{
- "type": "range",
- "records": 5,
- "cost": 6.666533161,
+ "type": "scan",
+ "records": 2,
+ "cost": 2,
"uses_join_buffering": false
}
}
@@ -319,17 +319,17 @@
"considered_access_paths":
[
{
- "access_type": "range",
- "resulting_rows": 181.3636545,
- "cost": 1.79769e308,
+ "access_type": "scan",
+ "resulting_rows": 2,
+ "cost": 2,
"chosen": true
}
],
"chosen_access_method":
{
- "type": "range",
- "records": 181.3636545,
- "cost": 1.79769e308,
+ "type": "scan",
+ "records": 2,
+ "cost": 2,
"uses_join_buffering": false
}
}

Result length mismatch

It also fails deterministically in the buildbot, since

commit 8166a5d33dda510f3c51341112742064d581a6c3

Author: Sergei Petrunia

Date:   Tue Sep 24 09:44:39 2024 +0300

    MDEV-34993: Incorrect cardinality estimation causes poor query plan

is caused by

MDEV-34993 Incorrect cardinality estimation causes poor query plan

There are no comments yet on this issue.

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

MariaDB Server