[hibernate-dev] New HSQLDialect

[Fred Toussi]

I have attached the new version to HHH-5381.

The Hibernate test suite runs with few errors with HSQLDB 2.0.1 snapshot
(jars are at http://hsqldb.org/support/)

Several tests contain SQL that works only with a few products. I have
listed these issues on Jira HHH-5376 and HHH-5325. Most of the issues
can be fixed with minor changes to the SQL.

HSQLDB 2.0.1 has some rule enforcement settings that can be used as
connection or URL properties, all listed here:
http://hsqldb.org/doc/2.0/guide/dbproperties-chapt.html#N13D18
See the properties beginning with "sql.".

Some rules are relaxed by default, but if they are all turned on, more
tests result in failure.

Please review and ask any questions. I will help both with HSQLDB issues
and with general SQL issues.

Fred Toussi