[ https://issues.jboss.org/browse/TEIID-1764?page=com.atlassian.jira.plugin... ] Andrew Block updated TEIID-1764: -------------------------------- Description: 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. was: 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. 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

[ https://issues.jboss.org/browse/TEIID-1764?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-1764. ----------------------------------- Fix Version/s: 7.6 Resolution: Done Added the mapping for month in 7.4.1. Also fixed the mapping for array_get/array_length in 7.4.1 and 7.6. -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira