]
Diego Pires Plentz updated HHH-2016:
------------------------------------
Assignee: Diego Pires Plentz
Affects Version/s: (was: 3.2.0.cr3)
(was: 3.2.0.cr2)
(was: 3.2.0 cr1)
(was: 3.2.0.alpha2)
(was: 3.1.3)
(was: 3.1)
(was: 3.1.2)
(was: 3.1.1)
(was: 3.2.0.alpha1)
(was: 3.1 rc2)
(was: 3.1 rc 1)
(was: 3.1 beta 2)
(was: 3.1 beta 1)
(was: 3.0.5)
(was: 3.0.4)
(was: 3.0.3)
(was: 3.0.2)
(was: 3.0.1)
(was: 3.0 final)
(was: 3.0 rc 1)
(was: 3.0 beta 4)
(was: 3.0 beta 3)
(was: 3.0 beta 2)
(was: 3.1 rc3)
(was: 3.0 beta 1)
(was: 3.0 alpha)
3.2.5
Fix Version/s: 3.2.6
Oracle9Dialect registers last_day() function as "lastday"
---------------------------------------------------------
Key: HHH-2016
URL:
http://opensource.atlassian.com/projects/hibernate/browse/HHH-2016
Project: Hibernate3
Issue Type: Bug
Components: core
Affects Versions: 3.2.5
Environment: Hibernate 2.x, 3.x with an Oracle database
Reporter: Carl Lindberg
Assignee: Diego Pires Plentz
Priority: Minor
Fix For: 3.2.6
Attachments: Oracle9DialectPatch.diff, Oracle9DialectPatchOption2.diff
Original Estimate: 30 minutes
Remaining Estimate: 30 minutes
Oracle9Dialect.java registers a "lastday" function, however the actual Oracle
function is last_day() (with the underscore). This results in a SQL error if the function
is used in HQL (and obviously, HQL will not accept use of "last_day").
The patch is basically:
- registerFunction( "lastday", new StandardSQLFunction("lastday",
Hibernate.DATE) );
+ registerFunction( "last_day", new StandardSQLFunction("last_day",
Hibernate.DATE) );
or, if support for the incorrect "lastday" usage should still be supported:
- registerFunction( "lastday", new StandardSQLFunction("lastday",
Hibernate.DATE) );
+ registerFunction( "last_day", new StandardSQLFunction("last_day",
Hibernate.DATE) );
+ registerFunction( "lastday", new StandardSQLFunction("last_day",
Hibernate.DATE) );
Both patch options are attached.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: