[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=13290683#comment-13290683 ] 

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

> The materialized views fetched perfectly with teiid 8.11.3, once we migrated to 9.0.0, we start having this issue. We went back to 8.11.3 the issue is no longer reproduced.

There are still a few details that are missing here.  It matters how the Teiid metadata for the Oracle materialization table is defined.  Can you provide the Teiid DDL (not the Oracle DDL) for the Oracle source schema and how it was created (such as providing the vdb.xml)?  Somehow you are saying that in 8.11.3 the source table is being defined in Teiid like:

CREATE FOREIGN TABLE G1(e1 integer, e2 varchar);

But in 9.0+ as:

CREATE FOREIGN TABLE G1(e1 bigdecimal, e2 varchar);

> if you are saying NUMBER(10) in Oracle represents bigdecimal or long. What is the oracle datatype expected for Integer in this case?

There isn't one directly as Oracle does not have an integral type.  I'm saying that with the Teiid Oracle importer and the property importer.useIntegralTypes=true NUMBER(9) will be imported as the Teiid integer type - but it's not clear to me yet what import mechanism you are using. 

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