[teiid-designer-issues] [JBoss JIRA] (TEIIDDES-2554) Import of REST service with columns set to 'integer' type results in "Expected biginteger, but was integer."

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 Labels: release_notes, verified_jbdsis-8.0.4.CR1 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.