1579 self._check('Any COUNT(U) WHERE U eid 1, EXISTS (P owned_by U, P is IN (Note, Affaire))', |
1579 self._check('Any COUNT(U) WHERE U eid 1, EXISTS (P owned_by U, P is IN (Note, Affaire))', |
1580 '''SELECT COUNT(1) |
1580 '''SELECT COUNT(1) |
1581 FROM (SELECT 1) AS _T |
1581 FROM (SELECT 1) AS _T |
1582 WHERE EXISTS(SELECT 1 FROM owned_by_relation AS rel_owned_by0, cw_Affaire AS _P WHERE rel_owned_by0.eid_from=_P.cw_eid AND rel_owned_by0.eid_to=1 UNION SELECT 1 FROM owned_by_relation AS rel_owned_by1, cw_Note AS _P WHERE rel_owned_by1.eid_from=_P.cw_eid AND rel_owned_by1.eid_to=1)''') |
1582 WHERE EXISTS(SELECT 1 FROM owned_by_relation AS rel_owned_by0, cw_Affaire AS _P WHERE rel_owned_by0.eid_from=_P.cw_eid AND rel_owned_by0.eid_to=1 UNION SELECT 1 FROM owned_by_relation AS rel_owned_by1, cw_Note AS _P WHERE rel_owned_by1.eid_from=_P.cw_eid AND rel_owned_by1.eid_to=1)''') |
1583 |
1583 |
|
1584 def test_groupby_multiple_outerjoins(self): |
|
1585 self._check('Any A,U,P,group_concat(TN) GROUPBY A,U,P WHERE A is Affaire, A concerne N, N todo_by U?, T? tags A, T name TN, A todo_by P?', |
|
1586 "SHOULD NOT CRASH") |
|
1587 |
1584 |
1588 |
1585 class removeUnsusedSolutionsTC(TestCase): |
1589 class removeUnsusedSolutionsTC(TestCase): |
1586 def test_invariant_not_varying(self): |
1590 def test_invariant_not_varying(self): |
1587 rqlst = mock_object(defined_vars={}) |
1591 rqlst = mock_object(defined_vars={}) |
1588 rqlst.defined_vars['A'] = mock_object(scope=rqlst, stinfo={'optrelations':False}, _q_invariant=True) |
1592 rqlst.defined_vars['A'] = mock_object(scope=rqlst, stinfo={'optrelations':False}, _q_invariant=True) |