[JBoss JIRA] (TEIIDDES-2634) filter on child table not working
by Prashanthi Kairuppala (JIRA)
Prashanthi Kairuppala created TEIIDDES-2634:
-----------------------------------------------
Summary: filter on child table not working
Key: TEIIDDES-2634
URL: https://issues.jboss.org/browse/TEIIDDES-2634
Project: Teiid Designer
Issue Type: Bug
Reporter: Prashanthi Kairuppala
Priority: Critical
Attachments: parent_childTables.PNG
Please find the screenshot attached which has id as a foreign key. when i give the url - //localhost:8080/odata/testVDB/sales('13')/sales_uk?$format=json, i get the results from sales_uk table which are having id=13.
Now i am trying to apply a filter on this url, i am supposed to get results which are having id=13 and satisfy the filter condition, but this url blindly returns me data from sales_uk table which satisfy the filter condition. URL- //localhost:8080/odata/testVDB/sales('13')/sales_uk?$format=json&$filter=DISCOUNT eq '22'
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
8 years, 9 months
[JBoss JIRA] (TEIIDDES-2554) Import of REST service with columns set to 'integer' type results in "Expected biginteger, but was integer."
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2554?page=com.atlassian.jira.plu... ]
Barry LaFond updated TEIIDDES-2554:
-----------------------------------
Fix Version/s: 9.2
> 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
> 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.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
8 years, 9 months