March 2016 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-4045) OData throws unknown error if $select is applied to expanded entity

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-4045?page=com.atlassian.jira.plugin... ] Ramesh Reddy commented on TEIID-4045: ------------------------------------- I added {code} response = http.newRequest(baseURL + "/northwind/m/z?$expand=FKX($select=a)") .method("GET") .send(); assertEquals(200, response.getStatus()); assertEquals("{\"@odata.context\":\"$metadata#z(FKX(a))\",\"value\":[{\"a\":\"ABCDEFG\",\"b\":\"ABCDEFG\",\"FKX\":{\"a\":\"ABCDEFG\"}}]}", response.getContentAsString()); {code} But I also updated my local Olingo, so not sure if that is due to that. > OData throws unknown error if $select is applied to expanded entity > ------------------------------------------------------------------- > > Key: TEIID-4045 > URL: https://issues.jboss.org/browse/TEIID-4045 > Project: Teiid > Issue Type: Sub-task > Components: OData > Reporter: Juraj Duráni > Assignee: Ramesh Reddy > > *URL:* http://localhost:8080/odata4/olingo_basic/Source/Customers/?$expand=Order... > *Result:* OData Library: An exception without message text was thrown. > *Status code:* 500 -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years

1
0
0 / 0

[JBoss JIRA] (TEIID-4045) OData throws unknown error if $select is applied to expanded entity

by Juraj Duráni (JIRA)

[ https://issues.jboss.org/browse/TEIID-4045?page=com.atlassian.jira.plugin... ] Juraj Duráni commented on TEIID-4045: ------------------------------------- Which unit test do you mean? \[1\] or \[2\]. \[1\] is different query, \[2\] tests only generated SQL query. Seems to me like none of then covers my tested scenario. I am wrong? \[1\] https://github.com/teiid/teiid/blob/master/olingo/src/test/java/org/teiid... \[2\] https://github.com/teiid/teiid/blob/master/olingo/src/test/java/org/teiid... > OData throws unknown error if $select is applied to expanded entity > ------------------------------------------------------------------- > > Key: TEIID-4045 > URL: https://issues.jboss.org/browse/TEIID-4045 > Project: Teiid > Issue Type: Sub-task > Components: OData > Reporter: Juraj Duráni > Assignee: Ramesh Reddy > > *URL:* http://localhost:8080/odata4/olingo_basic/Source/Customers/?$expand=Order... > *Result:* OData Library: An exception without message text was thrown. > *Status code:* 500 -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years

1
0
0 / 0

[JBoss JIRA] (TEIID-4047) OData - $top with negative value return status code 500

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-4047?page=com.atlassian.jira.plugin... ] Ramesh Reddy commented on TEIID-4047: ------------------------------------- You got any utilities to get to the inner exception, or walk the graph? > OData - $top with negative value return status code 500 > ------------------------------------------------------- > > Key: TEIID-4047 > URL: https://issues.jboss.org/browse/TEIID-4047 > Project: Teiid > Issue Type: Sub-task > Components: OData > Reporter: Juraj Duráni > Assignee: Ramesh Reddy > > OData request with query option $top with negative value returns status code 500. The root cause is SQLException. OData service should check passed value and return e.g. 400 instead. > *URL:* http://localhost:8080/odata4/olingo_basic/Source/Customers/?$top=-1 > See http://docs.oasis-open.org/odata/odata/v4.0/errata02/os/complete/part1-pr... -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years

1
0
0 / 0

[JBoss JIRA] (TEIID-4057) OData - if PUT fails, next update request fails because table in DB is still locked

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4057?page=com.atlassian.jira.plugin... ] Work on TEIID-4057 started by Steven Hawkins. --------------------------------------------- > OData - if PUT fails, next update request fails because table in DB is still locked > ----------------------------------------------------------------------------------- > > Key: TEIID-4057 > URL: https://issues.jboss.org/browse/TEIID-4057 > Project: Teiid > Issue Type: Sub-task > Components: OData > Reporter: Juraj Duráni > Assignee: Steven Hawkins > > I can see (from the log) that processing of PUT request is as follows: > # select record from table > # delete record > # parse entity from HTTP request > # insert new record > But if e.g. step 3 fails, Teiid cancels transaction and returns error. In my opinion, parsing of the entity should be the first step (or at least right after select). > What happen here is, that DELETE statement creates transaction and locks the table. But the transaction is not canceled immediately after cancel request \[1\]. This causes that no other query can succeed, because of lock on the table (EAP uses connection pool and does not close connections immediately and therefore open connection has still one transaction in active state). > *Note:* We use H2 database for testing purpose. But I think that this could happen with any DB. Anyway, parsing of the entity should not be performed after delete. > \[1\] > {code:plain} > 09:35:33,937 DEBUG [org.teiid.TRANSPORT] (New I/O worker #1) Channel closed > 09:40:31,430 WARN [com.arjuna.ats.arjuna] (Transaction Reaper) ARJUNA012117: TransactionReaper::check timeout for TX 0:ffff7f000001:113c3cbe:56e131a7:e in state RUN > 09:40:31,438 WARN [com.arjuna.ats.arjuna] (Transaction Reaper Worker 0) ARJUNA012121: TransactionReaper::doCancellations worker Thread[Transaction Reaper Worker 0,5,main] successfully canceled TX 0:ffff7f000001:113c3cbe:56e131a7:e > {code} -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years

