-- @author tungs1-- @modified 2013-07-28 12:00:00-- @created 2013-07-28 12:00:00-- @description groupingfunction groupingfunc206.sql-- @db_name groupingfunction-- @executemode normal-- @tags groupingfunction-- order 1-- start_ignoreSET optimizer_log=on;SET optimizer=on;SET client_min_messages='log';SETSETSET-- end_ignoreselect 'a', * from ((SELECT GROUPING(sale.pn) as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY ROLLUP((sale.pn,product.pname)) ORDER BY g1) UNION (SELECT GROUPING(sale.pn) 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/groupingfunc206_gucs.sql:12: LOG: statement: select 'a', * from ((SELECT GROUPING(sale.pn) as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY ROLLUP((sale.pn,product.pname)) ORDER BY g1) UNION (SELECT GROUPING(sale.pn) 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/groupingfunc206_gucs.sql:12: LOG: [OPT]: Using default search strategypsql:/data/tungs1_cdbfast/tincrepo/main/olap/groupingfunction/sql/../output/groupingfunc206_gucs.sql:12: LOG: 2013-11-08 10:05:52:544532 PST,THD000,TRACE,"CAutoTrace.cpp:53: [OPT]: Search terminated at stage 1/1",psql:/data/tungs1_cdbfast/tincrepo/main/olap/groupingfunction/sql/../output/groupingfunc206_gucs.sql:12: LOG: Query plan size to dispatch: 83KBpsql:/data/tungs1_cdbfast/tincrepo/main/olap/groupingfunction/sql/../output/groupingfunc206_gucs.sql:12: LOG: statement: select 'a', * from ((SELECT GROUPING(sale.pn) as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY ROLLUP((sale.pn,product.pname)) ORDER BY g1) UNION (SELECT GROUPING(sale.pn) 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=27336)psql:/data/tungs1_cdbfast/tincrepo/main/olap/groupingfunction/sql/../output/groupingfunc206_gucs.sql:12: LOG: statement: select 'a', * from ((SELECT GROUPING(sale.pn) as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY ROLLUP((sale.pn,product.pname)) ORDER BY g1) UNION (SELECT GROUPING(sale.pn) 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=27333)psql:/data/tungs1_cdbfast/tincrepo/main/olap/groupingfunction/sql/../output/groupingfunc206_gucs.sql:12: LOG: Material node creates shareinput rwfile pgsql_tmp_SIRW_2967_5_0 (seg1 slice7 rh55-qavm63:40500 pid=11679)psql:/data/tungs1_cdbfast/tincrepo/main/olap/groupingfunction/sql/../output/groupingfunc206_gucs.sql:12: LOG: Material node creates shareinput rwfile pgsql_tmp_SIRW_2967_5_0 (seg0 slice7 rh55-qavm19:40500 pid=27530)psql:/data/tungs1_cdbfast/tincrepo/main/olap/groupingfunction/sql/../output/groupingfunc206_gucs.sql:12: LOG: Material Exec on CrossSlice, current slice 1 (seg0 slice1 rh55-qavm19:40500 pid=27534)psql:/data/tungs1_cdbfast/tincrepo/main/olap/groupingfunction/sql/../output/groupingfunc206_gucs.sql:12: LOG: Material Exec on CrossSlice, current slice 1 (seg1 slice1 rh55-qavm63:40500 pid=11683)psql:/data/tungs1_cdbfast/tincrepo/main/olap/groupingfunction/sql/../output/groupingfunc206_gucs.sql:12: LOG: Material node creates shareinput rwfile pgsql_tmp_SIRW_2967_5_1 (seg1 slice7 rh55-qavm63:40500 pid=11679)psql:/data/tungs1_cdbfast/tincrepo/main/olap/groupingfunction/sql/../output/groupingfunc206_gucs.sql:12: LOG: Material node creates shareinput rwfile pgsql_tmp_SIRW_2967_5_1 (seg0 slice7 rh55-qavm19:40500 pid=27530)psql:/data/tungs1_cdbfast/tincrepo/main/olap/groupingfunction/sql/../output/groupingfunc206_gucs.sql:12: LOG: Material Exec on CrossSlice, current slice 4 (seg0 slice4 rh55-qavm19:40500 pid=27538)psql:/data/tungs1_cdbfast/tincrepo/main/olap/groupingfunction/sql/../output/groupingfunc206_gucs.sql:12: LOG: Material Exec on CrossSlice, current slice 4 (seg1 slice4 rh55-qavm63:40500 pid=11687) ?column? | g1 ----------+---- a | 0 a | 1(2 rows)
