equal
deleted
inserted
replaced
193 # XXX complete |
193 # XXX complete |
194 self.execute('Any X,Y WHERE X is Card, Y is Affaire, X creation_date D, Y creation_date > D') |
194 self.execute('Any X,Y WHERE X is Card, Y is Affaire, X creation_date D, Y creation_date > D') |
195 |
195 |
196 def test_union(self): |
196 def test_union(self): |
197 afeids = self.execute('Affaire X') |
197 afeids = self.execute('Affaire X') |
198 ueids = self.execute('EUser X') |
198 ueids = self.execute('CWUser X') |
199 rset = self.execute('(Any X WHERE X is Affaire) UNION (Any X WHERE X is EUser)') |
199 rset = self.execute('(Any X WHERE X is Affaire) UNION (Any X WHERE X is CWUser)') |
200 self.assertEquals(sorted(r[0] for r in rset.rows), |
200 self.assertEquals(sorted(r[0] for r in rset.rows), |
201 sorted(r[0] for r in afeids + ueids)) |
201 sorted(r[0] for r in afeids + ueids)) |
202 |
202 |
203 def test_subquery1(self): |
203 def test_subquery1(self): |
204 rsetbase = self.execute('Any W,X WITH W,X BEING (Any W,X ORDERBY W,X WHERE X wikiid W)') |
204 rsetbase = self.execute('Any W,X WITH W,X BEING (Any W,X ORDERBY W,X WHERE X wikiid W)') |