changeset 723:7200f7942b16

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
author Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
date Thu, 19 Jan 2023 19:55:10 +0100 (2023-01-19)
parents 9a243dce3b15
children 2b763b189452
files src/main/java/org/monetdb/client/JdbcClient.java
diffstat 1 files changed, 2 insertions(+), 1 deletions(-) [+]
line wrap: on
line diff
--- 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())