Materialized view - Expected long, but was bigdecimal

[mtawk]

I'm using Teiid 9.0.0 Final

i'm materializing a view on Oracle that contains a column using TIMESTAMPDIFF and the corresponding column in the materialized view is of type NUMBER(10)

The materialization is done successfully and records are written to the view table.

But whenever I fetch the view, i'm getting the error : Error The definition for DbDbTRX2011rfJ190516 has the wrong type for column 3.  Expected long, but was bigdecimal.

I'm only getting this issue with Oracle; when using TIMESTAMPDIFF in views materialized  on Mysql or SQL Server, the fetching is successful.

[shawkins]

The workaround is to change the Teiid source type on the Oracle table representing the materialization from being a bigdecimal to a long to match the view definition.

It may be good to relax some of the type expectations here as it would be allowable to implicitly convert.

[mtawk]

In oracle, we can use only NUMBER data type for the result of the function TIMESTAMPDIFF, I did not get which data type I should use to match the java type Long.

Isn't better to expect sql data type result from TIMESTAMPDIFF in the case of materialized view instead of java Long datatype?

[mtawk]

Now I'm getting the same issue with Oracle when using the date functions Year and Month : Expected integer, but was bigdecimal.

All of the concerned views were working fine with Teiid 8.11.3, once we migrated to the version 9.0.0, we started getting the error.

The concerned columns in the materialized views has the Oracle data type number(10)

[shawkins]

The issue is being caused by the additional validation of [TEIID-3999] more aspects of materialization metadata should be validated - JBoss Issue Tracker

We'll work on https://issues.jboss.org/browse/TEIID-4427 to make things compatible.