"Some tests to cover hash_index"

diff --git a/src/test/regress/expected/concurrent_hash_index.out b/src/test/regress/expected/concurrent_hash_index.out
index c3b8036..60191c0 100644
--- a/src/test/regress/expected/concurrent_hash_index.out
+++ b/src/test/regress/expected/concurrent_hash_index.out
@@ -3,7 +3,6 @@
 --
 CREATE TABLE con_hash_index_table (keycol INT);
 CREATE INDEX con_hash_index on con_hash_index_table USING HASH (keycol);
-WARNING:  hash indexes are not WAL-logged and their use is discouraged
 INSERT INTO con_hash_index_table VALUES (1);
 INSERT INTO con_hash_index_table SELECT * from con_hash_index_table;
 INSERT INTO con_hash_index_table SELECT * from con_hash_index_table;
@@ -75,5 +74,15 @@ DROP TABLE hash_ovfl_temp_heap CASCADE;
 CREATE TABLE hash_ovfl_heap_float4 (x float4, y int);
 INSERT INTO hash_ovfl_heap_float4 VALUES (1.1,1);
 CREATE INDEX hash_idx ON hash_ovfl_heap_float4 USING hash (x);
-WARNING:  hash indexes are not WAL-logged and their use is discouraged
 DROP TABLE hash_ovfl_heap_float4 CASCADE;
+--
+-- Test hash index insertion with squeeze bucket (XLOG_HASH_MOVE_PAGE_CONTENTS
+-- WAL record type).
+--
+CREATE TABLE hash_split_buckets (seqno int4, random int4);
+CREATE INDEX hash_idx ON hash_split_buckets USING hash (random int4_ops)
+with (fillfactor = 10);
+INSERT INTO hash_split_buckets (seqno, random) SELECT a, a*5 FROM
+GENERATE_SERIES(1, 100000) a;
+REINDEX INDEX hash_idx;
+DROP TABLE hash_split_buckets;
diff --git a/src/test/regress/sql/concurrent_hash_index.sql b/src/test/regress/sql/concurrent_hash_index.sql
index 8f930d5..d3b09d0 100644
--- a/src/test/regress/sql/concurrent_hash_index.sql
+++ b/src/test/regress/sql/concurrent_hash_index.sql
@@ -78,3 +78,15 @@ CREATE TABLE hash_ovfl_heap_float4 (x float4, y int);
 INSERT INTO hash_ovfl_heap_float4 VALUES (1.1,1);
 CREATE INDEX hash_idx ON hash_ovfl_heap_float4 USING hash (x);
 DROP TABLE hash_ovfl_heap_float4 CASCADE;
+
+--
+-- Test hash index insertion with squeeze bucket (XLOG_HASH_MOVE_PAGE_CONTENTS
+-- WAL record type).
+--
+CREATE TABLE hash_split_buckets (seqno int4, random int4);
+CREATE INDEX hash_idx ON hash_split_buckets USING hash (random int4_ops)
+with (fillfactor = 10);
+INSERT INTO hash_split_buckets (seqno, random) SELECT a, a*5 FROM
+GENERATE_SERIES(1, 100000) a;
+REINDEX INDEX hash_idx;
+DROP TABLE hash_split_buckets;

commit 5df7e726d1b78ac4f5be3bcc0a6e25cd05a3d26e
Author: mithun <mithun@localhost.localdomain>
Date:   Mon Sep 19 14:03:26 2016 +0530

    commit-1

