The optimization for IN(...) queries combined with OR could result in a strange exception of the type "column x must be included in the group by list".

Fix bug in optimising SELECT * FROM A WHERE X=1 OR X=2 OR X=3 into SELECT * FROM A WHERE X IN (1,2,3)

Issue 274: Sybase/MSSQLServer compatibility - support index clause e.g. "select * from test (index table1_index)"

Fix Issue 389: When there is a multi-column primary key, H2 does not seem to always pick the right index

Add new collation command SET BINARY_COLLATION UNSIGNED, helps with people testing BINARY columns in MySQL mode.

H2 Console: the session timeout can now be configured using the system property "h2.consoleTimeout".

Issue 431: Improved compatibility with MySQL: support for "ENGINE=InnoDB charset=UTF8" when creating a table.

Issue 249: Improved compatiblity with MySQL in the MySQL mode: now the methods DatabaseMetaData methods stores*Case*Identifiers return the same as MySQL when using the MySQL mode.

Throw an explicit error to make it clear we don't support the TRIGGER combination of SELECT and FOR EACH ROW

Apply #418: MySQL compatibility: support for ALTER TABLE tbl_name MODIFY [COLUMN] col_name column_definition, patch from Ville Koskela.