diff src/main/java/nl/cwi/monetdb/jdbc/MonetDatabaseMetaData.java @ 279:34e3f5d4232b

Add a future TODO note (as a reminder)
author Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
date Thu, 18 Jul 2019 13:21:25 +0200 (2019-07-18)
parents 7d041f5c3fea
children d430f8adbf1b
line wrap: on
line diff
--- 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