aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorKevin Grittner <kgrittn@postgresql.org>2013-09-11 16:53:23 -0500
committerKevin Grittner <kgrittn@postgresql.org>2013-09-11 16:53:23 -0500
commita49d0b75ce41a5480777f0957d5119cb2f393414 (patch)
treeb1098a8db2c5949e2cbb1785dd52dafc43d2a46d
parentf0e86930dd56f2da00101d5384cbb51ada3730da (diff)
downloadpostgresql-a49d0b75ce41a5480777f0957d5119cb2f393414.tar.gz
postgresql-a49d0b75ce41a5480777f0957d5119cb2f393414.zip
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.
-rw-r--r--contrib/citext/expected/citext.out1
-rw-r--r--contrib/citext/expected/citext_1.out1
-rw-r--r--contrib/citext/sql/citext.sql2
3 files changed, 4 insertions, 0 deletions
diff --git a/contrib/citext/expected/citext.out b/contrib/citext/expected/citext.out
index 000c9256422..a6265d857dc 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 8373dc88469..36342be7c1d 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 07497401a4d..65ef05b9312 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;