# HG changeset patch
# User Sylvain Thénault <sylvain.thenault@logilab.fr>
# Date 1311768189 -7200
# Node ID 2a1f078ebdcd954afd6bbedbcc90aa9133817e43
# Parent  0f49dd8e76b5382d15aaef8d389cecad0b0194b1
[sql test] lgdb > 1.6 use int for bool with sqlite backend

diff -r 0f49dd8e76b5 -r 2a1f078ebdcd server/test/unittest_rql2sql.py
--- a/server/test/unittest_rql2sql.py	Wed Jul 27 12:26:57 2011 +0200
+++ b/server/test/unittest_rql2sql.py	Wed Jul 27 14:03:09 2011 +0200
@@ -1871,7 +1871,7 @@
     backend = 'sqlite'
 
     def _norm_sql(self, sql):
-        return sql.strip().replace(' ILIKE ', ' LIKE ')
+        return sql.strip().replace(' ILIKE ', ' LIKE ').replace('TRUE', '1').replace('FALSE', '0')
 
     def test_date_extraction(self):
         self._check("Any MONTH(D) WHERE P is Personne, P creation_date D",