equal
deleted
inserted
replaced
1522 ('Any A WHERE A ordernum O, A is CWAttribute WITH O BEING (Any MAX(O) WHERE A ordernum O, A is CWAttribute)', |
1522 ('Any A WHERE A ordernum O, A is CWAttribute WITH O BEING (Any MAX(O) WHERE A ordernum O, A is CWAttribute)', |
1523 '''SELECT _A.cw_eid |
1523 '''SELECT _A.cw_eid |
1524 FROM (SELECT MAX(_A.cw_ordernum) AS C0 |
1524 FROM (SELECT MAX(_A.cw_ordernum) AS C0 |
1525 FROM cw_CWAttribute AS _A) AS _T0, cw_CWAttribute AS _A |
1525 FROM cw_CWAttribute AS _A) AS _T0, cw_CWAttribute AS _A |
1526 WHERE _A.cw_ordernum=_T0.C0'''), |
1526 WHERE _A.cw_ordernum=_T0.C0'''), |
|
1527 |
|
1528 ('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)', |
|
1529 '''SELECT _T0.C0 |
|
1530 FROM (SELECT MAX(_A.cw_ordernum) AS C0 |
|
1531 FROM cw_CWAttribute AS _A) AS _T0 LEFT OUTER JOIN (SELECT MAX(_A.cw_ordernum) AS C0 |
|
1532 FROM cw_CWRelation AS _A) AS _T1 ON (_T0.C0=_T1.C0)'''), |
1527 )): |
1533 )): |
1528 yield t |
1534 yield t |
1529 |
1535 |
1530 |
1536 |
1531 def test_subquery_error(self): |
1537 def test_subquery_error(self): |