H2 2.0.202 table metadata tabletype is "BASE TABLE" instead "TABLE"

161 views
Skip to first unread message

H. C. Cäsar

unread,
Nov 30, 2021, 1:46:58 PM11/30/21
to H2 Database
Hello,

congratulations and many thanks for the new H2 release.

I started to migrate some applications and found the following changed behaviour:
  • CREATE TABLE TEST_1 (MY_COL CHARACTER VARYING(10))
  • Get the table type per JDBC:
  • rs = connection.getMetaData().getTables(...); rs.next(); rs.getString("TABLE_TYPE");
  • H2 version 1.x delivers "TABLE", but 2.x returns "BASE TABLE".
I'm not sure if it is really a bug, but it is at least an unexpected behaviour not seen with other JDBC drivers. Although the table is actually a "base table" regarding the ANSI/ISO standard, there exists no standardized keywords like "BASE" (only "GLOBAL|LOCAL TEMPORARY" are allowed as table scope).


Best regards

Andrei Tokar

unread,
Nov 30, 2021, 8:19:23 PM11/30/21
to H2 Database
Please see comments on https://github.com/h2database/h2database/issues/3213
Reply all
Reply to author
Forward
0 new messages