server/test/unittest_rql2sql.py
branchstable
changeset 7902 2ada3052e626
parent 7734 59fea81647e5
child 7904 f41bb38dda7c
--- a/server/test/unittest_rql2sql.py	Fri Sep 30 18:08:00 2011 +0200
+++ b/server/test/unittest_rql2sql.py	Tue Oct 04 10:15:45 2011 +0200
@@ -1524,6 +1524,12 @@
 FROM (SELECT MAX(_A.cw_ordernum) AS C0
 FROM cw_CWAttribute AS _A) AS _T0, cw_CWAttribute AS _A
 WHERE _A.cw_ordernum=_T0.C0'''),
+
+            ('Any O1 HAVING O1=O2? WITH O1 BEING (Any MAX(O) WHERE A ordernum O, A is CWAttribute), O2 BEING (Any MAX(O) WHERE A ordernum O, A is CWRelation)',
+             '''SELECT _T0.C0
+FROM (SELECT MAX(_A.cw_ordernum) AS C0
+FROM cw_CWAttribute AS _A) AS _T0 LEFT OUTER JOIN (SELECT MAX(_A.cw_ordernum) AS C0
+FROM cw_CWRelation AS _A) AS _T1 ON (_T0.C0=_T1.C0)'''),
             )):
             yield t