打开过滤器缺失的整理支持
作者: antekresic创建于 2026年9月11日更新于 2026年9月11日
标签llm-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;内容来源: timescale/timescaledb