[teiid-issues] [JBoss JIRA] Created: (TEIID-1767) Hibernate Month Date Extraction
Johnathon Lee (JIRA)
jira-events at lists.jboss.org
Mon Oct 3 14:23:26 EDT 2011
Hibernate Month Date Extraction
-------------------------------
Key: TEIID-1767
URL: https://issues.jboss.org/browse/TEIID-1767
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 7.1.1
Reporter: Johnathon Lee
Assignee: Steven Hawkins
Fix For: 7.4.1, 7.6
When using teiid-hibernate-dialect-7.1.1.GA, the TeiidDialect does not include a function to get the month value of a date object. It includes functions to get other date attributes (year, dayofmonth etc). Without a defined function, attempting to get a month value falls back on the hibernate-core function which attempts to utilize an extract method which is not supported in 7.1.1.
Example Query: select d from Data d where month(d.date)='09'
HQL Generated:
select
data0_.Id as Id25_,
data0_.DataAmt as DataAmt25_,
data0_.Data as Data25_,
from
Data data0_
where
extract(month
from
data0_.date)='09'
Being able to obtain a month value from a date is a critical requirement.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
More information about the teiid-issues
mailing list