[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-5401) Update to HHH-5381 HSQLDB new dialect (Fred Toussi)

Update to HHH-5381 HSQLDB new dialect (Fred Toussi) ---------------------------------------------------- Key: HHH-5401 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-5401 Project: Hibernate Core Issue Type: Patch Environment: HSQLDB Hibernate 3.5.x Reporter: Fred Toussi Attachments: HSQLDialect.diff Issue opened as advised by Steve. An updated version of HHH-581 that reflects some user feedback with existing databases upgraded to 2.0 and new databases. In this version BOOLEAN is included in the list of types and the literal values for BOOLEAN are defined as "true" or "false" instead of "1" or "0". Both v. 1.8.x and 2.0 support BOOLEAN (with true and false). In 1.8.x BIT is a synonym for BOOLEAN. In 2.0, BIT is a separate type representing a bit map which can have 0 or 1. As BOOLEAN is the prefered type in terms of storage requirements and usage in queries, it is better if this is used directly. I did not make this change initially as I was concerned about possible effects with existing databases. It now seems the change has no side effects and actually results in better SQL conformance.