[h2] Re: A confusing point about INFORMATION_SCHEMA of H2Database 2.x
- Thank you very much for your reply! - With such a change, I wonder if it is possible for me to continue to view the documentation for H2Database 1.x at a documentation address somewhere? I kind of want to compare the two different versions of the documentation, but I pay attention Go to https://github.com/h2database/h2database.github.io and there is no Git Tag for H2Database 1.x. 在2022年8月4日星期四 UTC+8 16:05:42 写道: > You can read data type name and other parameters from the COLUMNS table: > https://h2database.com/html/systemtables.html#information_schema_columns > DATA_TYPE column now contains the name as required by the SQL Standard. > > For ARRAY data types there is an additional table with definitions of > elements: > > https://h2database.com/html/systemtables.html#information_schema_element_types > > For row value data types you need another additional table with > definitions of fields: > https://h2database.com/html/systemtables.html#information_schema_fields > > All these tables in H2 2.*.* are compliant with the SQL Standard. > > Non-standard ENUM data types have an own non-standard table with possible > values: > > https://h2database.com/html/systemtables.html#information_schema_enum_values > > In old versions of H2 INFORMATION_SCHEMA.COLUMNS.DATA_TYPE was incorrectly > used for JDBC type code. H2 2.*.* doesn't report JDBC-specific information > in the INFORMATION_SCHEMA, but you can read it from JDBC database metadata, > if you wish. > -- 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 h2-database+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/24337687-f5a2-436e-abd8-9b0ad0e77255n%40googlegroups.com.
[h2] A confusing point about INFORMATION_SCHEMA of H2Database 2.x
- Hi everyone, I'm migrating H2Database 1.x to 2.x. But I found a strange problem, and I can't find relevant information on the mailing list. - On H2Database 1.x, I use `SELECT TABLE_CATALOG, TABLE_NAME, COLUMN_NAME, DATA_TYPE, TYPE_NAME, ORDINAL_POSITION FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_CATALOG=? AND TABLE_SCHEMA=?` to check the metadata of the table. But on H2Database 2.x, `TYPE_NAME` has been removed. I'm not sure how I should change this SQL, the migration guide in the documentation doesn't provide much information. - But I checked https://github.com/h2database/h2database/blob/version-2.1.214/h2/src/main/org/h2/jdbc/meta/DatabaseMetaLocal.java#L299 , `TYPE_NAME` still seems to be Exists. But the documentation does remove information about this column. - I would be grateful for any possible reply. -- 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 h2-database+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/5f1dc234-1bbb-4dfc-b395-874155493f71n%40googlegroups.com.