Evgenij Ryazanov

H2 supports user-defined table value functions exactly is the same way as other user-defined functions, they simply need to return a `java.sql.ResultSet`.

`SELECT something FROM table_function(…)` should work, other use cases aren't valid. Current H2 also allows table value functions as plain expressions, such as `SELECT table_function(…)`, but such support is a...

External table value functions in H2 always had various defective by design implementations and fixes for some issues broke other things. They need a brand new API designed in a...

From my point of view the best option is to add support for catalogs where each catalog in our case will represent a separate database (file) and all these files...

Catalogs will be the best option for connections between multiple H2's own databases located on the same host system. For connections to other DBMS there are no oblivious improvements. Hypothetically...

What exactly do you need? To have `GEOMETRY(SRID)` as result of data type combination between `GEOMETRY(SUBTYPE1, SRID)` and `GEOMETRY(SUBTYPE2, SRID)`?

Current documentation of `CREATE INDEX` is up to date: https://h2database.com/html/commands.html#create_index H2 doesn't support partial indexes and indexes on expressions, but supports indexes on computed columns. Index on computed column can...

What is a difference between `GEOMETRY` and `GEOGRAPHY`? X and Y coordinates need to be limited to -180…180 and -90…90. What else? Fixed predefined SRID? But there are multiple coordinate...

The whole `pg_catalog` needs to be reimplemented in some sane way (similar to `MetaTable`, for example), current `pg_catalog.sql` is not really reliable, because it isn't refreshed when necessary and it...

PostgreSQL-style quantified comparison predicates with arrays are fully supported since H2 2.2.220: https://h2database.com/html/grammar.html#quantified_comparison_right_hand_side