10:03 a.m.
timestamp extraction functions do not work in SAPDBDialect
----------------------------------------------------------
Key: HHH-2822
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2822
Project: Hibernate3
Issue Type: Bug
Components: query-hql
Affects Versions: 3.2.5, 3.2.4.sp1, 3.2.4, 3.2.3, 3.2.2, 3.2.1, 3.2.0.ga, 3.2.0.cr5,
3.2.0.cr4, 3.2.0.cr3, 3.2.0.cr2, 3.2.0 cr1, 3.1.3, 3.2.0.alpha2, 3.2.0.alpha1, 3.1.2,
3.1.1, 3.1, 3.1 rc3, 3.1 rc2, 3.1 rc 1, 3.1 beta 2, 3.1 beta 1, 3.0.5, 3.0.4, 3.0.3,
3.0.2, 3.0.1, 3.0 final, 3.0 rc 1, 3.0 beta 4, 3.0 beta 3, 3.0 beta 2, 3.0 beta 1, 3.0
alpha
Environment: SAPDB 7.6
Reporter: Yossi Tamari
Priority: Minor
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....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
1:16 a.m.
New subject: [Hibernate-JIRA] Updated: (HHH-2822) timestamp extraction functions for SAPDBDialect
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-2822?page=c...
]
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....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
1:18 a.m.
New subject: [Hibernate-JIRA] Closed: (HHH-2822) timestamp extraction functions for SAPDBDialect
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-2822?page=c...
]
Steve Ebersole closed HHH-2822.
-------------------------------
Resolution: Fixed
3.2/trunk
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....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
6076
days inactive
6107
days old
hibernate-issues@lists.jboss.org
2 comments
2 participants
participants (2)
-
Steve Ebersole (JIRA) -
Yossi Tamari (JIRA)