hypopg/test/sql/hypo_brin.sql

-- Hypothetical BRIN index tests

CREATE TABLE hypo_brin (id integer);

INSERT INTO hypo_brin SELECT generate_series(1, 10000);

ANALYZE hypo_brin;

SELECT COUNT(*) AS nb
FROM public.hypopg_create_index('CREATE INDEX ON hypo_brin USING brin (id);');


-- Should use hypothetical index
SET enable_seqscan = 0;
SELECT COUNT(*) FROM do_explain('SELECT * FROM hypo_brin WHERE id = 1') e
WHERE e ~ 'Bitmap Index Scan.*<\d+>brin_hypo_brin.*';

DROP TABLE hypo_brin;