diff --git a/src/test/regress/expected/hash_index_split.out b/src/test/regress/expected/hash_index_split.out
new file mode 100644
index 0000000..f3d25d1
--- /dev/null
+++ b/src/test/regress/expected/hash_index_split.out
@@ -0,0 +1,79 @@
+-- 
+-- Cause some overflow insert and splits.
+--
+CREATE TABLE hash_split_heap (keycol INT);
+CREATE INDEX hash_split_index on hash_split_heap USING HASH (keycol);
+WARNING:  hash indexes are not WAL-logged and their use is discouraged
+INSERT INTO hash_split_heap VALUES (1);
+INSERT INTO hash_split_heap SELECT * from hash_split_heap;
+INSERT INTO hash_split_heap SELECT * from hash_split_heap;
+INSERT INTO hash_split_heap SELECT * from hash_split_heap;
+INSERT INTO hash_split_heap SELECT * from hash_split_heap;
+INSERT INTO hash_split_heap SELECT * from hash_split_heap;
+INSERT INTO hash_split_heap SELECT * from hash_split_heap;
+INSERT INTO hash_split_heap SELECT * from hash_split_heap;
+INSERT INTO hash_split_heap SELECT * from hash_split_heap;
+INSERT INTO hash_split_heap SELECT * from hash_split_heap;
+INSERT INTO hash_split_heap SELECT * from hash_split_heap;
+INSERT INTO hash_split_heap SELECT * from hash_split_heap;
+INSERT INTO hash_split_heap SELECT * from hash_split_heap;
+INSERT INTO hash_split_heap SELECT * from hash_split_heap;
+INSERT INTO hash_split_heap SELECT * from hash_split_heap;
+INSERT INTO hash_split_heap SELECT * from hash_split_heap;
+INSERT INTO hash_split_heap SELECT * from hash_split_heap;
+INSERT INTO hash_split_heap SELECT * from hash_split_heap LIMIT 32000;
+VACUUM FULL hash_split_heap;
+--
+-- Lets do a backward scan.
+--
+BEGIN;
+SET enable_seqscan = OFF;
+SET enable_bitmapscan = OFF;
+CREATE FUNCTION declares_cursor(int)
+   RETURNS void
+   AS 'DECLARE c CURSOR FOR SELECT * from hash_split_heap WHERE keycol = $1;'
+LANGUAGE SQL;
+SELECT declares_cursor(1);
+ declares_cursor 
+-----------------
+ 
+(1 row)
+
+MOVE FORWARD ALL FROM c;
+MOVE BACKWARD 10000 FROM c;
+MOVE BACKWARD ALL FROM c;
+ROLLBACK;
+--
+-- DELETE, INSERT, REBUILD INDEX.
+--
+DELETE FROM hash_split_heap WHERE keycol = 1;
+INSERT INTO hash_split_heap VALUES (1), (2);
+INSERT INTO hash_split_heap SELECT * from hash_split_heap;
+INSERT INTO hash_split_heap SELECT * from hash_split_heap;
+INSERT INTO hash_split_heap SELECT * from hash_split_heap;
+INSERT INTO hash_split_heap SELECT * from hash_split_heap;
+INSERT INTO hash_split_heap SELECT * from hash_split_heap;
+INSERT INTO hash_split_heap SELECT * from hash_split_heap;
+INSERT INTO hash_split_heap SELECT * from hash_split_heap;
+INSERT INTO hash_split_heap SELECT * from hash_split_heap;
+VACUUM  hash_split_heap;
+REINDEX INDEX hash_split_index;
+--
+-- Clean Up.
+--
+DROP TABLE hash_split_heap;
+--
+-- INDEX ON TEMP TABLE.
+--
+CREATE TEMP TABLE hash_temp_heap (x int, y int);
+INSERT INTO hash_temp_heap VALUES (1,1);
+CREATE INDEX hash_idx ON hash_temp_heap USING hash (x);
+DROP TABLE hash_temp_heap CASCADE;
+--
+-- Float4 type.
+--
+CREATE TABLE hash_heap_float4 (x float4, y int);
+INSERT INTO hash_heap_float4 VALUES (1.1,1);
+CREATE INDEX hash_idx ON hash_heap_float4 USING hash (x);
+WARNING:  hash indexes are not WAL-logged and their use is discouraged
+DROP TABLE hash_heap_float4 CASCADE;
diff --git a/src/test/regress/parallel_schedule b/src/test/regress/parallel_schedule
index 1cb5dfc..ada6d12 100644
--- a/src/test/regress/parallel_schedule
+++ b/src/test/regress/parallel_schedule
@@ -79,7 +79,7 @@ ignore: random
 # ----------
 # Another group of parallel tests
 # ----------
-test: select_into select_distinct select_distinct_on select_implicit select_having subselect union case join aggregates transactions random portals arrays btree_index hash_index update namespace prepared_xacts delete
+test: select_into select_distinct select_distinct_on select_implicit select_having subselect union case join aggregates transactions random portals arrays btree_index hash_index hash_index_split update namespace prepared_xacts delete
 
 # ----------
 # Another group of parallel tests
diff --git a/src/test/regress/serial_schedule b/src/test/regress/serial_schedule
index 8958d8c..37add6b 100644
--- a/src/test/regress/serial_schedule
+++ b/src/test/regress/serial_schedule
@@ -96,6 +96,7 @@ test: portals
 test: arrays
 test: btree_index
 test: hash_index
+test: hash_index_split
 test: update
 test: delete
 test: namespace
