I'm using Teiid embedded, what is the way to send you the vdb.xml?

Otherwise, for test sake, in teiid 9.0.0 i have set useIntegralTypes=true and changed the data type of the materialized column month(myfield) to Number(9) and the fetch executed successfully.

Still need to debug in teiid 8.11.3 to see what exactly is the difference?

Migration to Teiid 9.0.0 - Materialized views error: Expected integer, but was bigdecimal ----------------------------------------------------------------------------------------- Key: TEIID-4427 URL: https://issues.jboss.org/browse/TEIID-4427 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 9.0 Reporter: Mark Tawk Assignee: Steven Hawkins Priority: Critical Fix For: 9.1, 9.0.4 After migrating to Teiid 9.0.0, we are facing issues with existing views materialized on Oracle server. when fetching an Oracle materialized view that contains a column using date function like : "Month" or "Year" or "TIMESTAMPDIFF", we are getting the error : Expected integer, but was bigdecimal. If we go back to Teiid 8.11.3, the same materialized views fetch without any problem.