# HG changeset patch
# User Sylvain Thénault <sylvain.thenault@logilab.fr>
# Date 1296551446 -3600
# Node ID 118881289a31280282324139efd2f5b4a6d4bbb9
# Parent  e9464d97590818a6084795638c89b6f76f3ddf84
[test] add test for != operator

diff -r e9464d975908 -r 118881289a31 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'''),
     ]