# HG changeset patch
# User Sylvain Thénault <sylvain.thenault@logilab.fr>
# Date 1307776945 -7200
# Node ID 7beb71d76d827d215aea6f26d2640b9a6ff13d7e
# Parent  0c75ed374b06250df0e7aea75fc72300bf8ee876
[rql2sql] add test case for 7493:3c46b9390871

diff -r 0c75ed374b06 -r 7beb71d76d82 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 = [