--- a/server/test/unittest_rql2sql.py	Tue Jan 06 12:53:47 2009 -0800
+++ b/server/test/unittest_rql2sql.py	Wed Jan 07 09:47:56 2009 +0100
@@ -745,6 +745,14 @@
 FROM EProperty AS P
 WHERE P.for_user IS NULL'''),
 
+    ('Any S WHERE NOT X in_state S, X is IN(Affaire, EUser)',
+     '''SELECT 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
+FROM EUser AS X, State AS S
+WHERE (X.in_state IS NULL OR X.in_state!=S.eid)'''),
     ]
 
 OUTER_JOIN = [