diff -r 1dcc52f5e340 -r a1e8dbb7215b server/test/unittest_rql2sql.py --- a/server/test/unittest_rql2sql.py Thu Jun 25 22:12:49 2015 +0200 +++ b/server/test/unittest_rql2sql.py Thu Jun 18 18:26:02 2015 +0200 @@ -563,6 +563,17 @@ '''SELECT _X.cw_eid FROM cw_Note AS _X 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))'''), + + # Test for https://www.cubicweb.org/ticket/5503548 + ('''Any X + WHERE X is CWSourceSchemaConfig, + EXISTS(X created_by U, U login L), + X cw_schema X_CW_SCHEMA, + X owned_by X_OWNED_BY? + ''', '''SELECT _X.cw_eid +FROM cw_CWSourceSchemaConfig AS _X LEFT OUTER JOIN owned_by_relation AS rel_owned_by1 ON (rel_owned_by1.eid_from=_X.cw_eid) +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 +''') ] ADVANCED_WITH_GROUP_CONCAT = [