[tryton-commits] changeset in trytond:default Set a max limit to sqlite backend

[Cédric Krier]

changeset c792075308e9 in trytond:default
details: https://hg.tryton.org/trytond?cmd=changeset&node=c792075308e9
description:
        Set a max limit to sqlite backend

        SQLite does not support offset without a limit. So we must use a 
negative value
        to have no upper bound.

        issue11126
        review395291002
diffstat:

 trytond/backend/sqlite/database.py |  3 ++-
 1 files changed, 2 insertions(+), 1 deletions(-)

diffs (13 lines):

diff -r 70e7eb839a66 -r c792075308e9 trytond/backend/sqlite/database.py
--- a/trytond/backend/sqlite/database.py        Tue Jan 11 23:07:45 2022 +0100
+++ b/trytond/backend/sqlite/database.py        Thu Jan 20 19:03:19 2022 +0100
@@ -333,7 +333,8 @@
     _local = threading.local()
     _conn = None
     flavor = Flavor(
-        paramstyle='qmark', function_mapping=MAPPING, null_ordering=False)
+        paramstyle='qmark', function_mapping=MAPPING, null_ordering=False,
+        max_limit=-1)
     IN_MAX = 200
 
     TYPES_MAPPING = {