mirror of
https://gh-proxy.org/https://github.com/klinsmaya/multica.git
synced 2026-11-08 09:26:50 +08:00
ac131c55cb
A member reply merged into a still-queued task moves trigger_comment_id to the reply and leaves the thread root only in coalesced_comment_ids. ListConversationRootOwners matched the root against trigger_comment_id alone, so the thread lost its owner and later un-mentioned replies under the root were silently dropped. Treat a root in coalesced_comment_ids as owned, the same coverage rule taskCoversReplyParent and CancelAgentTasksByTriggerComment already use. Co-authored-by: Cursor <[email protected]> Co-authored-by: multica-agent <[email protected]>
18 lines
961 B
SQL
18 lines
961 B
SQL
-- name: ListConversationRootOwners :many
|
|
-- Preserve the newest non-null squad per agent, including terminal tasks.
|
|
-- A root folded into a queued task keeps its owner after the merge repoints
|
|
-- trigger_comment_id at the newer comment and moves the root into
|
|
-- coalesced_comment_ids (MUL-8416).
|
|
-- A delivered supplement establishes ownership even when the root did not
|
|
-- start a separate task. Pending or failed delivery does not establish it.
|
|
-- Routing does not need execution context, results, or other issue threads.
|
|
SELECT DISTINCT ON (agent_id) agent_id, squad_id
|
|
FROM agent_task_queue t
|
|
WHERE t.issue_id = $1 AND t.agent_id IS NOT NULL
|
|
AND (t.trigger_comment_id = $2 OR $2 = ANY(t.coalesced_comment_ids) OR EXISTS (
|
|
SELECT 1 FROM task_supplement s
|
|
WHERE s.task_id = t.id AND s.issue_id = t.issue_id
|
|
AND s.comment_id = $2 AND s.status = 'delivered'
|
|
))
|
|
ORDER BY agent_id, (squad_id IS NOT NULL) DESC, created_at DESC, id DESC;
|