details: https://code.tryton.org/tryton/commit/a6cc5e85222f
branch: 7.6
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 71569f1ec261 -r a6cc5e85222f 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
@@ -151,7 +151,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
