Collation support for bloom filtering missing
Author: antekresicCreated Sep 11, 2026Updated Sep 11, 2026
Labelsllm-fuzzer
CREATE COLLATION IF NOT EXISTS ci_repro (provider = icu, locale = 'und@colStrength=secondary', deterministic = false);
DROP TABLE IF EXISTS t CASCADE;
CREATE TABLE t (ts timestamptz NOT NULL, label text COLLATE ci_repro, c int)
WITH (tsdb.hypertable = :hyper,
tsdb.compress_orderby = 'ts',
tsdb.compress_segmentby = '',
tsdb.compress_index = 'bloom(label)');
CREATE UNIQUE INDEX t_u ON t (label, ts);
INSERT INTO t VALUES ('2024-01-01 01:00', 'abc', 10);
INSERT INTO t VALUES ('2024-01-01 02:00', 'def', 20);
DO $$ BEGIN PERFORM compress_chunk(c) FROM show_chunks('t') c; EXCEPTION WHEN OTHERS THEN NULL; END $$;
INSERT INTO t VALUES ('2024-01-01 01:00', 'ABC', 999) ON CONFLICT (label, ts) DO NOTHING;
SELECT label, c FROM t ORDER BY ts, label COLLATE "C";
DROP TABLE t CASCADE;https://github.com/timescale/timescaledb/actions/runs/34598193718/attempts/1#summary-103258856471
Source: timescale/timescaledb