[JBoss JIRA] (TEIID-4427) Migration to Teiid 9.0.0 - Materialized views error: Expected integer, but was bigdecimal
- First Post
- Replies
- Stats
-
Go to
- ----- 2026 -----
- April
- March
- February
- January
- ----- 2025 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2024 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2023 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2022 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2021 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2020 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2019 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2018 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2017 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2016 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2015 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2014 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2013 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2012 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2011 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2010 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2009 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
[
https://issues.jboss.org/browse/TEIID-4427?page=com.atlassian.jira.plugin...
]
Mark Tawk commented on TEIID-4427:
----------------------------------
i'm counting on ResultSetMetaDataImpl to create the view and stage tables columns data
types; in the case of Aggregate function COUNT, the meta is returning Integer.
Here is the code used in this concern:
....
IntegerStatementImpl stmt = (StatementImpl) conn.createStatement();
ResultSetMetaDataImpl meta = (ResultSetMetaDataImpl) stmt.getResultSet().getMetaData();
for (int j = 1; j <= meta.getColumnCount(); j++) {
int colType = meta.getColumnType(j);
String className = JDBCSQLTypeInfo.getJavaClassName(typeCode);
......
}
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.5
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)
3491
days inactive
3491
days old
0 comments
1 participants
tags (0)
participants (1)
-
Mark Tawk (JIRA)