--- a/server/test/unittest_rql2sql.py	Wed Jan 07 09:47:56 2009 +0100
+++ b/server/test/unittest_rql2sql.py	Wed Jan 07 14:55:16 2009 +0100
@@ -746,11 +746,11 @@
 WHERE P.for_user IS NULL'''),
 
     ('Any S WHERE NOT X in_state S, X is IN(Affaire, EUser)',
-     '''SELECT S.eid
+     '''SELECT DISTINCT S.eid
 FROM Affaire AS X, State AS S
 WHERE (X.in_state IS NULL OR X.in_state!=S.eid)
 INTERSECT
-SELECT S.eid
+SELECT DISTINCT S.eid
 FROM EUser AS X, State AS S
 WHERE (X.in_state IS NULL OR X.in_state!=S.eid)'''),
     ]