[teiid-issues] [JBoss JIRA] (TEIID-4427) Migration to Teiid 9.0.0 - Materialized views error: Expected integer, but was bigdecimal

[Steven Hawkins (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-4427?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13290873#comment-13290873 ] 

Steven Hawkins commented on TEIID-4427:
---------------------------------------

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

If it can't be posted, would it be possible to just provide the parts that are relevant to the oracle source - how is the translator configured in your source and what import options/ddl is being used in the vdb.xml or ModelMetaData.

> 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.

Good - that does confirm things are working as expected when the types match.

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

It would be good to know what is the difference yes.


> 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.



--
This message was sent by Atlassian JIRA
(v6.4.11#64026)