[rql2sql] add test case for 7493:3c46b9390871
authorSylvain Thénault <sylvain.thenault@logilab.fr>
Sat, 11 Jun 2011 09:22:25 +0200
changeset 7497 7beb71d76d82
parent 7496 0c75ed374b06
child 7514 32081892850e
[rql2sql] add test case for 7493:3c46b9390871
server/test/unittest_rql2sql.py
--- a/server/test/unittest_rql2sql.py	Fri Jun 10 17:41:41 2011 +0200
+++ b/server/test/unittest_rql2sql.py	Sat Jun 11 09:22:25 2011 +0200
@@ -544,6 +544,10 @@
 GROUP BY rel_todo_by0.eid_to
 ORDER BY 2 DESC'''),
 
+    ('Any R2 WHERE R2 concerne R, R eid RE, R2 eid > RE',
+     '''SELECT _R2.eid
+FROM concerne_relation AS rel_concerne0, entities AS _R2
+WHERE _R2.eid=rel_concerne0.eid_from AND _R2.eid>rel_concerne0.eid_to'''),
     ]
 
 ADVANCED_WITH_GROUP_CONCAT = [