server/test/unittest_rql2sql.py
changeset 7497 7beb71d76d82
parent 7473 a164fdf3de5d
child 7580 328542c4fdc8
--- 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 = [