[ https://issues.jboss.org/browse/TEIID-4427?page=com.atlassian.jira.plugin... ] Mark Tawk updated TEIID-4427: ----------------------------- Description: 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. was: 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", 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. -- This message was sent by Atlassian JIRA (v6.4.11#64026)