-- Ticket11：唯一约束只覆盖开放中的采集器断线区间，关闭区间保留为历史追加记录。
ALTER TABLE t_test_collector_exception_interval
    DROP INDEX uk_collector_exception_open,
    ADD COLUMN open_dedupe_key VARCHAR(320)
        GENERATED ALWAYS AS (
            CASE WHEN interval_status = 'OPEN' THEN
                CONCAT(test_id, ':', battery_relation_id, ':', collector_id, ':',
                       collector_channel_code, ':', exception_type)
            ELSE NULL END
        ) STORED AFTER interval_status,
    ADD UNIQUE KEY uk_collector_exception_open (open_dedupe_key);