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

[Steve Ebersole (JIRA)]

     [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-5401?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steve Ebersole updated HHH-5401:
--------------------------------

    Fix Version/s: 3.6.0.Beta2
                   3.5.5

> 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
>             Fix For: 3.6.0.Beta2, 3.5.5
>
>         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