summaryrefslogtreecommitdiff
path: root/contrib/citext
diff options
context:
space:
mode:
authorKevin Grittner2013-09-11 21:53:23 +0000
committerKevin Grittner2013-09-11 21:53:23 +0000
commita49d0b75ce41a5480777f0957d5119cb2f393414 (patch)
treeb1098a8db2c5949e2cbb1785dd52dafc43d2a46d /contrib/citext
parentf0e86930dd56f2da00101d5384cbb51ada3730da (diff)
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.
Diffstat (limited to 'contrib/citext')
-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;