X-Git-Url: http://git.onelab.eu/?a=blobdiff_plain;f=PLC%2FLeaseFilter.py;h=de340ea4333161ea822441834894fe305cee59dd;hb=1b1b5a911bb005644baabb87ecba60602228a070;hp=4ed6c01e624c9fc8cb6ec23aea3c4ccd370f2cdf;hpb=e19d139e92992e447eab408903a9c49a81ad9b06;p=plcapi.git

diff --git a/PLC/LeaseFilter.py b/PLC/LeaseFilter.py
index 4ed6c01..de340ea 100644
--- a/PLC/LeaseFilter.py
+++ b/PLC/LeaseFilter.py
@@ -64,10 +64,10 @@ class LeaseFilter(Filter):
     # basic SQL utilities
     @staticmethod
     def sql_time_intersect(f1, u1, f2, u2):
-        # either f2 is in [f1,u1], or u2 is in [f1,u1], or f2<=f1<=u1<=u2
+        # either f2 is in [f1,u1[, or u2 is in ]f1,u1], or f2<=f1<u1<=u2
         return (
-            f"(({f1} <= {f2}) AND ({f2} <= {u1})) "
-            f"OR (({f1} <= {u2}) AND ({u2} <= {u1})) "
+            f"(({f1} <= {f2}) AND ({f2} < {u1})) "
+            f"OR (({f1} < {u2}) AND ({u2} <= {u1})) "
             f"OR (({f2}<={f1}) AND ({u1}<={u2}))")
 
     @staticmethod