Reviewers: ,

Description:
trytond: Fix ir_translation clause on res_id

Please review this at http://codereview.tryton.org/805002/

Affected files:
  M trytond/model/modelsql.py


Index: trytond/model/modelsql.py
===================================================================
--- a/trytond/model/modelsql.py
+++ b/trytond/model/modelsql.py
@@ -1550,7 +1550,7 @@
                         table_join = ('LEFT JOIN "ir_translation" '
                             'ON (ir_translation.name = '
                                     'ir_model.model||\',%s\' '
-                                'AND ir_translation.res_id = 0 '
+                                'AND ir_translation.res_id IS NULL '
                                 'AND ir_translation.lang = %%s '
                                 'AND ir_translation.type = \'model\' '
                                 'AND ir_translation.fuzzy = %%s)'
@@ -1565,7 +1565,7 @@
                             'LEFT JOIN "ir_translation" '
                             'ON (ir_translation.name = '
                                     'ir_model.model||\',\'||%s.name '
-                                'AND ir_translation.res_id = 0 '
+                                'AND ir_translation.res_id IS NULL '
                                 'AND ir_translation.lang = %%s '
                                 'AND ir_translation.type = \'%s\' '
                                 'AND ir_translation.fuzzy = %%s)'
@@ -1810,7 +1810,7 @@
                     table_join = ('LEFT JOIN "ir_translation" '
                         'AS "%s" ON '
                         '("%s".name = "ir_model".model||\',%s\' '
-                            'AND "%s".res_id = 0 '
+                            'AND "%s".res_id IS NULL '
                             'AND "%s".lang = %%s '
                             'AND "%s".type = \'model\' '
                             'AND "%s".fuzzy = %%s)'
@@ -1829,7 +1829,7 @@
                     table_join = ('LEFT JOIN "ir_translation" '
                         'AS "%s" ON '
                         '("%s".name = "ir_model".model||\',\'||%s.name '
-                            'AND "%s".res_id = 0 '
+                            'AND "%s".res_id IS NULL '
                             'AND "%s".lang = %%s '
                             'AND "%s".type = \'%s\' '
                             'AND "%s".fuzzy = %%s)'


Reply via email to