details: https://code.tryton.org/tryton/commit/4ca02720ace6
branch: 7.4
user: Cédric Krier <[email protected]>
date: Wed Dec 24 11:38:45 2025 +0100
description:
Always surround WHERE clause with parentheses in EXCLUDE constraint
Closes #14449
(grafted from 7e50d52dc65227f494c6ad965917364fc08f0c5e)
diffstat:
trytond/trytond/model/modelsql.py | 2 +-
1 files changed, 1 insertions(+), 1 deletions(-)
diffs (12 lines):
diff -r 33dc0ceecccf -r 4ca02720ace6 trytond/trytond/model/modelsql.py
--- a/trytond/trytond/model/modelsql.py Tue Dec 23 12:09:31 2025 +0100
+++ b/trytond/trytond/model/modelsql.py Wed Dec 24 11:38:45 2025 +0100
@@ -149,7 +149,7 @@
for column, operator in self.excludes)
where = ''
if self.where:
- where = ' WHERE ' + str(self.where)
+ where = ' WHERE (' + str(self.where) + ')'
if using:
using = 'USING ' + using
return 'EXCLUDE %s (%s)' % (using, exclude) + where