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

[Fred Toussi (JIRA)]

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.



-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira