[FIX] Expression : query handling problem

[odoo/odoo.git] / bin / osv / expression.py

diff --git a/bin/osv/expression.py b/bin/osv/expression.py
index c7817cf..7aa3b6a 100644 (file)
--- a/bin/osv/expression.py
+++ b/bin/osv/expression.py
@@ -256,11 +256,11 @@ class expression(object):
             params = []
             
             if right == False and (leaf[0] in table._columns)  and table._columns[leaf[0]]._type=="boolean"  and (operator == '='):
-                query = '%s.%s IS NULL or %s.%s = false ' % (table._table, left,table._table, left)
+                query = '(%s.%s IS NULL or %s.%s = false )' % (table._table, left,table._table, left)
             elif (((right == False) and (type(right)==bool)) or (right is None)) and (operator == '='):
                 query = '%s.%s IS NULL ' % (table._table, left)
             elif right == False and (leaf[0] in table._columns)  and table._columns[leaf[0]]._type=="boolean"  and (operator in ['<>', '!=']):
-                query = '%s.%s IS NOT NULL and %s.%s != false' % (table._table, left,table._table, left)
+                query = '(%s.%s IS NOT NULL and %s.%s != false)' % (table._table, left,table._table, left)
             elif (((right == False) and (type(right)==bool)) or right is None) and (operator in ['<>', '!=']):
                 query = '%s.%s IS NOT NULL' % (table._table, left)
             else: