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

Thursday, 8 September 2016

    [
https://issues.jboss.org/browse/TEIID-4427?page=com.atlassian.jira.plugin...
] 

Mark Tawk commented on TEIID-4427:
----------------------------------

My materialized view is on Oracle:
The case is only reproducible on Oracle and when using date functions like *year*,
*month*, *TIMESTAMPDIFF*,...
The materialized view is successfully populated with data.
The data type of the corresponding column in Oracle materialized view is *Number(10)*
When fetching the view the exception is raised

CREATE TABLE G1(e1 NUMBER(10), e2 VARCHAR2 (255));
CREATE VIEW G2 OPTIONS (MATERIALIZED 'true', MATERIALIZED_TABLE 'pm1.G1')
AS SELECT *month(CURDATE())* as e1, e2 FROM pm1.G1;

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

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

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