[dbmanager] Fix python error when scrolling postgis results

Fixes #17835
qgis · Feb 13, 2018 · fa56aa5 · fa56aa5
1 parent ad84961
commit fa56aa5
Show file tree

Hide file tree

Showing 2 changed files with 3 additions and 3 deletions.
diff --git a/python/plugins/db_manager/db_plugins/data_model.py b/python/plugins/db_manager/db_plugins/data_model.py
@@ -125,7 +125,7 @@ def _sanitizeTableField(self, field):
     def getData(self, row, col):
         if row < self.fetchedFrom or row >= self.fetchedFrom + self.fetchedCount:
             margin = self.fetchedCount / 2
-            start = self.rowCount() - margin if row + margin >= self.rowCount() else row - margin
+            start = int(self.rowCount() - margin if row + margin >= self.rowCount() else row - margin)
             if start < 0:
                 start = 0
             self.fetchMoreData(start)

diff --git a/python/plugins/db_manager/db_plugins/oracle/data_model.py b/python/plugins/db_manager/db_plugins/oracle/data_model.py
@@ -91,9 +91,9 @@ def getData(self, row, col):
                 row >= self.fetchedFrom + self.fetchedCount):
             margin = self.fetchedCount / 2
             if row + margin >= self.rowCount():
-                start = self.rowCount() - margin
+                start = int(self.rowCount() - margin)
             else:
-                start = row - margin
+                start = int(row - margin)
             if start < 0:
                 start = 0
             self.fetchMoreData(start)