server/test/unittest_rql2sql.py
branchstable
changeset 6930 118881289a31
parent 6929 e9464d975908
child 6940 1172c25655b7
--- 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'''),
     ]