Mercurial > hg > monetdb-java
changeset 872:aa30a3be8787
Extend Test_DBCmetadata() with calls to DatabaseMetaData methods which return a String and need to sent a query to the server to get the info.
author | Martin van Dinther <martin.van.dinther@monetdbsolutions.com> |
---|---|
date | Thu, 08 Feb 2024 19:11:41 +0100 (14 months ago) |
parents | 16aea99c987f |
children | 90e9d216b232 |
files | tests/JDBC_API_Tester.java |
diffstat | 1 files changed, 29 insertions(+), 0 deletions(-) [+] |
line wrap: on
line diff
--- a/tests/JDBC_API_Tester.java +++ b/tests/JDBC_API_Tester.java @@ -1026,6 +1026,35 @@ final public class JDBC_API_Tester { sb.append("Failed to createStatement: ").append(e.getMessage()).append("\n"); } + try { + // test dbmd methods which sent a query to the server and return a String. + String s = dbmd.getSQLKeywords(); + if (s == null || s.length() < 10) + sb.append("getSQLKeywords()").append(" failed to return a large enough list\n"); + s = dbmd.getNumericFunctions(); + if (s == null || s.length() < 10) + sb.append("getNumericFunctions()").append(" failed to return a large enough list\n"); + s = dbmd.getStringFunctions(); + if (s == null || s.length() < 10) + sb.append("getStringFunctions()").append(" failed to return a large enough list\n"); + s = dbmd.getSystemFunctions(); + if (s == null || s.length() < 10) + sb.append("getSystemFunctions()").append(" failed to return a large enough list\n"); + s = dbmd.getTimeDateFunctions(); + if (s == null || s.length() < 10) + sb.append("getTimeDateFunctions()").append(" failed to return a large enough list\n"); + s = dbmd.getUserName(); + if (s == null || s.length() < 1) + sb.append("getUserName() failed to return a valid name\n"); + s = dbmd.getDatabaseProductVersion(); + if (s == null || s.length() < 1) + sb.append("getDatabaseProductVersion() failed to return a valid version\n"); + } catch (SQLException e) { + sb.append(e.getMessage()).append("\n"); + } + compareExpectedOutput("Test_DBCmetadata() testing dbmd.get...Functions() as String", ""); + sb.setLength(0); // clear the output log buffer + /* servers before Jan2022 (11.45) have a problem (server crash and db corruption) with indexes created on temp tables, so conditionally execute those commands and tests */ final boolean testCreateDropIndexOnTmpTables = !(dbmsMajorVersion == 11 && dbmsMinorVersion <= 43);