equal
deleted
inserted
replaced
743 ('Any K,V WHERE P is EProperty, P pkey K, P value V, NOT P for_user U', |
743 ('Any K,V WHERE P is EProperty, P pkey K, P value V, NOT P for_user U', |
744 '''SELECT DISTINCT P.pkey, P.value |
744 '''SELECT DISTINCT P.pkey, P.value |
745 FROM EProperty AS P |
745 FROM EProperty AS P |
746 WHERE P.for_user IS NULL'''), |
746 WHERE P.for_user IS NULL'''), |
747 |
747 |
|
748 ('Any S WHERE NOT X in_state S, X is IN(Affaire, EUser)', |
|
749 '''SELECT S.eid |
|
750 FROM Affaire AS X, State AS S |
|
751 WHERE (X.in_state IS NULL OR X.in_state!=S.eid) |
|
752 INTERSECT |
|
753 SELECT S.eid |
|
754 FROM EUser AS X, State AS S |
|
755 WHERE (X.in_state IS NULL OR X.in_state!=S.eid)'''), |
748 ] |
756 ] |
749 |
757 |
750 OUTER_JOIN = [ |
758 OUTER_JOIN = [ |
751 ('Any X,S WHERE X travaille S?', |
759 ('Any X,S WHERE X travaille S?', |
752 '''SELECT X.eid, rel_travaille0.eid_to |
760 '''SELECT X.eid, rel_travaille0.eid_to |