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)

Reply via email to