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

[H. C. Cäsar]

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).

SSCC example: https://pastebin.com/Tg0zc2C3

Best regards

[Andrei Tokar]

Please see comments on https://github.com/h2database/h2database/issues/3213