diff -r 5c9e94a09e97 -r 64eee2a83bfa server/test/unittest_rql2sql.py --- a/server/test/unittest_rql2sql.py Mon Jul 11 09:15:54 2011 +0200 +++ b/server/test/unittest_rql2sql.py Mon Jul 11 09:21:44 2011 +0200 @@ -958,6 +958,12 @@ '''SELECT rel_tags0.eid_from, rel_tags0.eid_to, rel_tags1.eid_from FROM tags_relation AS rel_tags0 LEFT OUTER JOIN tags_relation AS rel_tags1 ON (rel_tags1.eid_to=123) WHERE rel_tags0.eid_from=123'''), + + ('Any CASE, CALIBCFG, CFG ' + 'WHERE CASE eid 1, CFG ecrit_par CASE, CALIBCFG? ecrit_par CASE', + '''SELECT _CFG.cw_ecrit_par, _CALIBCFG.cw_eid, _CFG.cw_eid +FROM cw_Note AS _CFG LEFT OUTER JOIN cw_Note AS _CALIBCFG ON (_CALIBCFG.cw_ecrit_par=_CFG.cw_ecrit_par) +WHERE _CFG.cw_ecrit_par=1'''), ] VIRTUAL_VARS = [