April 2016 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-4064) OData - missing non-nullable property

by Juraj Duráni (JIRA)

[ https://issues.jboss.org/browse/TEIID-4064?page=com.atlassian.jira.plugin... ] Juraj Duráni commented on TEIID-4064: ------------------------------------- I have tried to run test again. Issue seems to be resolved (same with TEIID-4044). > OData - missing non-nullable property > ------------------------------------- > > Key: TEIID-4064 > URL: https://issues.jboss.org/browse/TEIID-4064 > Project: Teiid > Issue Type: Sub-task > Components: OData > Reporter: Juraj Duráni > Assignee: Ramesh Reddy > Labels: Alpha3 > Fix For: 9.0, 8.12.5 > > > Change DDL for tables Customer and Orders in VDB as follows: > {code:sql} > CREATE FOREIGN TABLE Customers ( > id integer PRIMARY KEY OPTIONS (NAMEINSOURCE 'id'), > name varchar(10)) OPTIONS (NAMEINSOURCE 'DB.PUBLIC.CUSTOMERS'); > CREATE FOREIGN TABLE Orders ( > id integer PRIMARY KEY OPTIONS (NAMEINSOURCE 'id'), > customerid integer, > place varchar(10), > FOREIGN KEY (customerid) REFERENCES Customers(id)) OPTIONS (NAMEINSOURCE 'DB.PUBLIC.ORDERS'); > {code} > Note, that both tables have same name of primary key named "id". > Invoke GET method to URL http://localhost:8080/odata4/olingo_basic/Source/Customers/?$count=true&$... > *Result:* > {code:xml} > <error> > <code>400</code> > <message>The non-nullable property 'id' is missing.</message> > </error> > {code} > Here are selected part of Teiid's log: > *Query:* > {code:sql} > SELECT g10.id, g10.name, g11.id, g11.customerid, g11.place FROM Source.Customers AS g10 LEFT OUTER JOIN Source.Orders AS g11 ON g10.id = g11.customerid ORDER BY g10.id > {code} > *Result:* > |id|name|id|customerid|place| > |1|customer1|1|1|town| > |1|customer1|2|1|state| > |1|customer1|3|1|country| > |1|customer1|4|1|abroad| > |2|customer2|5|2|state| > |2|customer2|6|2|country| > |3|customer3|7|3|town| > |3|customer3|8|3|town| > |4|customer4|<null>|<null>|<null>| -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4042) OData returns status code 200 instead of 204 if there are no expanded entities

by Juraj Duráni (JIRA)

[ https://issues.jboss.org/browse/TEIID-4042?page=com.atlassian.jira.plugin... ] Juraj Duráni commented on TEIID-4042: ------------------------------------- I missed that one. I will update test. You can close this issue. > OData returns status code 200 instead of 204 if there are no expanded entities > ------------------------------------------------------------------------------- > > Key: TEIID-4042 > URL: https://issues.jboss.org/browse/TEIID-4042 > Project: Teiid > Issue Type: Sub-task > Components: OData > Reporter: Juraj Duráni > Assignee: Ramesh Reddy > Fix For: 9.0, 8.12.5 > > > *URL:* http://localhost:8080/odata4/olingo_basic/Source/Customers(4)/Orders_FK0 > *Returned status code:* 200 > *Expected:* 204 and empty body > 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)

9 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4054) OData - creation of entity (POST) returns exception (status code 500)

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-4054?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-4054: ------------------------------------------------ Van Halbert <vhalbert(a)redhat.com> changed the Status of [bug 1316490|https://bugzilla.redhat.com/show_bug.cgi?id=1316490] from ASSIGNED to MODIFIED > OData - creation of entity (POST) returns exception (status code 500) > --------------------------------------------------------------------- > > Key: TEIID-4054 > URL: https://issues.jboss.org/browse/TEIID-4054 > Project: Teiid > Issue Type: Sub-task > Components: OData > Reporter: Juraj Duráni > Assignee: Ramesh Reddy > Labels: alpha3 > Fix For: 9.0, 8.12.5 > > > Creation of entity returns exception \[1\]. Representation of entity \[2\]. Http request \[3\]. Header \[4\]. Same exception with of JSON format. > \[1\] > {code:plain} > TEIID10076 Invalid conversion from type class java.lang.Object with value 'java.util.GregorianCalendar[time=4000,areFieldsSet=true,areAllFieldsSet=true, > lenient=true,zone=sun.util.calendar.ZoneInfo[id="GMT",offset=0,dstSavings=0,useDaylight=false,transitions=0,lastRule=null],f > irstDayOfWeek=2,minimalDaysInFirstWeek=4,ERA=1,YEAR=1970,MONTH=0,WEEK_OF_YEAR=1, > WEEK_OF_MONTH=1,DAY_OF_MONTH=1,DAY_OF_YEAR=1,DAY_OF_WEEK=5,DAY_OF_WEEK_IN_MONTH=1, > AM_PM=0,HOUR=0,HOUR_OF_DAY=0,MINUTE=0,SECOND=4,MILLISECOND=0,ZONE_OFFSET=0,DST_OFFSET=0]' > to type class java.sql.Time > {code} > \[2\] > {code:xml} > <?xml version="1.0" encoding="UTF-8"?> > <entry xmlns="http://www.w3.org/2005/Atom" xmlns:d="http://docs.oasis-open.org/odata/ns/data" xmlns:georss="http://www.georss.org/georss" xmlns:gml="http://www.opengis.net/gml" xmlns:m="http://docs.oasis-open.org/odata/ns/metadata"> > <category scheme="http://docs.oasis-open.org/odata/ns/scheme" /> > <content type="application/xml"> > <m:properties> > <d:intkey m:type="Int32">4</d:intkey> > <d:intnum m:type="Int32">4</d:intnum> > <d:stringkey>4</d:stringkey> > <d:stringval>value_4</d:stringval> > <d:booleanval m:type="Boolean">false</d:booleanval> > <d:decimalval m:type="Double">-20.4</d:decimalval> > <d:timeval m:type="TimeOfDay">00:00:04</d:timeval> > <d:dateval m:type="Date">2004-04-04</d:dateval> > <d:timestampval m:type="DateTimeOffset">2004-01-01T00:00:04Z</d:timestampval> > <d:clobval m:type="Binary">Y2xvYl92YWx1ZV8wMDAwNA==</d:clobval> > </m:properties> > </content> > </entry> > {code} > \[3\] > POST http://localhost:8080/odata4/olingo_basic/Source/PostTable(4) > \[4\] > Content-type: application/xml -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4156) Odata - incorrect count with query option $count=true

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-4156?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-4156: ------------------------------------------------ Van Halbert <vhalbert(a)redhat.com> changed the Status of [bug 1329140|https://bugzilla.redhat.com/show_bug.cgi?id=1329140] from NEW to MODIFIED > Odata - incorrect count with query option $count=true > ----------------------------------------------------- > > Key: TEIID-4156 > URL: https://issues.jboss.org/browse/TEIID-4156 > Project: Teiid > Issue Type: Sub-task > Components: OData > Affects Versions: 8.12.x > Reporter: Juraj Duráni > Assignee: Ramesh Reddy > Fix For: 9.0, 8.12.5 > > > HTTP: GET http://localhost:8080/odata4/olingo_basic/Source/SimpleTableView?$count=t... lt 5 > Header: Prefer: odata.maxpagesize=2 > Actual result: <m:count>3</m:count> > Expected result: <m:count>4</m:count> > Additional note: Teiid returns 2 entities. > ---------------------------- > HTTP: GET http://localhost:8080/odata4/olingo_basic/Source/SimpleTableView?$count=true > Header: Prefer: odata.maxpagesize=10 > Actual result: <m:count>10</m:count> > Expected result: <m:count>11</m:count> > ---------------------------- > Moreover, when I invoke another request for next results (including skiptoken), Teiid returns different count. > HTTP: GET http://localhost:8080/odata4/olingo_basic/Source/SimpleTableView?$count=t... > Actual result: <m:count>1</m:count> > Expected result: <m:count>11</m:count> > ---------------------------- > HTTP: GET http://localhost:8080/odata4/olingo_basic/Source/SimpleTableView?$count=t... > Actual result: <m:count>10</m:count> > Expected result: <m:count>11</m:count> > Additional note: Teiid returns 5 entities. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4143) Wrong Content-Type in error response from odata

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-4143?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-4143: ------------------------------------------------ Van Halbert <vhalbert(a)redhat.com> changed the Status of [bug 1327539|https://bugzilla.redhat.com/show_bug.cgi?id=1327539] from NEW to MODIFIED > Wrong Content-Type in error response from odata > ----------------------------------------------- > > Key: TEIID-4143 > URL: https://issues.jboss.org/browse/TEIID-4143 > Project: Teiid > Issue Type: Sub-task > Components: OData > Affects Versions: 8.12.x > Reporter: Andrej Šmigala > Assignee: Ramesh Reddy > Priority: Blocker > Fix For: 9.0, 8.12.5 > > > When submitting an odata request that causes an error on server side, the response has the Content-Type header set to just "application", which causes clients to fail. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4054) OData - creation of entity (POST) returns exception (status code 500)

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-4054?page=com.atlassian.jira.plugin... ] Ramesh Reddy resolved TEIID-4054. --------------------------------- Resolution: Done Previously I was treating the non existence of "Perfer: return=xxx" as "return=minimal" with minor modification about not having odata-entityid which was wrong. Corrected now upstream. > OData - creation of entity (POST) returns exception (status code 500) > --------------------------------------------------------------------- > > Key: TEIID-4054 > URL: https://issues.jboss.org/browse/TEIID-4054 > Project: Teiid > Issue Type: Sub-task > Components: OData > Reporter: Juraj Duráni > Assignee: Ramesh Reddy > Labels: alpha3 > Fix For: 9.0, 8.12.5 > > > Creation of entity returns exception \[1\]. Representation of entity \[2\]. Http request \[3\]. Header \[4\]. Same exception with of JSON format. > \[1\] > {code:plain} > TEIID10076 Invalid conversion from type class java.lang.Object with value 'java.util.GregorianCalendar[time=4000,areFieldsSet=true,areAllFieldsSet=true, > lenient=true,zone=sun.util.calendar.ZoneInfo[id="GMT",offset=0,dstSavings=0,useDaylight=false,transitions=0,lastRule=null],f > irstDayOfWeek=2,minimalDaysInFirstWeek=4,ERA=1,YEAR=1970,MONTH=0,WEEK_OF_YEAR=1, > WEEK_OF_MONTH=1,DAY_OF_MONTH=1,DAY_OF_YEAR=1,DAY_OF_WEEK=5,DAY_OF_WEEK_IN_MONTH=1, > AM_PM=0,HOUR=0,HOUR_OF_DAY=0,MINUTE=0,SECOND=4,MILLISECOND=0,ZONE_OFFSET=0,DST_OFFSET=0]' > to type class java.sql.Time > {code} > \[2\] > {code:xml} > <?xml version="1.0" encoding="UTF-8"?> > <entry xmlns="http://www.w3.org/2005/Atom" xmlns:d="http://docs.oasis-open.org/odata/ns/data" xmlns:georss="http://www.georss.org/georss" xmlns:gml="http://www.opengis.net/gml" xmlns:m="http://docs.oasis-open.org/odata/ns/metadata"> > <category scheme="http://docs.oasis-open.org/odata/ns/scheme" /> > <content type="application/xml"> > <m:properties> > <d:intkey m:type="Int32">4</d:intkey> > <d:intnum m:type="Int32">4</d:intnum> > <d:stringkey>4</d:stringkey> > <d:stringval>value_4</d:stringval> > <d:booleanval m:type="Boolean">false</d:booleanval> > <d:decimalval m:type="Double">-20.4</d:decimalval> > <d:timeval m:type="TimeOfDay">00:00:04</d:timeval> > <d:dateval m:type="Date">2004-04-04</d:dateval> > <d:timestampval m:type="DateTimeOffset">2004-01-01T00:00:04Z</d:timestampval> > <d:clobval m:type="Binary">Y2xvYl92YWx1ZV8wMDAwNA==</d:clobval> > </m:properties> > </content> > </entry> > {code} > \[3\] > POST http://localhost:8080/odata4/olingo_basic/Source/PostTable(4) > \[4\] > Content-type: application/xml -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4156) Odata - incorrect count with query option $count=true

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-4156?page=com.atlassian.jira.plugin... ] Ramesh Reddy resolved TEIID-4156. --------------------------------- Fix Version/s: 9.0 8.12.5 Resolution: Done > Odata - incorrect count with query option $count=true > ----------------------------------------------------- > > Key: TEIID-4156 > URL: https://issues.jboss.org/browse/TEIID-4156 > Project: Teiid > Issue Type: Sub-task > Components: OData > Affects Versions: 8.12.x > Reporter: Juraj Duráni > Assignee: Ramesh Reddy > Fix For: 9.0, 8.12.5 > > > HTTP: GET http://localhost:8080/odata4/olingo_basic/Source/SimpleTableView?$count=t... lt 5 > Header: Prefer: odata.maxpagesize=2 > Actual result: <m:count>3</m:count> > Expected result: <m:count>4</m:count> > Additional note: Teiid returns 2 entities. > ---------------------------- > HTTP: GET http://localhost:8080/odata4/olingo_basic/Source/SimpleTableView?$count=true > Header: Prefer: odata.maxpagesize=10 > Actual result: <m:count>10</m:count> > Expected result: <m:count>11</m:count> > ---------------------------- > Moreover, when I invoke another request for next results (including skiptoken), Teiid returns different count. > HTTP: GET http://localhost:8080/odata4/olingo_basic/Source/SimpleTableView?$count=t... > Actual result: <m:count>1</m:count> > Expected result: <m:count>11</m:count> > ---------------------------- > HTTP: GET http://localhost:8080/odata4/olingo_basic/Source/SimpleTableView?$count=t... > Actual result: <m:count>10</m:count> > Expected result: <m:count>11</m:count> > Additional note: Teiid returns 5 entities. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3932) Upgrade the Olingo library to 4.2.0

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-3932?page=com.atlassian.jira.plugin... ] Ramesh Reddy resolved TEIID-3932. --------------------------------- Resolution: Done Updated to a version based 4.2.0 > Upgrade the Olingo library to 4.2.0 > ----------------------------------- > > Key: TEIID-3932 > URL: https://issues.jboss.org/browse/TEIID-3932 > Project: Teiid > Issue Type: Task > Components: OData > Reporter: Ramesh Reddy > Assignee: Ramesh Reddy > Fix For: 9.0, 8.12.5 > > > Upgrade the Olingo library to 4.2.0, this will also be used as bucket to all the related issues, patches that needs to be removed when the library is upgraded to 4.2.0 -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4143) Wrong Content-Type in error response from odata

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-4143?page=com.atlassian.jira.plugin... ] Ramesh Reddy resolved TEIID-4143. --------------------------------- Fix Version/s: 9.0 Resolution: Done Corrected in upstream Olingo > Wrong Content-Type in error response from odata > ----------------------------------------------- > > Key: TEIID-4143 > URL: https://issues.jboss.org/browse/TEIID-4143 > Project: Teiid > Issue Type: Sub-task > Components: OData > Affects Versions: 8.12.x > Reporter: Andrej Šmigala > Assignee: Ramesh Reddy > Priority: Blocker > Fix For: 9.0, 8.12.5 > > > When submitting an odata request that causes an error on server side, the response has the Content-Type header set to just "application", which causes clients to fail. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4112) ORA-32039: recursive WITH clause must have column alias list

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4112?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-4112: ---------------------------------- Fix Version/s: 8.12.5 > ORA-32039: recursive WITH clause must have column alias list > ------------------------------------------------------------ > > Key: TEIID-4112 > URL: https://issues.jboss.org/browse/TEIID-4112 > Project: Teiid > Issue Type: Bug > Components: JDBC Connector, Query Engine > Affects Versions: 8.7.2.6_2 > Reporter: Debbie Steigner > Assignee: Steven Hawkins > Fix For: 9.0, 8.12.5 > > > If running a WITH table AS(...) query to Oracle and the query schema name is the same as the subquery name i.e. EWI. you receive the Oracle error: > ORA-32039: recursive WITH clause must have column alias list > If you modify the query to > WITH EWI1 AS .... > then it works. > f.ex: > breaking: WITH tbl AS ( > where tbl = a common table name in the current schema and the common table definition as (...) references a view in that schema. Oracle will complain with this erroneous error. > work-around: WITH tbl_1 AS( > where tbl_1 does not exist as a current schema/table name. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 11 months

1
0
0 / 0

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues April 2016