Evgenij Ryazanov

Please, read actual documentation of `java.sql.ResultSet`. With queries like that ```SQL SELECT TABLE_NAME.COLUMN_NAME ALIAS_NAME FROM … ``` you may pass only `ALIAS_NAME` to methods of `ResultSet`, any other arguments are...

In JDBC, label is an alias of a column or its name if alias is not specified, see Javadoc of `ResultSetMetaData.getColumnLabel()` and `ResultSetMetaData.getColumnName()`. Section 15.2.3 Retrieving Values of JDBC Specification,...

In SQL, query like `SELECT T1.A, Q.B X, C FROM T1, T2 Q, T3` produces three columns: `A`, `X`, and `C` and you can use only `A`, `X` and `C`...

Sorry, I think we cannot accept this pull request due to following reasons: 1. `org.h2.api.DatabaseEventListener` is a part of API and we cannot change it in incompatible way, at least...

This feature is complicated. I wrote a draft implementation some time ago (not compatible with current H2), but it worked properly only in some cases, more complicated queries with nested...

To use `MODIFY COLUMN` you need to enable MySQL or MariaDB compatibility mode. You also need to remove the `AFTER` clause, you cannot reorder columns in H2.

You can wrap `ALTER col_0` part with MySQL executable comment `/*! */`, code in such comments is executed by MySQL and is ignored by H2: ```SQL ALTER TABLE table_name MODIFY...

I think there is a bug in H2, but inline referential constraints in table definitions are always problematic even when there are no bugs in the database system itself. At...

Duplicate of #3508

It still appears in CI tests from time to time, stack trace is the same.