# HG changeset patch # User Martin van Dinther <martin.van.dinther@monetdbsolutions.com> # Date 1563448885 -7200 # Node ID 34e3f5d4232b7f33300660d6df2ebeabb25db1e7 # Parent 1d6062d943773e5fa05714cc6489b68f22941411 Add a future TODO note (as a reminder) diff --git a/src/main/java/nl/cwi/monetdb/jdbc/MonetDatabaseMetaData.java b/src/main/java/nl/cwi/monetdb/jdbc/MonetDatabaseMetaData.java --- a/src/main/java/nl/cwi/monetdb/jdbc/MonetDatabaseMetaData.java +++ b/src/main/java/nl/cwi/monetdb/jdbc/MonetDatabaseMetaData.java @@ -512,6 +512,8 @@ public class MonetDatabaseMetaData exten @Override public String getSystemFunctions() { + // Note: As of Apr2019 (11.33.3) release the system table systemfunctions is replaced by a view which queries functions.system + // TODO: Replace join to sys.systemfunctions with " AND \"system\" " but only if the server-version is >= 11.33.3 String wherePart = "\"id\" NOT IN (SELECT \"func_id\" FROM \"sys\".\"args\" WHERE \"number\" = 1)" + // without any args " AND \"id\" IN (SELECT \"function_id\" FROM \"sys\".\"systemfunctions\")" + // only functions marked as system