Commita49d0b7

committed

Create index on srt table in citext regression tests.

Comments and the tests make clear that the intent is to test withand without an index, but there was no index.

1 parentf0e8693 commita49d0b7Copy full SHA for a49d0b7

File tree

-0

lines changed

-0

lines changed

Lines changed: 1 addition & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -325,6 +325,7 @@ VALUES ('aardvark'),`
`325`	`325`	`('aba'),`
`326`	`326`	`('ABC'),`
`327`	`327`	`('abd');`
	`328`	`+CREATE INDEX srt_name ON srt (name);`
`328`	`329`	`-- Check the min() and max() aggregates, with and without index.`
`329`	`330`	`set enable_seqscan = off;`
`330`	`331`	`SELECT MIN(name) AS "AAA" FROM srt;`

Lines changed: 1 addition & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -325,6 +325,7 @@ VALUES ('aardvark'),`
`325`	`325`	`('aba'),`
`326`	`326`	`('ABC'),`
`327`	`327`	`('abd');`
	`328`	`+CREATE INDEX srt_name ON srt (name);`
`328`	`329`	`-- Check the min() and max() aggregates, with and without index.`
`329`	`330`	`set enable_seqscan = off;`
`330`	`331`	`SELECT MIN(name) AS "AAA" FROM srt;`

Lines changed: 2 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -127,6 +127,8 @@ VALUES ('aardvark'),`
`127`	`127`	`('ABC'),`
`128`	`128`	`('abd');`
`129`	`129`
	`130`	`+CREATEINDEXsrt_nameON srt (name);`
	`131`	`+`
`130`	`132`	`-- Check the min() and max() aggregates, with and without index.`
`131`	`133`	`set enable_seqscan= off;`
`132`	`134`	`SELECTMIN(name)AS"AAA"FROM srt;`

Comments

(0)