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