Karthikeyan Jambu Rajaraman created HAWQ-225:
------------------------------------------------
Summary: Add aggregate with grouping sets test to hawq
Key: HAWQ-225
URL: https://issues.apache.org/jira/browse/HAWQ-225
Project: Apache HAWQ
Issue Type: Test
Reporter: Karthikeyan Jambu Rajaraman
Assignee: Lei Chang
Add the below test in ICG and make sure it passes. We found this test was
failing in gpdb and want to make sure this pass in hawq.
SELECT type, prod, sum(quantity) s_quant
FROM
(
SELECT type, prod, quantity
FROM foo F1
LIMIT 3
) F2 GROUP BY GROUPING SETS((type, prod), (prod)) ORDER BY type, s_quant;
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)