From a49d0b75ce41a5480777f0957d5119cb2f393414 Mon Sep 17 00:00:00 2001 From: Kevin Grittner Date: Wed, 11 Sep 2013 16:53:23 -0500 Subject: [PATCH] Create index on srt table in citext regression tests. Comments and the tests make clear that the intent is to test with and without an index, but there was no index. --- contrib/citext/expected/citext.out | 1 + contrib/citext/expected/citext_1.out | 1 + contrib/citext/sql/citext.sql | 2 ++ 3 files changed, 4 insertions(+) diff --git a/contrib/citext/expected/citext.out b/contrib/citext/expected/citext.out index 000c925642..a6265d857d 100644 --- a/contrib/citext/expected/citext.out +++ b/contrib/citext/expected/citext.out @@ -325,6 +325,7 @@ VALUES ('aardvark'), ('aba'), ('ABC'), ('abd'); +CREATE INDEX srt_name ON srt (name); -- Check the min() and max() aggregates, with and without index. set enable_seqscan = off; SELECT MIN(name) AS "AAA" FROM srt; diff --git a/contrib/citext/expected/citext_1.out b/contrib/citext/expected/citext_1.out index 8373dc8846..36342be7c1 100644 --- a/contrib/citext/expected/citext_1.out +++ b/contrib/citext/expected/citext_1.out @@ -325,6 +325,7 @@ VALUES ('aardvark'), ('aba'), ('ABC'), ('abd'); +CREATE INDEX srt_name ON srt (name); -- Check the min() and max() aggregates, with and without index. set enable_seqscan = off; SELECT MIN(name) AS "AAA" FROM srt; diff --git a/contrib/citext/sql/citext.sql b/contrib/citext/sql/citext.sql index 07497401a4..65ef05b931 100644 --- a/contrib/citext/sql/citext.sql +++ b/contrib/citext/sql/citext.sql @@ -127,6 +127,8 @@ VALUES ('aardvark'), ('ABC'), ('abd'); +CREATE INDEX srt_name ON srt (name); + -- Check the min() and max() aggregates, with and without index. set enable_seqscan = off; SELECT MIN(name) AS "AAA" FROM srt; -- 2.40.0