groupingfunc217.ans

-- @author tungs1
-- @modified 2013-07-28 12:00:00
-- @created 2013-07-28 12:00:00
-- @description groupingfunction groupingfunc217.sql
-- @db_name groupingfunction
-- @executemode normal
-- @tags groupingfunction
-- order 1
-- start_ignore
SET optimizer_log=on;SET optimizer=on;SET client_min_messages='log';
SET
SET
SET
-- end_ignore
select 'a', * from ((SELECT SUM(sale.pn) as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY GROUPING SETS ((sale.pn) ,(product.pname, sale.pn)) ORDER BY g1) UNION (SELECT SUM(sale.pn) as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY GROUPING SETS ((sale.pn) ,(product.pname, sale.pn)) ORDER BY g1))a;
psql:/data/tungs1_cdbfast/tincrepo/main/olap/groupingfunction/sql/../output/groupingfunc217_gucs.sql:12: LOG:  statement: select 'a', * from ((SELECT SUM(sale.pn) as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY GROUPING SETS ((sale.pn) ,(product.pname, sale.pn)) ORDER BY g1) UNION (SELECT SUM(sale.pn) as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY GROUPING SETS ((sale.pn) ,(product.pname, sale.pn)) ORDER BY g1))a;
psql:/data/tungs1_cdbfast/tincrepo/main/olap/groupingfunction/sql/../output/groupingfunc217_gucs.sql:12: LOG:  
[OPT]: Using default search strategy
psql:/data/tungs1_cdbfast/tincrepo/main/olap/groupingfunction/sql/../output/groupingfunc217_gucs.sql:12: LOG:  2013-11-08 10:07:09:652118 PST,THD000,TRACE,"CAutoTrace.cpp:53: [OPT]: Search terminated at stage 1/1",
psql:/data/tungs1_cdbfast/tincrepo/main/olap/groupingfunction/sql/../output/groupingfunc217_gucs.sql:12: LOG:  Query plan size to dispatch: 41KB
 ?column? |  g1  
----------+------
 a        |  400
 a        |  800
 a        |  300
 a        | 1000
 a        |  200
 a        |  600
 a        |  700
(7 rows)