Mercurial > hg > monetdb-java

comparison tests/JDBC_API_Tester.java @ 827:b2cbe866d020

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Enhanced DatabaseMetaData.getTables() method by adding support for SQL table type names: 'BASE TABLE', 'GLOBAL TEMPORARY' and 'LOCAL TEMPORARY' in parameter types[]. These are SQL synonyms of MonetDB table type names: 'TABLE', 'GLOBAL TEMPORARY TABLE' and 'LOCAL TEMPORARY TABLE'.
author Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
date Wed, 20 Dec 2023 19:10:17 +0100 (16 months ago)
parents 4c35009cd59c
children 7eb05cbf67dc
comparison
equal deleted inserted replaced
826:1074ad1a4c63 827:b2cbe866d020
1155 "null jdbctst fk2c TABLE null null null null null null\n" + 1155 "null jdbctst fk2c TABLE null null null null null null\n" +
1156 "null jdbctst nopk_twoucs TABLE jdbctst.nopk_twoucs table comment null null null null null\n" + 1156 "null jdbctst nopk_twoucs TABLE jdbctst.nopk_twoucs table comment null null null null null\n" +
1157 "null jdbctst pk2c TABLE null null null null null null\n" + 1157 "null jdbctst pk2c TABLE null null null null null null\n" +
1158 "null jdbctst pk_uc TABLE jdbctst.pk_uc table comment null null null null null\n"); 1158 "null jdbctst pk_uc TABLE jdbctst.pk_uc table comment null null null null null\n");
1159 1159
1160 compareResultSet(dbmd.getTables(null, "tmp", "tlargechar", null), "getTables(null, tmp, tlargechar, null)", 1160 String tabletypes[] = {"BASE TABLE", "LOCAL TEMPORARY", "GLOBAL TEMPORARY"};
1161 compareResultSet(dbmd.getTables(null, "tmp", "tlargechar", tabletypes), "getTables(null, tmp, tlargechar, tabletypes)",
1161 "Resultset with 10 columns\n" + 1162 "Resultset with 10 columns\n" +
1162 "TABLE_CAT TABLE_SCHEM TABLE_NAME TABLE_TYPE REMARKS TYPE_CAT TYPE_SCHEM TYPE_NAME SELF_REFERENCING_COL_NAME REF_GENERATION\n" + 1163 "TABLE_CAT TABLE_SCHEM TABLE_NAME TABLE_TYPE REMARKS TYPE_CAT TYPE_SCHEM TYPE_NAME SELF_REFERENCING_COL_NAME REF_GENERATION\n" +
1163 "char(1) varchar(1024) varchar(1024) varchar(25) varchar(1048576) char(1) char(1) char(1) char(1) char(1)\n" + 1164 "char(1) varchar(1024) varchar(1024) varchar(25) varchar(1048576) char(1) char(1) char(1) char(1) char(1)\n" +
1164 "null tmp tlargechar LOCAL TEMPORARY TABLE null null null null null null\n"); 1165 "null tmp tlargechar LOCAL TEMPORARY TABLE null null null null null null\n");
1165 1166