Marc Shirley created TEIIDDES-2554:
--------------------------------------
Summary: Import of REST service with columns set to 'integer' type
results in "Expected biginteger, but was integer."
Key: TEIIDDES-2554
URL:
https://issues.jboss.org/browse/TEIIDDES-2554
Project: Teiid Designer
Issue Type: Bug
Affects Versions: 9.0.1
Reporter: Marc Shirley
Importing posts service from
http://jsonplaceholder.typicode.com results in "Expected
biginteger, but was integer." runtime error when previewing procedure. This appears
to be an issue with the type assignments on the model as a dynamic VDB using the same
invocation executes properly. Also seems similar to the issue described in
TEIIDDES-2438.
Full error is:
org.teiid.runtime.client.TeiidClientException: java.lang.RuntimeException: Remote
org.teiid.api.exception.query.QueryPlannerException: TEIID30492 TEIID31121 The expected
result set of the procedure ViewModel.postById does not match the result set from
returnable statement SELECT A.id AS id, A.userId AS userId, A.title AS title, A.body AS
body FROM (EXEC SourceModel.invokeHttp(action => 'GET', endpoint =>
VARIABLES.qp, stream => 'TRUE')) AS f, XMLTABLE('/response' PASSING
JSONTOXML('response', f.result) COLUMNS id integer PATH 'id/text()',
userId integer PATH 'userId/text()', title string PATH 'title/text()',
body string PATH 'body/text()') AS A; use WITHOUT RETURN to indicate the statement
should not be returned - The definition for ViewModel.postById has the wrong type for
column 1. Expected biginteger, but was integer.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)