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.