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

   
_______________________________________________
hibernate-issues mailing list
hibernate-issues@(protected)
https://lists.jboss.org/mailman/listinfo/hibernate-issues