diff --git a/src/test/regress/sql/hash_index_split.sql b/src/test/regress/sql/hash_index_split.sql
new file mode 100644
index 0000000..af36df0
--- /dev/null
+++ b/src/test/regress/sql/hash_index_split.sql
@@ -0,0 +1,80 @@
+--
+-- Cause some overflow insert and splits.
+--
+CREATE TABLE hash_split_heap (keycol INT);
+CREATE INDEX hash_split_index on hash_split_heap USING HASH (keycol);
+INSERT INTO hash_split_heap VALUES (1);
+INSERT INTO hash_split_heap SELECT * from hash_split_heap;
+INSERT INTO hash_split_heap SELECT * from hash_split_heap;
+INSERT INTO hash_split_heap SELECT * from hash_split_heap;
+INSERT INTO hash_split_heap SELECT * from hash_split_heap;
+INSERT INTO hash_split_heap SELECT * from hash_split_heap;
+INSERT INTO hash_split_heap SELECT * from hash_split_heap;
+INSERT INTO hash_split_heap SELECT * from hash_split_heap;
+INSERT INTO hash_split_heap SELECT * from hash_split_heap;
+INSERT INTO hash_split_heap SELECT * from hash_split_heap;
+INSERT INTO hash_split_heap SELECT * from hash_split_heap;
+INSERT INTO hash_split_heap SELECT * from hash_split_heap;
+INSERT INTO hash_split_heap SELECT * from hash_split_heap;
+INSERT INTO hash_split_heap SELECT * from hash_split_heap;
+INSERT INTO hash_split_heap SELECT * from hash_split_heap;
+INSERT INTO hash_split_heap SELECT * from hash_split_heap;
+INSERT INTO hash_split_heap SELECT * from hash_split_heap;
+INSERT INTO hash_split_heap SELECT * from hash_split_heap LIMIT 32000;
+
+VACUUM FULL hash_split_heap;
+
+--
+-- Lets do a backward scan.
+--
+BEGIN;
+SET enable_seqscan = OFF;
+SET enable_bitmapscan = OFF;
+CREATE FUNCTION declares_cursor(int)
+   RETURNS void
+   AS 'DECLARE c CURSOR FOR SELECT * from hash_split_heap WHERE keycol = $1;'
+LANGUAGE SQL;
+
+SELECT declares_cursor(1);
+MOVE FORWARD ALL FROM c;
+MOVE BACKWARD 10000 FROM c;
+MOVE BACKWARD ALL FROM c;
+ROLLBACK;
+
+--
+-- DELETE, INSERT, REBUILD INDEX.
+--
+DELETE FROM hash_split_heap WHERE keycol = 1;
+INSERT INTO hash_split_heap VALUES (1), (2);
+INSERT INTO hash_split_heap SELECT * from hash_split_heap;
+INSERT INTO hash_split_heap SELECT * from hash_split_heap;
+INSERT INTO hash_split_heap SELECT * from hash_split_heap;
+INSERT INTO hash_split_heap SELECT * from hash_split_heap;
+INSERT INTO hash_split_heap SELECT * from hash_split_heap;
+INSERT INTO hash_split_heap SELECT * from hash_split_heap;
+INSERT INTO hash_split_heap SELECT * from hash_split_heap;
+INSERT INTO hash_split_heap SELECT * from hash_split_heap;
+
+VACUUM  hash_split_heap;
+REINDEX INDEX hash_split_index;
+
+--
+-- Clean Up.
+--
+DROP TABLE hash_split_heap;
+
+--
+-- INDEX ON TEMP TABLE.
+--
+CREATE TEMP TABLE hash_temp_heap (x int, y int);
+INSERT INTO hash_temp_heap VALUES (1,1);
+CREATE INDEX hash_idx ON hash_temp_heap USING hash (x);
+DROP TABLE hash_temp_heap CASCADE;
+
+--
+-- Float4 type.
+--
+CREATE TABLE hash_heap_float4 (x float4, y int);
+INSERT INTO hash_heap_float4 VALUES (1.1,1);
+CREATE INDEX hash_idx ON hash_heap_float4 USING hash (x);
+DROP TABLE hash_heap_float4 CASCADE;

diff --git a/src/test/regress/expected/hash_index.out b/src/test/regress/expected/hash_index.out
index 22835f8..a755988 100644
--- a/src/test/regress/expected/hash_index.out
+++ b/src/test/regress/expected/hash_index.out
@@ -196,3 +196,49 @@ SELECT h.seqno AS f20000
 --   WHERE x = 90;
 -- SELECT count(*) AS i988 FROM hash_ovfl_heap
 --  WHERE x = 1000;
