591 FROM cw_Note AS _X |
591 FROM cw_Note AS _X |
592 WHERE _X.cw_eid IN(999998, 999999) AND NOT (EXISTS(SELECT 1 FROM cw_source_relation AS rel_cw_source0 WHERE rel_cw_source0.eid_from=_X.cw_eid))'''), |
592 WHERE _X.cw_eid IN(999998, 999999) AND NOT (EXISTS(SELECT 1 FROM cw_source_relation AS rel_cw_source0 WHERE rel_cw_source0.eid_from=_X.cw_eid))'''), |
593 |
593 |
594 # Test for https://www.cubicweb.org/ticket/5503548 |
594 # Test for https://www.cubicweb.org/ticket/5503548 |
595 ('''Any X |
595 ('''Any X |
596 WHERE X is CWSourceSchemaConfig, |
596 WHERE X is Card, |
597 EXISTS(X created_by U, U login L), |
597 EXISTS(X created_by U, U login L), |
598 X cw_schema X_CW_SCHEMA, |
598 X multisource_inlined_rel X_CW_SCHEMA, |
599 X owned_by X_OWNED_BY? |
599 X owned_by X_OWNED_BY? |
600 ''', '''SELECT _X.cw_eid |
600 ''', '''SELECT _X.cw_eid |
601 FROM cw_CWSourceSchemaConfig AS _X LEFT OUTER JOIN owned_by_relation AS rel_owned_by1 ON (rel_owned_by1.eid_from=_X.cw_eid) |
601 FROM cw_Card AS _X LEFT OUTER JOIN owned_by_relation AS rel_owned_by1 ON (rel_owned_by1.eid_from=_X.cw_eid) |
602 WHERE EXISTS(SELECT 1 FROM created_by_relation AS rel_created_by0, cw_CWUser AS _U WHERE rel_created_by0.eid_from=_X.cw_eid AND rel_created_by0.eid_to=_U.cw_eid) AND _X.cw_cw_schema IS NOT NULL |
602 WHERE EXISTS(SELECT 1 FROM created_by_relation AS rel_created_by0, cw_CWUser AS _U WHERE rel_created_by0.eid_from=_X.cw_eid AND rel_created_by0.eid_to=_U.cw_eid) AND _X.cw_multisource_inlined_rel IS NOT NULL |
603 '''), |
603 '''), |
604 |
604 |
605 ('Any X WHERE EXISTS(X in_state S, S name "state name"), X is in (Affaire, Note)', |
605 ('Any X WHERE EXISTS(X in_state S, S name "state name"), X is in (Affaire, Note)', |
606 '''SELECT _X.cw_eid |
606 '''SELECT _X.cw_eid |
607 FROM cw_Affaire AS _X |
607 FROM cw_Affaire AS _X |