diff options
| author | Frederic Guillot <fred@kanboard.net> | 2015-10-01 09:46:34 -0400 |
|---|---|---|
| committer | Frederic Guillot <fred@kanboard.net> | 2015-10-01 09:46:34 -0400 |
| commit | 370361330aeb37f02e87ab78ae38521da774c957 (patch) | |
| tree | dafef9c946d278a9acc99947af6212bb5c25f1c0 /app/Model | |
| parent | 792d5a20bcb4926c91311afced67ddd008c3b79e (diff) | |
Fix Postgres issue "Cardinality violation" when there is multiple "is_milestone_of" links
Diffstat (limited to 'app/Model')
| -rw-r--r-- | app/Model/TaskFinder.php | 2 |
1 files changed, 1 insertions, 1 deletions
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', |