From 370361330aeb37f02e87ab78ae38521da774c957 Mon Sep 17 00:00:00 2001 From: Frederic Guillot Date: Thu, 1 Oct 2015 09:46:34 -0400 Subject: Fix Postgres issue "Cardinality violation" when there is multiple "is_milestone_of" links --- app/Model/TaskFinder.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'app/Model') diff --git a/app/Model/TaskFinder.php b/app/Model/TaskFinder.php index e9735d81..9e76e62e 100644 --- a/app/Model/TaskFinder.php +++ b/app/Model/TaskFinder.php @@ -93,7 +93,7 @@ class TaskFinder extends Base '(SELECT count(*) FROM '.Subtask::TABLE.' WHERE '.Subtask::TABLE.'.task_id=tasks.id) AS nb_subtasks', '(SELECT count(*) FROM '.Subtask::TABLE.' WHERE '.Subtask::TABLE.'.task_id=tasks.id AND status=2) AS nb_completed_subtasks', '(SELECT count(*) FROM '.TaskLink::TABLE.' WHERE '.TaskLink::TABLE.'.task_id = tasks.id) AS nb_links', - '(SELECT 1 FROM '.TaskLink::TABLE.' WHERE '.TaskLink::TABLE.'.task_id = tasks.id AND '.TaskLink::TABLE.'.link_id = 9) AS is_milestone', + '(SELECT DISTINCT 1 FROM '.TaskLink::TABLE.' WHERE '.TaskLink::TABLE.'.task_id = tasks.id AND '.TaskLink::TABLE.'.link_id = 9) AS is_milestone', 'tasks.id', 'tasks.reference', 'tasks.title', -- cgit v1.2.3