equal
deleted
inserted
replaced
1476 yield t |
1476 yield t |
1477 |
1477 |
1478 def test_subquery(self): |
1478 def test_subquery(self): |
1479 for t in self._parse(( |
1479 for t in self._parse(( |
1480 |
1480 |
|
1481 ('Any X,N ' |
|
1482 'WHERE NOT EXISTS(X owned_by U) ' |
|
1483 'WITH X,N BEING ' |
|
1484 '((Any X,N WHERE X name N, X is State)' |
|
1485 ' UNION ' |
|
1486 '(Any XX,NN WHERE XX name NN, XX is Transition))', |
|
1487 '''SELECT _T0.C0, _T0.C1 |
|
1488 FROM ((SELECT _X.cw_eid AS C0, _X.cw_name AS C1 |
|
1489 FROM cw_State AS _X) |
|
1490 UNION ALL |
|
1491 (SELECT _XX.cw_eid AS C0, _XX.cw_name AS C1 |
|
1492 FROM cw_Transition AS _XX)) AS _T0 |
|
1493 WHERE NOT (EXISTS(SELECT 1 FROM owned_by_relation AS rel_owned_by0 WHERE rel_owned_by0.eid_from=_T0.C0))'''), |
|
1494 |
1481 ('Any N ORDERBY 1 WITH N BEING ' |
1495 ('Any N ORDERBY 1 WITH N BEING ' |
1482 '((Any N WHERE X name N, X is State)' |
1496 '((Any N WHERE X name N, X is State)' |
1483 ' UNION ' |
1497 ' UNION ' |
1484 '(Any NN WHERE XX name NN, XX is Transition))', |
1498 '(Any NN WHERE XX name NN, XX is Transition))', |
1485 '''SELECT _T0.C0 |
1499 '''SELECT _T0.C0 |
1549 FROM (SELECT _T.cw_eid AS C0, SUM(_T.cw_duration) AS C1 |
1563 FROM (SELECT _T.cw_eid AS C0, SUM(_T.cw_duration) AS C1 |
1550 FROM cw_Affaire AS _T |
1564 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 |
1565 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) |
1566 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)'''), |
1567 GROUP BY _T.cw_eid) AS _T0 ON (_T1.C0=_T0.C0)'''), |
1554 )): |
1568 |
|
1569 )): |
1555 yield t |
1570 yield t |
1556 |
1571 |
1557 |
1572 |
1558 def test_subquery_error(self): |
1573 def test_subquery_error(self): |
1559 rql = ('Any N WHERE X name N WITH X BEING ' |
1574 rql = ('Any N WHERE X name N WITH X BEING ' |