[rql2sql test] sqlserver use 0/1 for booleans, not FALSE/TRUE stable
authorSylvain Thénault <sylvain.thenault@logilab.fr>
Mon, 01 Aug 2011 18:43:10 +0200
branchstable
changeset 7724 313c874df009
parent 7723 badfd5524ab6
child 7725 f793d07b9de7
[rql2sql test] sqlserver use 0/1 for booleans, not FALSE/TRUE
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):