[hibernate-issues] [Hibernate-JIRA] Created: (HHH-6370) HSQLDB dialect - fixes reported issues and adds minor enhancement

[Fred Toussi (JIRA)]

HSQLDB dialect - fixes reported issues and adds minor enhancement
-----------------------------------------------------------------

                 Key: HHH-6370
                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-6370
             Project: Hibernate Core
          Issue Type: Patch
          Components: core
    Affects Versions: 3.6.5, 3.5.6
         Environment: Hibernate 3.6.x, HSQLDB 1.8.x and 2.x.x
            Reporter: Fred Toussi
         Attachments: HSQLDialect.patch

Corrections - fixes HHH-5503

- second(datetime) function requires cast to integer as with HSQLDB 2.x.x it can return BigDecimal to include second fractions.
- nulls in SELECT lists are now supported for BLOB and other previously missing types.
- COMMENT ON is supported only in 2.x.x

Enhancements - fixes HHH-6012

- added a few common function definitions

-- 
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