]
Ted Jones resolved TEIIDDES-2554.
---------------------------------
Resolution: Done
This was also an issue with the SOAP importer. We have deprecated the design-time
"integer" data type in Designer. I have made the following changes:
For SOAP, if an element type is "integer", it will be converted to
"biginteger". The "integer" type will not display in the datatype
dropdown of the column editor.
For REST, the "integer" type will not display in the datatype dropdown of the
column editor.
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
Components: Import/Export, Web Services Support
Affects Versions: 9.0.1
Reporter: Marc Shirley
Assignee: Ted Jones
Fix For: 9.0.4, 9.2
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.