[teiid-issues] [JBoss JIRA] (TEIID-1764) Hibernate Month Date Extraction

Hibernate Month Date Extraction ------------------------------- Key: TEIID-1764 URL: https://issues.jboss.org/browse/TEIID-1764 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 7.1.1 Reporter: Andrew Block Assignee: Steven Hawkins Labels: date, hibernate, month, query, teiid 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.