1
0
0 / 0

[JBoss JIRA] (TEIID-4040) Representation of OData error does not contain error code.

by Juraj Duráni (JIRA)

[ https://issues.jboss.org/browse/TEIID-4040?page=com.atlassian.jira.plugin... ] Juraj Duráni updated TEIID-4040: -------------------------------- Summary: Representation of OData error does not contain error code. (was: JSON representation of OData error does not contain error code.) > Representation of OData error does not contain error code. > ---------------------------------------------------------- > > Key: TEIID-4040 > URL: https://issues.jboss.org/browse/TEIID-4040 > Project: Teiid > Issue Type: Sub-task > Components: OData > Reporter: Juraj Duráni > Assignee: Ramesh Reddy > > JSON: > *URL:* http://localhost:8080/odata4/olingo_basic/Source/SimpleTableView/?$filter... > *Actual result:* \{"error":\{"code":null,"message":"TEIID30492 Non-comparable expression of type object cannot be used in comparison: g4.clobval = ?."\}\} > *Expected result:* "code":30492 > XML (in this case OData returns HTTP status code instead of error code): > *URL:* http://localhost:8080/odata4/olingo_basic/Source/SimpleTableView/?$filter... > *Result:* > {code:xml} > <error> > <code>500</code> > <message>TEIID30492 Non-comparable expression of type object cannot be used in comparison: g1.clobval = ?.</message> > </error> > {code} > *Expected result:* > {code:xml}<code>:30492</code>{code} -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years

1
0
0 / 0

[JBoss JIRA] (TEIID-4040) JSON representation of OData error does not contain error code.

by Juraj Duráni (JIRA)

[ https://issues.jboss.org/browse/TEIID-4040?page=com.atlassian.jira.plugin... ] Juraj Duráni updated TEIID-4040: -------------------------------- Description: JSON: *URL:* http://localhost:8080/odata4/olingo_basic/Source/SimpleTableView/?$filter... *Actual result:* \{"error":\{"code":null,"message":"TEIID30492 Non-comparable expression of type object cannot be used in comparison: g4.clobval = ?."\}\} *Expected result:* "code":30492 XML (in this case OData returns HTTP status code instead of error code): *URL:* http://localhost:8080/odata4/olingo_basic/Source/SimpleTableView/?$filter... *Result:* {code:xml} <error> <code>500</code> <message>TEIID30492 Non-comparable expression of type object cannot be used in comparison: g1.clobval = ?.</message> </error> {code} *Expected result:* {code:xml}<code>:30492</code>{code} was: JSON: *URL:* http://localhost:8080/odata4/olingo_basic/Source/SimpleTableView/?$filter... *Actual result:* \{"error":\{"code":null,"message":"TEIID30492 Non-comparable expression of type object cannot be used in comparison: g4.clobval = ?."\}\} *Expected result:* "code":30492 XML: > JSON representation of OData error does not contain error code. > --------------------------------------------------------------- > > Key: TEIID-4040 > URL: https://issues.jboss.org/browse/TEIID-4040 > Project: Teiid > Issue Type: Sub-task > Components: OData > Reporter: Juraj Duráni > Assignee: Ramesh Reddy > > JSON: > *URL:* http://localhost:8080/odata4/olingo_basic/Source/SimpleTableView/?$filter... > *Actual result:* \{"error":\{"code":null,"message":"TEIID30492 Non-comparable expression of type object cannot be used in comparison: g4.clobval = ?."\}\} > *Expected result:* "code":30492 > XML (in this case OData returns HTTP status code instead of error code): > *URL:* http://localhost:8080/odata4/olingo_basic/Source/SimpleTableView/?$filter... > *Result:* > {code:xml} > <error> > <code>500</code> > <message>TEIID30492 Non-comparable expression of type object cannot be used in comparison: g1.clobval = ?.</message> > </error> > {code} > *Expected result:* > {code:xml}<code>:30492</code>{code} -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years

1
0
0 / 0

[JBoss JIRA] (TEIID-4073) OData filters should accept boolean expressions

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4073?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-4073. ----------------------------------- Resolution: Done Updated the logic to handle any expression. > OData filters should accept boolean expressions > ----------------------------------------------- > > Key: TEIID-4073 > URL: https://issues.jboss.org/browse/TEIID-4073 > Project: Teiid > Issue Type: Bug > Components: OData > Affects Versions: 8.11 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 9.0, 8.12.5 > > > With an expression such as $filter=true we will throw a class cast, since the logic expects a Criteria and not a general Expression. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years

1
0
0 / 0

[JBoss JIRA] (TEIID-4040) JSON representation of OData error does not contain error code.

by Juraj Duráni (JIRA)

[ https://issues.jboss.org/browse/TEIID-4040?page=com.atlassian.jira.plugin... ] Juraj Duráni updated TEIID-4040: -------------------------------- Description: JSON: *URL:* http://localhost:8080/odata4/olingo_basic/Source/SimpleTableView/?$filter... *Actual result:* \{"error":\{"code":null,"message":"TEIID30492 Non-comparable expression of type object cannot be used in comparison: g4.clobval = ?."\}\} *Expected result:* "code":30492 XML: was: *URL:* http://localhost:8080/odata4/olingo_basic/Source/SimpleTableView/?$filter... *Actual result:* \{"error":\{"code":null,"message":"TEIID30492 Non-comparable expression of type object cannot be used in comparison: g4.clobval = ?."\}\} *Expected result:* "code":500 > JSON representation of OData error does not contain error code. > --------------------------------------------------------------- > > Key: TEIID-4040 > URL: https://issues.jboss.org/browse/TEIID-4040 > Project: Teiid > Issue Type: Sub-task > Components: OData > Reporter: Juraj Duráni > Assignee: Ramesh Reddy > > JSON: > *URL:* http://localhost:8080/odata4/olingo_basic/Source/SimpleTableView/?$filter... > *Actual result:* \{"error":\{"code":null,"message":"TEIID30492 Non-comparable expression of type object cannot be used in comparison: g4.clobval = ?."\}\} > *Expected result:* "code":30492 > XML: -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years

1
0
0 / 0

[JBoss JIRA] (TEIID-4073) OData filters should accept boolean expressions

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4073?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-4073: --------------------------------------- It's just an example. It could just as easily be $filter=booleanColumn In either case the old logic was throwing a class cast. What we want is for the boolean to be used as the filter. > OData filters should accept boolean expressions > ----------------------------------------------- > > Key: TEIID-4073 > URL: https://issues.jboss.org/browse/TEIID-4073 > Project: Teiid > Issue Type: Bug > Components: OData > Affects Versions: 8.11 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 9.0, 8.12.5 > > > With an expression such as $filter=true we will throw a class cast, since the logic expects a Criteria and not a general Expression. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years

1
0
0 / 0

[JBoss JIRA] (TEIID-4040) JSON representation of OData error does not contain error code.

by Juraj Duráni (JIRA)

[ https://issues.jboss.org/browse/TEIID-4040?page=com.atlassian.jira.plugin... ] Juraj Duráni updated TEIID-4040: -------------------------------- Summary: JSON representation of OData error does not contain error code. (was: JSON representation of OData error does not contain status code.) > JSON representation of OData error does not contain error code. > --------------------------------------------------------------- > > Key: TEIID-4040 > URL: https://issues.jboss.org/browse/TEIID-4040 > Project: Teiid > Issue Type: Sub-task > Components: OData > Reporter: Juraj Duráni > Assignee: Ramesh Reddy > > *URL:* http://localhost:8080/odata4/olingo_basic/Source/SimpleTableView/?$filter... > *Actual result:* \{"error":\{"code":null,"message":"TEIID30492 Non-comparable expression of type object cannot be used in comparison: g4.clobval = ?."\}\} > *Expected result:* "code":500 -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years

1
0
0 / 0

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues March 2016