equal
deleted
inserted
replaced
1029 FROM cw_Note AS _S |
1029 FROM cw_Note AS _S |
1030 WHERE _S.cw_eid=0 AND _S.cw_in_state IS NOT NULL'''), |
1030 WHERE _S.cw_eid=0 AND _S.cw_in_state IS NOT NULL'''), |
1031 |
1031 |
1032 ('Any X WHERE NOT Y for_user X, X eid 123', |
1032 ('Any X WHERE NOT Y for_user X, X eid 123', |
1033 '''SELECT 123 |
1033 '''SELECT 123 |
1034 WHERE NOT (EXISTS(SELECT 1 FROM cw_CWProperty AS _Y WHERE _Y.cw_for_user=123)) |
1034 WHERE NOT (EXISTS(SELECT 1 FROM cw_CWProperty AS _Y WHERE _Y.cw_for_user=123))'''), |
1035 '''), |
1035 |
1036 |
1036 ('DISTINCT Any X WHERE X from_entity OET, NOT X from_entity NET, OET name "Image", NET eid 1', |
|
1037 '''SELECT DISTINCT _X.cw_eid |
|
1038 FROM cw_CWAttribute AS _X, cw_CWEType AS _OET |
|
1039 WHERE _X.cw_from_entity=_OET.cw_eid AND NOT (_X.cw_from_entity=1) AND _OET.cw_name=Image |
|
1040 UNION |
|
1041 SELECT DISTINCT _X.cw_eid |
|
1042 FROM cw_CWEType AS _OET, cw_CWRelation AS _X |
|
1043 WHERE _X.cw_from_entity=_OET.cw_eid AND NOT (_X.cw_from_entity=1) AND _OET.cw_name=Image'''), |
1037 ] |
1044 ] |
1038 |
1045 |
1039 INTERSECT = [ |
1046 INTERSECT = [ |
1040 ('Any SN WHERE NOT X in_state S, S name SN', |
1047 ('Any SN WHERE NOT X in_state S, S name SN', |
1041 '''SELECT _S.cw_name |
1048 '''SELECT _S.cw_name |