[hibernate-issues] [Hibernate-JIRA] Updated: (HHH-2016) Oracle9Dialect registers last_day() function as "lastday"

[Diego Pires Plentz (JIRA)]

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

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: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira