1539 ('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)', |
1539 ('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)', |
1540 '''SELECT _T0.C0 |
1540 '''SELECT _T0.C0 |
1541 FROM (SELECT MAX(_A.cw_ordernum) AS C0 |
1541 FROM (SELECT MAX(_A.cw_ordernum) AS C0 |
1542 FROM cw_CWAttribute AS _A) AS _T0 LEFT OUTER JOIN (SELECT MAX(_A.cw_ordernum) AS C0 |
1542 FROM cw_CWAttribute AS _A) AS _T0 LEFT OUTER JOIN (SELECT MAX(_A.cw_ordernum) AS C0 |
1543 FROM cw_CWRelation AS _A) AS _T1 ON (_T0.C0=_T1.C0)'''), |
1543 FROM cw_CWRelation AS _A) AS _T1 ON (_T0.C0=_T1.C0)'''), |
|
1544 |
|
1545 ('''Any TT1,STD,STDD WHERE TT2 identity TT1? |
|
1546 WITH TT1,STDD BEING (Any T,SUM(TD) GROUPBY T WHERE T is Affaire, T duration TD, TAG? tags T, TAG name "t"), |
|
1547 TT2,STD BEING (Any T,SUM(TD) GROUPBY T WHERE T is Affaire, T duration TD)''', |
|
1548 '''SELECT _T0.C0, _T1.C1, _T0.C1 |
|
1549 FROM (SELECT _T.cw_eid AS C0, SUM(_T.cw_duration) AS C1 |
|
1550 FROM cw_Affaire AS _T |
|
1551 GROUP BY _T.cw_eid) AS _T1 LEFT OUTER JOIN (SELECT _T.cw_eid AS C0, SUM(_T.cw_duration) AS C1 |
|
1552 FROM cw_Affaire AS _T LEFT OUTER JOIN tags_relation AS rel_tags0 ON (rel_tags0.eid_to=_T.cw_eid) LEFT OUTER JOIN cw_Tag AS _TAG ON (rel_tags0.eid_from=_TAG.cw_eid AND _TAG.cw_name=t) |
|
1553 GROUP BY _T.cw_eid) AS _T0 ON (_T1.C0=_T0.C0)'''), |
1544 )): |
1554 )): |
1545 yield t |
1555 yield t |
1546 |
1556 |
1547 |
1557 |
1548 def test_subquery_error(self): |
1558 def test_subquery_error(self): |