Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
11.0.0
-
None
Description
explain SELECT c_custkey, c_name AS currency2 FROM partsupp LEFT JOIN part ON (
p_partkey = ps_partkey ) JOIN supplier ON (s_suppkey = ps_suppkey) JOIN lineite
m ON ( ps_suppkey = l_suppkey ) JOIN orders ON ( l_orderkey = o_orderkey ) JOIN
customer ON ( o_custkey = c_custkey ) HAVING c_custkey > 150;
In 11.0 shows the table 'part' which should have been eliminated.
This also causes a small degradation in performance.
Attachments
Issue Links
- is part of
-
MDEV-26974 Improve selectivity and related costs in optimizer
- Closed