# HG changeset patch
# User Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
# Date 1674154510 -3600
# Node ID 7200f7942b16e0b8c18026213df8de1d3633c0b0
# Parent  9a243dce3b1502ae02a5f7ae6f346ced951be8db
For JdbcClient enlarge the fetchsize at connection moment.
This allows statements such as: call sys.eval('SELECT * from sys.keywords order by 1 desc;');
to be executed succesfully.
Before this change it would list only the first 250 rows and fail message:
Error [M0M10] resultBlocks[1] should have been fetched by now

diff --git a/src/main/java/org/monetdb/client/JdbcClient.java b/src/main/java/org/monetdb/client/JdbcClient.java
--- a/src/main/java/org/monetdb/client/JdbcClient.java
+++ b/src/main/java/org/monetdb/client/JdbcClient.java
@@ -289,7 +289,8 @@ public class JdbcClient {	/* cannot (yet
 		}
 
 		// build the extra arguments of the JDBC connect string
-		String attr = "?";
+		// increase the fetchsize from the default 250 to 10000
+		String attr = "?fetchsize=10000&";
 		CmdLineOpts.OptionContainer oc = copts.getOption("language");
 		final String lang = oc.getArgument();
 		if (oc.isPresent())