[test] add test for != operator stable
authorSylvain Thénault <sylvain.thenault@logilab.fr>
Tue, 01 Feb 2011 10:10:46 +0100
branchstable
changeset 6930 118881289a31
parent 6929 e9464d975908
child 6931 0af44a38fe41
child 6933 c99416cdd94b
[test] add test for != operator
server/test/unittest_rql2sql.py
--- a/server/test/unittest_rql2sql.py	Tue Feb 01 10:08:44 2011 +0100
+++ b/server/test/unittest_rql2sql.py	Tue Feb 01 10:10:46 2011 +0100
@@ -577,6 +577,10 @@
      '''SELECT _X.cw_eid
 FROM cw_CWEType AS _X
 WHERE NOT (EXISTS(SELECT 1 WHERE _X.cw_description=parent)) AND NOT (EXISTS(SELECT 1 WHERE _X.cw_description=_X.cw_name))'''),
+    ('CWEType X WHERE X name CV, X description V HAVING V!=CV AND V != "parent"',
+     '''SELECT _X.cw_eid
+FROM cw_CWEType AS _X
+WHERE _X.cw_description!=parent AND _X.cw_description!=_X.cw_name'''),
     ]