+--
+-- Cause some overflow insert and splits.
+--
+CREATE TABLE hash_split_heap (keycol INT);
+CREATE INDEX hash_split_index on hash_split_heap USING HASH (keycol);
+WARNING:  hash indexes are not WAL-logged and their use is discouraged
+INSERT INTO hash_split_heap SELECT 1 FROM generate_series(1, 70000) a;
+VACUUM FULL hash_split_heap;
+--
+-- Lets do a backward scan.
+--
+BEGIN;
+SET enable_seqscan = OFF;
+SET enable_bitmapscan = OFF;
+DECLARE c CURSOR FOR SELECT * from hash_split_heap WHERE keycol = 1;
+MOVE FORWARD ALL FROM c;
+MOVE BACKWARD 10000 FROM c;
+MOVE BACKWARD ALL FROM c;
+CLOSE c;
+END;
+--
+-- DELETE, INSERT, REBUILD INDEX.
+--
+DELETE FROM hash_split_heap WHERE keycol = 1;
+INSERT INTO hash_split_heap SELECT a/2 FROM generate_series(1, 50000) a;
+VACUUM  hash_split_heap;
+REINDEX INDEX hash_split_index;
+--
+-- Clean Up.
+--
+DROP TABLE hash_split_heap;
+--
+-- INDEX ON TEMP TABLE.
+--
+CREATE TEMP TABLE hash_temp_heap (x int, y int);
+INSERT INTO hash_temp_heap VALUES (1,1);
+CREATE INDEX hash_idx ON hash_temp_heap USING hash (x);
+DROP TABLE hash_temp_heap CASCADE;
+--
+-- Float4 type.
+--
+CREATE TABLE hash_heap_float4 (x float4, y int);
+INSERT INTO hash_heap_float4 VALUES (1.1,1);
+CREATE INDEX hash_idx ON hash_heap_float4 USING hash (x);
+WARNING:  hash indexes are not WAL-logged and their use is discouraged
+DROP TABLE hash_heap_float4 CASCADE;
diff --git a/src/test/regress/sql/hash_index.sql b/src/test/regress/sql/hash_index.sql
index 411e8ae..df2b2d4 100644
--- a/src/test/regress/sql/hash_index.sql
+++ b/src/test/regress/sql/hash_index.sql
@@ -151,3 +151,57 @@ SELECT h.seqno AS f20000
 
 -- SELECT count(*) AS i988 FROM hash_ovfl_heap
 --  WHERE x = 1000;
+
+--
+-- Cause some overflow insert and splits.
+--
+CREATE TABLE hash_split_heap (keycol INT);
+CREATE INDEX hash_split_index on hash_split_heap USING HASH (keycol);
+INSERT INTO hash_split_heap SELECT 1 FROM generate_series(1, 70000) a;
+
+VACUUM FULL hash_split_heap;
+
+--
+-- Lets do a backward scan.
+--
+BEGIN;
+SET enable_seqscan = OFF;
+SET enable_bitmapscan = OFF;
+
+DECLARE c CURSOR FOR SELECT * from hash_split_heap WHERE keycol = 1;
+MOVE FORWARD ALL FROM c;
+MOVE BACKWARD 10000 FROM c;
+MOVE BACKWARD ALL FROM c;
+CLOSE c;
+END;
+
+--
+-- DELETE, INSERT, REBUILD INDEX.
+--
+DELETE FROM hash_split_heap WHERE keycol = 1;
+INSERT INTO hash_split_heap SELECT a/2 FROM generate_series(1, 50000) a;
+
+VACUUM  hash_split_heap;
+REINDEX INDEX hash_split_index;
+
+--
+-- Clean Up.
+--
+DROP TABLE hash_split_heap;
+
+--
+-- INDEX ON TEMP TABLE.
+--
+CREATE TEMP TABLE hash_temp_heap (x int, y int);
+INSERT INTO hash_temp_heap VALUES (1,1);
+CREATE INDEX hash_idx ON hash_temp_heap USING hash (x);
+DROP TABLE hash_temp_heap CASCADE;
+
+--
+-- Float4 type.
+--
+CREATE TABLE hash_heap_float4 (x float4, y int);
+INSERT INTO hash_heap_float4 VALUES (1.1,1);
+CREATE INDEX hash_idx ON hash_heap_float4 USING hash (x);
+DROP TABLE hash_heap_float4 CASCADE;
+