Commitc89451e

committed

extend tests

1 parentf8625ba commitc89451eCopy full SHA for c89451e

File tree

+14

-0

lines changed

+14

-0

lines changed

Lines changed: 11 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -6,6 +6,17 @@ FOR EACH ROW EXECUTE PROCEDURE tsvector_update_trigger('a', 'pg_catalog.english'`
`6`	`6`	`CREATE INDEX rumidx ON test_rum USING rum (a rum_tsvector_ops);`
`7`	`7`	`\copy test_rum(t) from 'data/rum.data';`
`8`	`8`	`SET enable_seqscan=off;`
	`9`	`+explain (costs off)`
	`10`	`+SELECT count(*) FROM test_rum WHERE a @@ to_tsquery('pg_catalog.english', 'ever\|wrote');`
	`11`	`+ QUERY PLAN`
	`12`	`+------------------------------------------------------------------`
	`13`	`+ Aggregate`
	`14`	`+ -> Bitmap Heap Scan on test_rum`
	`15`	`+ Recheck Cond: (a @@ '''ever'' \| ''wrote'''::tsquery)`
	`16`	`+ -> Bitmap Index Scan on rumidx`
	`17`	`+ Index Cond: (a @@ '''ever'' \| ''wrote'''::tsquery)`
	`18`	`+(5 rows)`
	`19`	`+`
`9`	`20`	`SELECT count(*) FROM test_rum WHERE a @@ to_tsquery('pg_catalog.english', 'ever\|wrote');`
`10`	`21`	`count`
`11`	`22`	`-------`

Lines changed: 3 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -12,6 +12,9 @@ CREATE INDEX rumidx ON test_rum USING rum (a rum_tsvector_ops);`
`12`	`12`
`13`	`13`	`SET enable_seqscan=off;`
`14`	`14`
	`15`	`+explain (costs off)`
	`16`	`+SELECTcount(*)FROM test_rumWHERE a @@ to_tsquery('pg_catalog.english','ever\|wrote');`
	`17`	`+`
`15`	`18`	`SELECTcount(*)FROM test_rumWHERE a @@ to_tsquery('pg_catalog.english','ever\|wrote');`
`16`	`19`	`SELECTcount(*)FROM test_rumWHERE a @@ to_tsquery('pg_catalog.english','have&wish');`
`17`	`20`	`SELECTcount(*)FROM test_rumWHERE a @@ to_tsquery('pg_catalog.english','knew&brain');`

Comments

(0)