http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/d73117ed/src/test/regress/known_good_schedule ---------------------------------------------------------------------- diff --git a/src/test/regress/known_good_schedule b/src/test/regress/known_good_schedule index 51c1a6d..afd70ff 100755 --- a/src/test/regress/known_good_schedule +++ b/src/test/regress/known_good_schedule @@ -50,8 +50,6 @@ ignore: constraints ignore: triggers ignore: create_misc test: create_aggregate -test: aggregate_with_groupingsets -test: aggregates_null ignore: create_operator ignore: create_index ignore: drop_if_exists
http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/d73117ed/src/test/regress/sql/aggregate_with_groupingsets.sql ---------------------------------------------------------------------- diff --git a/src/test/regress/sql/aggregate_with_groupingsets.sql b/src/test/regress/sql/aggregate_with_groupingsets.sql deleted file mode 100644 index 9db642b..0000000 --- a/src/test/regress/sql/aggregate_with_groupingsets.sql +++ /dev/null @@ -1,32 +0,0 @@ ---- ---- Drop existing table ---- -DROP TABLE IF EXISTS foo; - ---- ---- Create new table foo ---- -CREATE TABLE foo(type INTEGER, prod VARCHAR, quantity NUMERIC); - ---- ---- Insert some value ---- -INSERT INTO foo VALUES(1, 'Table', 100); -INSERT INTO foo VALUES(2, 'Chair', 250); -INSERT INTO foo VALUES(3, 'Bed', 300); - ---- ---- Select query with grouping sets ---- -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; - ---- ---- Drop created table ---- -DROP TABLE IF EXISTS foo; \ No newline at end of file
