Fix treatments views on cyclic treatments (should not happen but...)

1 files changed, 4 insertions, 0 deletions

diff --git a/archaeological_finds/models_treatments.py b/archaeological_finds/models_treatments.py
index 5054d0da1..945ff57d4 100644
--- a/archaeological_finds/models_treatments.py
+++ b/archaeological_finds/models_treatments.py
@@ -318,6 +318,8 @@ class FindUpstreamTreatments(AbsFindTreatments):
             FROM archaeological_finds_find c
           JOIN rel_tree p
             ON c.upstream_treatment_id = p.downstream_treatment_id
+              AND  c.upstream_treatment_id !=
+                ALL(p.path_info[0:cardinality(p.path_info)-1])
         )
         SELECT DISTINCT find_id, path_info, level
           FROM rel_tree ORDER BY find_id;
@@ -370,6 +372,8 @@ class FindDownstreamTreatments(AbsFindTreatments):
             FROM archaeological_finds_find c
           JOIN rel_tree p
             ON c.downstream_treatment_id = p.upstream_treatment_id
+              AND  c.downstream_treatment_id !=
+                ALL(p.path_info[0:cardinality(p.path_info)-1])
         )
         SELECT DISTINCT find_id, path_info, level
           FROM rel_tree ORDER BY find_id;