hawq-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From paul...@apache.org
Subject [1/4] incubator-hawq git commit: HAWQ-870. Allocate target's tuple table slot in PortalHeapMemory during split partition
Date Mon, 19 Dec 2016 02:23:45 GMT
Repository: incubator-hawq
Updated Branches:
  refs/heads/master 111655e36 -> b32e56c50


http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/b32e56c5/src/test/regress/sql/partition.sql
----------------------------------------------------------------------
diff --git a/src/test/regress/sql/partition.sql b/src/test/regress/sql/partition.sql
index 9fa893c..6f8ba2c 100644
--- a/src/test/regress/sql/partition.sql
+++ b/src/test/regress/sql/partition.sql
@@ -4924,3 +4924,21 @@ insert into  t values(1,2,'a');
 select * from t;
 -- END MPP-19105
 reset optimizer_nestloop_factor;
+
+-- Test split default partition while per tuple memory context is reset 
+-- Origin GPDB PR: https://github.com/greenplum-db/gpdb/pull/866
+drop table if exists test_split_part cascade;
+
+CREATE TABLE test_split_part ( log_id int NOT NULL, f_array int[] NOT NULL)
+DISTRIBUTED BY (log_id)
+PARTITION BY RANGE(log_id)
+(
+	START (1::int) END (100::int) EVERY (5),
+	PARTITION "old" START (101::int) END (201::int),
+	DEFAULT PARTITION other_log_ids
+);
+
+insert into test_split_part (log_id , f_array) select id, '{10}' from generate_series(1,1000)
id;
+
+ALTER TABLE test_split_part SPLIT DEFAULT PARTITION START (201) INCLUSIVE END (301) EXCLUSIVE
INTO (PARTITION "new", DEFAULT PARTITION);
+


Mime
View raw message