Files
multica/server/migrations/183_chat_draft_restore_index.up.sql
YYClaw 9eddcaff10 fix(chat): defer cancellation-time finalization until the task transcript is stable (#5246)
A quick Stop before the agent's first token no longer races a late reply. Started-but-empty cancellations defer the empty/non-empty judgment until the daemon acks its transcript flush (or a grace-period sweeper fires), then settle to a single outcome. Empty outcomes persist a durable, creator-authorized draft restore (fetched/consumed via a dedicated endpoint, reconnect-safe and at-most-once) instead of broadcasting the prompt over the workspace bus.

Closes #5219
2026-07-15 00:52:27 +08:00

10 lines
552 B
SQL

-- Lookup index for chat_draft_restore.chat_session_id: the creator-authorized
-- read (ListChatDraftRestoresBySession) and the DeleteChatSession / workspace /
-- runtime cascade-path prunes all filter by chat_session_id.
--
-- Single-statement migration: CREATE INDEX CONCURRENTLY cannot run inside a
-- transaction or a multi-command string. Split from the table in migration 182
-- so every production index build runs CONCURRENTLY.
CREATE INDEX CONCURRENTLY IF NOT EXISTS idx_chat_draft_restore_session
ON chat_draft_restore (chat_session_id);