server/test/unittest_rql2sql.py
changeset 7397 6a9e66d788b3
parent 7359 40490b9e0a6e
parent 7396 8345ee2c2ea6
child 7429 20ef21926774
--- a/server/test/unittest_rql2sql.py	Wed May 18 16:04:47 2011 +0200
+++ b/server/test/unittest_rql2sql.py	Thu May 19 10:36:26 2011 +0200
@@ -631,7 +631,12 @@
     ("Personne X,Y where X nom NX, Y nom NX, X eid XE, not Y eid XE",
      '''SELECT _X.cw_eid, _Y.cw_eid
 FROM cw_Personne AS _X, cw_Personne AS _Y
-WHERE _Y.cw_nom=_X.cw_nom AND NOT (_Y.cw_eid=_X.cw_eid)''')
+WHERE _Y.cw_nom=_X.cw_nom AND NOT (_Y.cw_eid=_X.cw_eid)'''),
+
+    ('Any X,Y WHERE X is Personne, Y is Personne, X nom XD, Y nom XD, X eid Z, Y eid > Z',
+     '''SELECT _X.cw_eid, _Y.cw_eid
+FROM cw_Personne AS _X, cw_Personne AS _Y
+WHERE _Y.cw_nom=_X.cw_nom AND _Y.cw_eid>_X.cw_eid'''),
     ]