-- @author tungs1
-- @modified 2013-07-28 12:00:00
-- @created 2013-07-28 12:00:00
-- @description groupingfunction groupingfunc200.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 GROUPING(product.pname) as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY ROLLUP((sale.pn,product.pname)) ORDER BY g1) UNION (SELECT GROUPING(product.pname) as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY ROLLUP((sale.pn,product.pname)) ORDER BY g1))a;
psql:/data/tungs1_cdbfast/tincrepo/main/olap/groupingfunction/sql/../output/groupingfunc200_gucs.sql:12: LOG:  statement: select 'a', * from ((SELECT GROUPING(product.pname) as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY ROLLUP((sale.pn,product.pname)) ORDER BY g1) UNION (SELECT GROUPING(product.pname) as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY ROLLUP((sale.pn,product.pname)) ORDER BY g1))a;
psql:/data/tungs1_cdbfast/tincrepo/main/olap/groupingfunction/sql/../output/groupingfunc200_gucs.sql:12: LOG:  
[OPT]: Using default search strategy
psql:/data/tungs1_cdbfast/tincrepo/main/olap/groupingfunction/sql/../output/groupingfunc200_gucs.sql:12: LOG:  2013-11-08 10:05:32:255492 PST,THD000,TRACE,"CAutoTrace.cpp:53: [OPT]: Search terminated at stage 1/1",
psql:/data/tungs1_cdbfast/tincrepo/main/olap/groupingfunction/sql/../output/groupingfunc200_gucs.sql:12: LOG:  Query plan size to dispatch: 83KB
psql:/data/tungs1_cdbfast/tincrepo/main/olap/groupingfunction/sql/../output/groupingfunc200_gucs.sql:12: LOG:  statement: select 'a', * from ((SELECT GROUPING(product.pname) as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY ROLLUP((sale.pn,product.pname)) ORDER BY g1) UNION (SELECT GROUPING(product.pname) as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY ROLLUP((sale.pn,product.pname)) ORDER BY g1))a;  (entry db rh55-qavm20:5432 pid=26922)
psql:/data/tungs1_cdbfast/tincrepo/main/olap/groupingfunction/sql/../output/groupingfunc200_gucs.sql:12: LOG:  statement: select 'a', * from ((SELECT GROUPING(product.pname) as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY ROLLUP((sale.pn,product.pname)) ORDER BY g1) UNION (SELECT GROUPING(product.pname) as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY ROLLUP((sale.pn,product.pname)) ORDER BY g1))a;  (entry db rh55-qavm20:5432 pid=26919)
psql:/data/tungs1_cdbfast/tincrepo/main/olap/groupingfunction/sql/../output/groupingfunc200_gucs.sql:12: LOG:  Material node creates shareinput rwfile pgsql_tmp_SIRW_2937_5_0  (seg0 slice7 rh55-qavm19:40500 pid=27256)
psql:/data/tungs1_cdbfast/tincrepo/main/olap/groupingfunction/sql/../output/groupingfunc200_gucs.sql:12: LOG:  Material node creates shareinput rwfile pgsql_tmp_SIRW_2937_5_0  (seg1 slice7 rh55-qavm63:40500 pid=11406)
psql:/data/tungs1_cdbfast/tincrepo/main/olap/groupingfunction/sql/../output/groupingfunc200_gucs.sql:12: LOG:  Material Exec on CrossSlice, current slice 1  (seg0 slice1 rh55-qavm19:40500 pid=27260)
psql:/data/tungs1_cdbfast/tincrepo/main/olap/groupingfunction/sql/../output/groupingfunc200_gucs.sql:12: LOG:  Material Exec on CrossSlice, current slice 1  (seg1 slice1 rh55-qavm63:40500 pid=11410)
psql:/data/tungs1_cdbfast/tincrepo/main/olap/groupingfunction/sql/../output/groupingfunc200_gucs.sql:12: LOG:  Material node creates shareinput rwfile pgsql_tmp_SIRW_2937_5_1  (seg0 slice7 rh55-qavm19:40500 pid=27256)
psql:/data/tungs1_cdbfast/tincrepo/main/olap/groupingfunction/sql/../output/groupingfunc200_gucs.sql:12: LOG:  Material node creates shareinput rwfile pgsql_tmp_SIRW_2937_5_1  (seg1 slice7 rh55-qavm63:40500 pid=11406)
psql:/data/tungs1_cdbfast/tincrepo/main/olap/groupingfunction/sql/../output/groupingfunc200_gucs.sql:12: LOG:  Material Exec on CrossSlice, current slice 4  (seg0 slice4 rh55-qavm19:40500 pid=27264)
psql:/data/tungs1_cdbfast/tincrepo/main/olap/groupingfunction/sql/../output/groupingfunc200_gucs.sql:12: LOG:  Material Exec on CrossSlice, current slice 4  (seg1 slice4 rh55-qavm63:40500 pid=11414)
 ?column? | g1 
----------+----
 a        |  0
 a        |  1
(2 rows)