Use scrollable resulsets only when offset > 0

serge-rider · serge-rider · commit 0ceca7804ee1 · 2020-10-18T22:34:45.000+03:00
diff --git a/plugins/org.jkiss.dbeaver.model/src/org/jkiss/dbeaver/model/DBUtils.java b/plugins/org.jkiss.dbeaver.model/src/org/jkiss/dbeaver/model/DBUtils.java
@@ -1299,7 +1299,7 @@ public static DBCStatement makeStatement(
             }
         }
 
-        boolean doScrollable = hasLimits;
+        boolean doScrollable = (offset > 0);
         String queryText;
         try {
             if (hasLimits && limitTransformer != null) {

Original file line number	Diff line number	Diff line change
`@@ -1299,7 +1299,7 @@ public static DBCStatement makeStatement(`
`1299`	`1299`	`}`
`1300`	`1300`	`}`
`1301`	`1301`
`1302`		`- boolean doScrollable = hasLimits;`
	`1302`	`+ boolean doScrollable = (offset > 0);`
`1303`	`1303`	`String queryText;`
`1304`	`1304`	`try {`
`1305`	`1305`	`if (hasLimits && limitTransformer != null) {`