Mercurial > hg > monetdb-java
changeset 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 | 1d6062d94377 |
| children | 72efb3e34436 |
| files | src/main/java/nl/cwi/monetdb/jdbc/MonetDatabaseMetaData.java |
| diffstat | 1 files changed, 2 insertions(+), 0 deletions(-) [+] |
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