REGRESS += array

REGRESS := security tmp$(filter-out security rum rum_hash orderby orderby_hash text array,$(REGRESS))

ifeq ($(MAJORVERSION),$(filter 9.6% 10% 11%,$(MAJORVERSION)))

wal-check: temp-install

CREATE EXTENSION rum;

CREATE TABLE test_rum( t text, a tsvector );

CREATE TRIGGER tsvectorupdate

BEFORE UPDATE OR INSERT ON test_rum

FOR EACH ROW EXECUTE PROCEDURE tsvector_update_trigger('a', 'pg_catalog.english', 't');

CREATE INDEX rumidx ON test_rum USING rum (a rum_tsvector_ops);

-- Check empty table using index scan

SELECT

a <=> to_tsquery('pg_catalog.english', 'way & (go | half)'),

rum_ts_distance(a, to_tsquery('pg_catalog.english', 'way & (go | half)')),

rum_ts_score(a, to_tsquery('pg_catalog.english', 'way & (go | half)')),

*

FROM test_rum

ORDER BY a <=> to_tsquery('pg_catalog.english', 'way & (go | half)') limit 2;

?column? | rum_ts_distance | rum_ts_score | t | a

----------+-----------------+--------------+---+---

(0 rows)

-- Fill the table with data

\copy test_rum(t) from 'data/rum.data';

CREATE INDEX failed_rumidx ON test_rum USING rum (a rum_tsvector_addon_ops);

ERROR: additional information attribute "a" is not found in index

CREATE TABLE tsts (id int, t tsvector, d timestamp);

\copy tsts from 'data/tsts.data'

CREATE INDEX tsts_idx ON tsts USING rum (t rum_tsvector_addon_ops, d)

WITH (attach = 'd', to = 't');

INSERT INTO tsts VALUES (-1, 't1 t2', '2016-05-02 02:24:22.326724');

INSERT INTO tsts VALUES (-2, 't1 t2 t3', '2016-05-02 02:26:22.326724');

INSERT INTO test_rum (t) VALUES ('foo bar foo the over foo qq bar');

INSERT INTO test_rum (t) VALUES ('345 qwerty copyright');

INSERT INTO test_rum (t) VALUES ('345 qwerty');

INSERT INTO test_rum (t) VALUES ('A fat cat has just eaten a rat.');

SET enable_seqscan=off;

SET enable_indexscan=off;

CREATE EXTENSION rum;

CREATETABLEtest_rum( ttext, a tsvector );

BEFOREUPDATEOR INSERTON test_rum

FOR EACH ROW EXECUTE PROCEDURE tsvector_update_trigger('a','pg_catalog.english','t');

CREATEINDEXrumidxON test_rum USING rum (a rum_tsvector_ops);

a<=> to_tsquery('pg_catalog.english','way & (go | half)'),

rum_ts_distance(a, to_tsquery('pg_catalog.english','way & (go | half)')),

rum_ts_score(a, to_tsquery('pg_catalog.english','way & (go | half)')),

FROM test_rum

ORDER BY a<=> to_tsquery('pg_catalog.english','way & (go | half)')limit2;

\copy test_rum(t)from'data/rum.data';

CREATEINDEXfailed_rumidxON test_rum USING rum (a rum_tsvector_addon_ops);

CREATETABLEtsts (idint, t tsvector, dtimestamp);

\copy tstsfrom'data/tsts.data'

CREATEINDEXtsts_idxON tsts USING rum (t rum_tsvector_addon_ops, d)

WITH (attach='d', to='t');

INSERT INTO tstsVALUES (-1,'t1 t2','2016-05-02 02:24:22.326724');

INSERT INTO tstsVALUES (-2,'t1 t2 t3','2016-05-02 02:26:22.326724');

INSERT INTO test_rum (t)VALUES ('foo bar foo the over foo qq bar');

INSERT INTO test_rum (t)VALUES ('345 qwerty copyright');

INSERT INTO test_rum (t)VALUES ('345 qwerty');

INSERT INTO test_rum (t)VALUES ('A fat cat has just eaten a rat.');

SET enable_seqscan=off;

SET enable_indexscan=off;