Details
Blocker Description
|
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
|
Attachments
Issue Links
- is caused by
-
MDEV-34993 Incorrect cardinality estimation causes poor query plan
-
- Closed
-