Mercurial > hg > monetdb-java

comparison tests/JDBC_API_Tester.java @ 757:7f68120de37c

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Corrected DatabaseMetaData method getClientProperties(). It used to return connection properties instead of client info properties. Extended tests. HG En commit message. Lines beginning with 'HG:' are removed.
author Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
date Thu, 22 Jun 2023 14:54:03 +0200 (22 months ago)
parents b6eb51cb5cee
children 052c23fbfab2
comparison
equal deleted inserted replaced
756:a39d3a45da56 757:7f68120de37c
1341 1341
1342 compareResultSet(dbmd.getColumnPrivileges(null, "sys", "table\\_types", null), "getColumnPrivileges(null, sys, table\\_types, null)", 1342 compareResultSet(dbmd.getColumnPrivileges(null, "sys", "table\\_types", null), "getColumnPrivileges(null, sys, table\\_types, null)",
1343 "Resultset with 8 columns\n" + 1343 "Resultset with 8 columns\n" +
1344 "TABLE_CAT TABLE_SCHEM TABLE_NAME COLUMN_NAME GRANTOR GRANTEE PRIVILEGE IS_GRANTABLE\n" + 1344 "TABLE_CAT TABLE_SCHEM TABLE_NAME COLUMN_NAME GRANTOR GRANTEE PRIVILEGE IS_GRANTABLE\n" +
1345 "char(1) varchar(1024) varchar(1024) varchar(1024) varchar(1024) varchar(1024) varchar(40) varchar(3)\n"); 1345 "char(1) varchar(1024) varchar(1024) varchar(1024) varchar(1024) varchar(1024) varchar(40) varchar(3)\n");
1346
1347 compareResultSet(dbmd.getClientInfoProperties(), "getClientInfoProperties()",
1348 "Resultset with 4 columns\n" +
1349 "NAME MAX_LEN DEFAULT_VALUE DESCRIPTION\n" +
1350 "varchar(64) int varchar(128) varchar(128)\n");
1351
1352 compareResultSet(dbmd.getSuperTables(null, "jdbctst", "pk_uc"), "getSuperTypes(null, jdbctst, pk_uc)",
1353 "Resultset with 4 columns\n" +
1354 "TABLE_CAT TABLE_SCHEM TABLE_NAME SUPERTABLE_NAME\n" +
1355 "char(1) char char char\n");
1356
1357 compareResultSet(dbmd.getPseudoColumns(null, "jdbctst", "pk_uc", "%"), "getPseudoColumns(null, jdbctst, pk_uc, %)",
1358 "Resultset with 12 columns\n" +
1359 "TABLE_CAT TABLE_SCHEM TABLE_NAME COLUMN_NAME DATA_TYPE COLUMN_SIZE DECIMAL_DIGITS NUM_PREC_RADIX COLUMN_USAGE REMARKS CHAR_OCTET_LENGTH IS_NULLABLE\n" +
1360 "char(1) char char char int int int int char char int char\n");
1361
1362 compareResultSet(dbmd.getVersionColumns(null, "jdbctst", "pk_uc"), "getVersionColumns(null, jdbctst, pk_uc)",
1363 "Resultset with 8 columns\n" +
1364 "SCOPE COLUMN_NAME DATA_TYPE TYPE_NAME COLUMN_SIZE BUFFER_LENGTH DECIMAL_DIGITS PSEUDO_COLUMN\n" +
1365 "smallint char(1) int char(1) int int smallint smallint\n");
1366
1367 compareResultSet(dbmd.getSuperTypes(null, "sys", "xml"), "getSuperTypes(null, sys, xml)",
1368 "Resultset with 6 columns\n" +
1369 "TYPE_CAT TYPE_SCHEM TYPE_NAME SUPERTYPE_CAT SUPERTYPE_SCHEM SUPERTYPE_NAME\n" +
1370 "char(1) char char char(1) char char\n");
1371
1372 compareResultSet(dbmd.getAttributes(null, "sys", "xml", "%"), "getAttributes(null, sys, xml, %)",
1373 "Resultset with 21 columns\n" +
1374 "TYPE_CAT TYPE_SCHEM TYPE_NAME ATTR_NAME DATA_TYPE ATTR_TYPE_NAME ATTR_SIZE DECIMAL_DIGITS NUM_PREC_RADIX NULLABLE REMARKS ATTR_DEF SQL_DATA_TYPE SQL_DATETIME_SUB CHAR_OCTET_LENGTH ORDINAL_POSITION IS_NULLABLE SCOPE_CATALOG SCOPE_SCHEMA SCOPE_TABLE SOURCE_DATA_TYPE\n" +
1375 "char(1) char char char int char int int int int char char int int int int char(3) char char char smallint\n");
1346 1376
1347 sb.setLength(0); // clear the output log buffer 1377 sb.setLength(0); // clear the output log buffer
1348 } catch (SQLException e) { 1378 } catch (SQLException e) {
1349 sb.setLength(0); // clear the output log buffer 1379 sb.setLength(0); // clear the output log buffer
1350 sb.append("FAILED: ").append(e.getMessage()).append("\n"); 1380 sb.append("FAILED: ").append(e.getMessage()).append("\n");