Please see comments on https://github.com/h2database/h2database/issues/3213
On Tuesday, November 30, 2021 at 1:46:58 PM UTC-5 [email protected] wrote: > 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/0d086bc5-c8d1-41b3-8882-9138ba66ba08n%40googlegroups.com.
