Details
-
Bug
-
Resolution: Fixed
-
Major
-
Cheshire-Cat
-
Untriaged
-
MacOSX 64-bit
-
KS1 data can be obtained from backup on 172.23.123.167 in /tmp/backup
-
1
-
Yes
Description
Overall cost/cardinality information is missing in explain plans for queries involving limit, order by, group by, sort, and other operators after processing of scans/joins.
A simple example to reproduce the problem is:
explain SELECT x.u016_i FROM KS1 x WHERE x.uniq_i = 1000 LIMIT 25;
Attachments
For Gerrit Dashboard: MB-43218 | ||||||
---|---|---|---|---|---|---|
# | Subject | Branch | Project | Status | CR | V |
142212,2 | MB-43218 Fix SORT/LIMIT/OFFSET cost | master | query | Status: MERGED | +2 | +1 |
142213,2 | MB-43218 Fix SORT/LIMIT/OFFSET cost | master | query-ee | Status: MERGED | +2 | +1 |
142956,2 | MB-43499 Add document size and first-result cost to plan operators | master | query | Status: MERGED | +2 | +1 |
142957,2 | MB-43499 Add document size and first-result cost to plan operators | master | query-ee | Status: MERGED | +2 | +1 |