[h2] Re: A confusing point about INFORMATION_SCHEMA of H2Database 2.x
You need to download the complete distribution of the version you need in a ZIP archive: https://h2database.com/html/download-archive.html They contain documentation in PDF and HTML format. But INFORMATION_SCHEMA wasn't documented properly in old versions, so you cannot compare old and new implementation in that way. You can try to compare new and old implementations in the sources: https://github.com/h2database/h2database/blob/version-2.1.214/h2/src/main/org/h2/table/InformationSchemaTable.java https://github.com/h2database/h2database/blob/version-2.1.214/h2/src/main/org/h2/table/InformationSchemaTableLegacy.java Legacy implementation is provided by H2 Server to client processes with outdated drivers. -- 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/f541fabc-8f8e-4a18-975d-e910dcb004ffn%40googlegroups.com.
[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] Re: A confusing point about INFORMATION_SCHEMA of H2Database 2.x
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/e87f345e-df94-4609-a868-dfd77faa3aa8n%40googlegroups.com.
[h2] Re: A confusing point about INFORMATION_SCHEMA of H2Database 2.x
Hi! DatabaseMetaLocal is not related to INFORMATION_SCHEMA. It is a data source for implementation of java.sql.DatabaseMetaData. -- 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/55755d0b-d097-4aa1-baff-d61ea81d6a85n%40googlegroups.com.