# HG changeset patch
# User Sylvain Thénault <sylvain.thenault@logilab.fr>
# Date 1312216990 -7200
# Node ID 313c874df0099747d3ac2f2db2abd7dc21e2662f
# Parent  badfd5524ab65d20c722b759aa9d8c09702082b1
[rql2sql test] sqlserver use 0/1 for booleans, not FALSE/TRUE

diff -r badfd5524ab6 -r 313c874df009 server/test/unittest_rql2sql.py
--- a/server/test/unittest_rql2sql.py	Mon Aug 01 17:59:48 2011 +0200
+++ b/server/test/unittest_rql2sql.py	Mon Aug 01 18:43:10 2011 +0200
@@ -1721,7 +1721,7 @@
 class SqlServer2005SQLGeneratorTC(PostgresSQLGeneratorTC):
     backend = 'sqlserver2005'
     def _norm_sql(self, sql):
-        return sql.strip().replace(' SUBSTR', ' SUBSTRING').replace(' || ', ' + ').replace(' ILIKE ', ' LIKE ')
+        return sql.strip().replace(' SUBSTR', ' SUBSTRING').replace(' || ', ' + ').replace(' ILIKE ', ' LIKE ').replace('TRUE', '1').replace('FALSE', '0')
 
     def test_has_text(self):
         for t in self._parse(HAS_TEXT_LG_INDEXER):