From 333a544a96e100664e64575be59b89ac9a71e418 Mon Sep 17 00:00:00 2001 From: Pavan Deolasee Date: Fri, 25 Aug 2017 11:39:48 +0530 Subject: [PATCH] Accept errors in hash_index test case We don't support BACKWARD scan of RemoteSubplan and neither support WHERE CURRENT OF. So accept the resulting errors. --- src/test/regress/expected/hash_index.out | 6 ++++++ src/test/regress/sql/hash_index.sql | 2 ++ 2 files changed, 8 insertions(+) diff --git a/src/test/regress/expected/hash_index.out b/src/test/regress/expected/hash_index.out index 0bbaa2a768..3af055a81a 100644 --- a/src/test/regress/expected/hash_index.out +++ b/src/test/regress/expected/hash_index.out @@ -209,9 +209,15 @@ 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; +-- XL does not support backward scan of RemoteSubplan/RemoteSubquery and hence +-- the next statement will fail MOVE BACKWARD 10000 FROM c; +ERROR: cursor can only scan forward +HINT: Declare it with SCROLL option to enable backward scan. MOVE BACKWARD ALL FROM c; +ERROR: current transaction is aborted, commands ignored until end of transaction block CLOSE c; +ERROR: current transaction is aborted, commands ignored until end of transaction block END; -- DELETE, INSERT, VACUUM. DELETE FROM hash_split_heap WHERE keycol = 1; diff --git a/src/test/regress/sql/hash_index.sql b/src/test/regress/sql/hash_index.sql index 9af03d2bc1..08a36098a7 100644 --- a/src/test/regress/sql/hash_index.sql +++ b/src/test/regress/sql/hash_index.sql @@ -167,6 +167,8 @@ SET enable_bitmapscan = OFF; DECLARE c CURSOR FOR SELECT * from hash_split_heap WHERE keycol = 1; MOVE FORWARD ALL FROM c; +-- XL does not support backward scan of RemoteSubplan/RemoteSubquery and hence +-- the next statement will fail MOVE BACKWARD 10000 FROM c; MOVE BACKWARD ALL FROM c; CLOSE c; -- 2.39.5