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

HSQLDB dialect - fixes reported issues and adds minor enhancement (Fred Toussi) ------------------------------------------------------------------------------- Key: HHH-6370 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-6370 Project: Hibernate Core Issue Type: Patch Components: core Affects Versions: 3.5.6, 3.6.5 Environment: Hibernate 3.6.x, HSQLDB 1.8.x and 2.x.x Reporter: Fred Toussi Assignee: Gail Badner Fix For: 4.0.0.next, 3.6.7 Attachments: HSQLDialect.patch, HSQLDialect.updated.patch Original Estimate: 0.5h Remaining Estimate: 0.5h 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