Details
-
Bug
-
Status: Closed
-
Major
-
Resolution: Fixed
-
None
Description
create temporary table mytable1 (x integer, y integer, z integer, a integer); explain cbo select z, x, count(distinct y), count(distinct a) from mytable1 group by z, x; explain cbo select count(distinct y), count(distinct a) from mytable1
The first is not vectorized, the second one is because of the grouping-set based rewrite for count distinct.
Attachments
Attachments
Issue Links
- links to