[hibernate-issues] [Hibernate-JIRA] Updated: (HHH-2822) timestamp extraction functions for SAPDBDialect

[Steve Ebersole (JIRA)]

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

Steve Ebersole updated HHH-2822:
--------------------------------

             Assignee: Steve Ebersole
    Affects Version/s:     (was: 3.2.4.sp1)
                           (was: 3.2.5)
                           (was: 3.2.4)
                           (was: 3.2.3)
                           (was: 3.2.0.cr5)
                           (was: 3.2.0.ga)
                           (was: 3.2.2)
                           (was: 3.2.0.cr4)
                           (was: 3.2.0.cr3)
                           (was: 3.2.1)
                           (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)
        Fix Version/s: 3.3
                       3.2.6
           Issue Type: Improvement  (was: Bug)
              Summary: timestamp extraction functions for SAPDBDialect  (was: timestamp extraction functions do not work in SAPDBDialect)

> timestamp extraction functions for SAPDBDialect
> -----------------------------------------------
>
>                 Key: HHH-2822
>                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2822
>             Project: Hibernate3
>          Issue Type: Improvement
>          Components: query-hql
>         Environment: SAPDB 7.6
>            Reporter: Yossi Tamari
>            Assignee: Steve Ebersole
>            Priority: Minor
>             Fix For: 3.2.6, 3.3
>
>   Original Estimate: 1 hour
>  Remaining Estimate: 1 hour
>
> There is no registerFunction in the SAPDBDialect for the date extraction SQL functions (extract, day, hour...). Therefore, the inherited registration from Dialect are in effect. However, they all map to extract, which is no supported in SAPDB.
> The correct implementation is to register the following functions in SAPDBDialect.java:
> registerFunction( "second", new SQLFunctionTemplate(Hibernate.INTEGER, "second(?1)") );
> registerFunction( "minute", new SQLFunctionTemplate(Hibernate.INTEGER, "minute(?1)") );
> registerFunction( "hour", new SQLFunctionTemplate(Hibernate.INTEGER, "hour(?1)") );
> registerFunction( "day", new SQLFunctionTemplate(Hibernate.INTEGER, "day(?1)") );
> registerFunction( "month", new SQLFunctionTemplate(Hibernate.INTEGER, "month(?1)") );
> registerFunction( "year", new SQLFunctionTemplate(Hibernate.INTEGER, "year(?1)") );
> registerFunction( "extract", new SQLFunctionTemplate(Hibernate.INTEGER, "?1(?3)") );

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