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
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/h2-database/95cb0565-3122-46a0-87d7-e0ac067b7462n%40googlegroups.com.
