mirror of
https://github.com/HypoPG/hypopg
synced 2026-05-23 00:58:25 +00:00
48ed9e4f17
Upstream postgres will probably soon push some changes that will change the semantics of explain_get_index_name_hook_type. The returned index name will automatically be properly quoted if needed, while it was previously the extension's duty to take care of that, which hypopg failed to do. See discussion at https://postgr.es/m/flat/16502-57bd1c9f913ed1d1%40postgresql.org for more details. To avoid build failure when the change is committed, change brin regression test to match an hypothetical index name whether is quoted or not, similarly to how it's done in all other regression tests.
18 lines
460 B
SQL
18 lines
460 B
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;
|