ALTER TABLE, INSERT INTO .. SELECT

Support for:
ALTER TABLE .. DROP CONSTRAINT .., ALTER TABLE .. RENAME TO .., INSERT INTO .. SELECT ..

Statement.getGeneratedKeys is supported now.

A coverage test tool is now used. The regression test was quite poor before, as the test did not cover 34% of the code (jdbc and core packages, and Translator class in the parser package). The goal is to test nearly 100%. Some new tests have been added, and some new bugs have been found and fixed: NOT LIKE, DatabaseMetaData.getCatalogs, DatabaseMetaData.getUDTs, Connection.nativeSQL. RIGHT OUTER JOIN problem found. HAVING was not translated correctly (and HSQLDB doesn't support HAVING). Current level: 26% not covered.

RIGHT OUTER JOIN is currently not supported by HSQLDB. The syntax for RIGHT OUTER JOIN was removed at this time, because it

seems left outer joins are enough.

Firebird is support up to some point. But there are just too many problems and limitations with this database as of now.
For example this database does not seem to support the most basic functions (for example 'length'), binary constants are not supported, and there are problems with transactions.

The Console functionality is slightly extended.

O/R mapping tool: missing features have been implemented, and the API has been simplified. The OR classes are now included in the ldbc.jar. The coverage tool shows that only around 5% is not yet tested.

Support for remarks (/* start-end style */ and -- single line style) in SQL statements.

Some workarounds for changes in HSQLDB 1.7.2 RC 2 are implemented (added keyword TOP, workaround for LONGVARCHAR change).