[hibernate-dev] New HSQLDialect

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