Evgenij Ryazanov

H2 2.1 is going to be released with Java 8 support. Its patch releases, if any, will also have Java 8 support. This version doesn't have any significant new features,...

Current `master` branch doesn't have any noticeable new features or incompatible changes. It means the next release in 2.1 series of releases can be made directly from this branch and...

Did you read the documentation? https://h2database.com/html/commands.html#truncate_table > Only regular data tables without foreign key constraints can be truncated (except if referential integrity is disabled for this database or for this...

BTW, SQL Standard also forbids this command for referenced tables. So there are no incompatibilities with the standard in H2. ``` T shall not be identified by the name of...

No, such things aren't configurable and shouldn't be configurable, H2 is not an emulator of other DBMS. But it looks like a bug anyway. When there is only a unique...

In the SQL Standard, in H2, and in many database systems, `PRIMARY KEY` is not an index, it is a constraint. `UNIQUE` is also a constraint. But MySQL is very...

It looks like duplicate of #910. You can try to use unique names of CTEs as a workaround (something like `X_A` and `Y_A` instead of `A`).

You need to write your own implementation of `org.h2.api.DatabaseEventListener`, add it to classpath of your application (or database server if you use a separate server process), and specify its name...

I missed an important thing in exception. In the SQL Standard and in the most of database systems it isn't possible to create a table (or view) without columns. But...

You can try the recovery tool from 1.4.196 or other older version, in some cases they can handle corrupted files from newer versions of H2 1.4 better. If it will...