March 2016 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-4087) OData - Math function round doesn't accept decimal number as parameter

by Michal Sanitrak (JIRA)

Michal Sanitrak created TEIID-4087: -------------------------------------- Summary: OData - Math function round doesn't accept decimal number as parameter Key: TEIID-4087 URL: https://issues.jboss.org/browse/TEIID-4087 Project: Teiid Issue Type: Sub-task Components: OData Reporter: Michal Sanitrak Assignee: Ramesh Reddy Reference service which supports OData V4: *ULR:* http://services.odata.org/V4/Northwind/Northwind.svc/Employees/?$filter=E... *Result:* Employee with ID 4 *URL:* http://localhost:8080/odata4/olingo_basic/Source/SimpleTableView/?$filter... *Actual result:* {"error": {"code": null, "message": "TEIID30558 Error converting parameter number 1 with value \"4,2\" of class java.math.BigDecimal to expected type integer." }} *Expected result:* Entity with intkey 4 -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years

1
0
0 / 0

[JBoss JIRA] (TEIID-4086) OData - Math functions floor and ceiling doesn't accept number as parameter

by Michal Sanitrak (JIRA)

[ https://issues.jboss.org/browse/TEIID-4086?page=com.atlassian.jira.plugin... ] Michal Sanitrak updated TEIID-4086: ----------------------------------- Description: Basic functionality of math functions floor and ceiling works properly as \[1\] describes, but these functions doesn't accept number as parameter. Reference service which supports OData V4: *ULR:* http://services.odata.org/V4/Northwind/Northwind.svc/Employees/?$filter=E... *Result:* Employee with ID 4 *ULR:* http://localhost:8080/odata4/olingo_basic/Source/SimpleTableView/?$filter... *Actual result:* {"error":{"code": null, "message": "TEIID30069 The function 'FLOOR(\?)' has more than one possible signature."}} *Expected result:* Entity with intkey 4 *ULR:* http://localhost:8080/odata4/olingo_basic/Source/SimpleTableView/?$filter... *Actual result:* {"error": {"code": null, "message": "TEIID30069 The function 'CEILING(\?)' has more than one possible signature."}} *Expected result:* Entity with intkey 5 See [\[OData-ABNF\]|http://docs.oasis-open.org/odata/odata/v4.0/errata02/os/complete/abnf/odata-abnf-construction-rules.txt] _Line:_ 539 - Math functions accepts _commonExpr_ \[1\] http://docs.oasis-open.org/odata/odata/v4.0/errata02/os/complete/part2-ur... was: Basic functionality of math functions floor and ceiling works properly as \[1\] describes, but these functions doesn't accept number as parameter. Reference service which supports OData V4: *ULR:* http://services.odata.org/V4/Northwind/Northwind.svc/Employees/?$filter=E... *Result:* Employee with ID 4 *ULR:* http://localhost:8080/odata4/olingo_basic/Source/SimpleTableView/?$filter... *Actual result:* {"error":{"code": null, "message": "TEIID30069 The function 'FLOOR(\?)' has more than one possible signature."}} *Expected result:* Entity with intkey 4 *ULR:* http://localhost:8080/odata4/olingo_basic/Source/SimpleTableView/?$filter... *Actual result:* {"error": {"code": null, "message": "TEIID30069 The function 'CEILING(\?)' has more than one possible signature."}} *Expected result:* Entity with intkey 5 See [\[OData-ABNF\]|http://docs.oasis-open.org/odata/odata/v4.0/errata02/os/complete/abnf/odata-abnf-construction-rules.txt] _Line:_ 539 - Math functions accepts _commonExpr_ \[1\] http://docs.oasis-open.org/odata/odata/v4.0/errata02/os/complete/part2-ur... > OData - Math functions floor and ceiling doesn't accept number as parameter > --------------------------------------------------------------------------- > > Key: TEIID-4086 > URL: https://issues.jboss.org/browse/TEIID-4086 > Project: Teiid > Issue Type: Sub-task > Components: OData > Reporter: Michal Sanitrak > Assignee: Ramesh Reddy > > Basic functionality of math functions floor and ceiling works properly as \[1\] describes, but these functions doesn't accept number as parameter. > Reference service which supports OData V4: > *ULR:* http://services.odata.org/V4/Northwind/Northwind.svc/Employees/?$filter=E... > *Result:* Employee with ID 4 > *ULR:* http://localhost:8080/odata4/olingo_basic/Source/SimpleTableView/?$filter... > *Actual result:* {"error":{"code": null, "message": "TEIID30069 The function 'FLOOR(\?)' has more than one possible signature."}} > *Expected result:* Entity with intkey 4 > *ULR:* http://localhost:8080/odata4/olingo_basic/Source/SimpleTableView/?$filter... > *Actual result:* {"error": {"code": null, "message": "TEIID30069 The function 'CEILING(\?)' has more than one possible signature."}} > *Expected result:* Entity with intkey 5 > See [\[OData-ABNF\]|http://docs.oasis-open.org/odata/odata/v4.0/errata02/os/complete/abnf/odata-abnf-construction-rules.txt] _Line:_ 539 - Math functions accepts _commonExpr_ > \[1\] http://docs.oasis-open.org/odata/odata/v4.0/errata02/os/complete/part2-ur... -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years

1
0
0 / 0

[JBoss JIRA] (TEIID-4086) OData - Math functions floor and ceiling doesn't accept number as parameter

by Michal Sanitrak (JIRA)

[ https://issues.jboss.org/browse/TEIID-4086?page=com.atlassian.jira.plugin... ] Michal Sanitrak updated TEIID-4086: ----------------------------------- Description: Basic functionality of math functions floor and ceiling works properly as \[1\] describes, but these functions doesn't accept number as parameter. Reference service which supports OData V4: *ULR:* http://services.odata.org/V4/Northwind/Northwind.svc/Employees/?$filter=E... *Result:* Employee with ID 4 *ULR:* http://localhost:8080/odata4/olingo_basic/Source/SimpleTableView/?$filter... *Actual result:* {"error":{"code": null, "message": "TEIID30069 The function 'FLOOR(\?)' has more than one possible signature."}} *Expected result:* Entity with intkey 4 *ULR:* http://localhost:8080/odata4/olingo_basic/Source/SimpleTableView/?$filter... *Actual result:* {"error": {"code": null, "message": "TEIID30069 The function 'CEILING(\?)' has more than one possible signature."}} *Expected result:* Entity with intkey 5 See [\[OData-ABNF\]|http://docs.oasis-open.org/odata/odata/v4.0/errata02/os/complete/abnf/odata-abnf-construction-rules.txt] _Line:_ 539 - Math functions accepts _commonExpr_ \[1\] http://docs.oasis-open.org/odata/odata/v4.0/errata02/os/complete/part2-ur... was: Basic functionality of math functions floor and ceiling works properly as \[1\] describes, but these functions doesn't accept number as parameter. Reference service which supports OData V4: *ULR:* http://services.odata.org/V4/Northwind/Northwind.svc/Employees/?$filter=E... *Result:* Employee with ID 4 *ULR:* http://localhost:8080/odata4/olingo_basic/Source/SimpleTableView/?$filter... *Actual result:* {"error":{"code": null, "message": "TEIID30069 The function 'FLOOR(\?)' has more than one possible signature."}} *Expected result:* Entity with intkey 4 *ULR:* http://localhost:8080/odata4/olingo_basic/Source/SimpleTableView/?$filter... *Actual result:* {"error": {"code": null, "message": "TEIID30069 The function 'CEILING(\?)' has more than one possible signature."}} *Expected result:* Entity with intkey 5 See [\[OData-ABNF\]|http://docs.oasis-open.org/odata/odata/v4.0/errata02/os/complete/abnf/odata-abnf-construction-rules.txt] _Line:_ 539 - Math functions accepts _commonExpr_ \[1\] http://docs.oasis-open.org/odata/odata/v4.0/errata02/os/complete/part2-ur... > OData - Math functions floor and ceiling doesn't accept number as parameter > --------------------------------------------------------------------------- > > Key: TEIID-4086 > URL: https://issues.jboss.org/browse/TEIID-4086 > Project: Teiid > Issue Type: Sub-task > Components: OData > Reporter: Michal Sanitrak > Assignee: Ramesh Reddy > > Basic functionality of math functions floor and ceiling works properly as \[1\] describes, but these functions doesn't accept number as parameter. > Reference service which supports OData V4: > *ULR:* http://services.odata.org/V4/Northwind/Northwind.svc/Employees/?$filter=E... > *Result:* Employee with ID 4 > *ULR:* http://localhost:8080/odata4/olingo_basic/Source/SimpleTableView/?$filter... > *Actual result:* {"error":{"code": null, "message": "TEIID30069 The function 'FLOOR(\?)' has more than one possible signature."}} > *Expected result:* Entity with intkey 4 > *ULR:* http://localhost:8080/odata4/olingo_basic/Source/SimpleTableView/?$filter... > *Actual result:* {"error": {"code": null, "message": "TEIID30069 The function 'CEILING(\?)' has more than one possible signature."}} > *Expected result:* Entity with intkey 5 > See [\[OData-ABNF\]|http://docs.oasis-open.org/odata/odata/v4.0/errata02/os/complete/abnf/odata-abnf-construction-rules.txt] _Line:_ 539 - Math functions accepts _commonExpr_ > \[1\] http://docs.oasis-open.org/odata/odata/v4.0/errata02/os/complete/part2-ur... -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years

1
0
0 / 0

[JBoss JIRA] (TEIID-4086) OData - Math functions floor and ceiling doesn't accept number as parameter

by Michal Sanitrak (JIRA)

[ https://issues.jboss.org/browse/TEIID-4086?page=com.atlassian.jira.plugin... ] Michal Sanitrak updated TEIID-4086: ----------------------------------- Description: Basic functionality of math functions floor and ceiling works properly as \[1\] describes, but these functions doesn't accept number as parameter. Reference service which supports OData V4: *ULR:* http://services.odata.org/V4/Northwind/Northwind.svc/Employees/?$filter=E... *Result:* Employee with ID 4 *ULR:* http://localhost:8080/odata4/olingo_basic/Source/SimpleTableView/?$filter... *Actual result:* {"error":{"code": null, "message": "TEIID30069 The function 'FLOOR(\?)' has more than one possible signature."}} *Expected result:* Entity with intkey 4 *ULR:* http://localhost:8080/odata4/olingo_basic/Source/SimpleTableView/?$filter... *Actual result:* {"error": {"code": null, "message": "TEIID30069 The function 'CEILING(\?)' has more than one possible signature."}} *Expected result:* Entity with intkey 5 See [\[OData-ABNF\]|http://docs.oasis-open.org/odata/odata/v4.0/errata02/os/complete/abnf/odata-abnf-construction-rules.txt] _Line:_ 539 - Math functions accepts _commonExpr_ \[1\] http://docs.oasis-open.org/odata/odata/v4.0/errata02/os/complete/part2-ur... was: Basic functionality of math functions floor and ceiling works properly as \[1\] describes, but these functions doesn't accept number as parameter. Reference service which supports OData V4: *ULR:* http://services.odata.org/V4/Northwind/Northwind.svc/Employees/?$filter=E... *Result:* Employee with ID 4 *ULR:* http://localhost:9080/odata4/olingo_basic/Source/SimpleTableView/?$filter... *Actual result:* {"error":{"code": null, "message": "TEIID30069 The function 'FLOOR(\?)' has more than one possible signature."}} *Expected result:* Entity with intkey 4 *ULR:* http://localhost:8080/odata4/olingo_basic/Source/SimpleTableView/?$filter... *Actual result:* {"error": {"code": null, "message": "TEIID30069 The function 'CEILING(\?)' has more than one possible signature."}} *Expected result:* Entity with intkey 5 See [\[OData-ABNF\]|http://docs.oasis-open.org/odata/odata/v4.0/errata02/os/complete/abnf/odata-abnf-construction-rules.txt] _Line:_ 539 - Math functions accepts _commonExpr_ \[1\] http://docs.oasis-open.org/odata/odata/v4.0/errata02/os/complete/part2-ur... > OData - Math functions floor and ceiling doesn't accept number as parameter > --------------------------------------------------------------------------- > > Key: TEIID-4086 > URL: https://issues.jboss.org/browse/TEIID-4086 > Project: Teiid > Issue Type: Sub-task > Components: OData > Reporter: Michal Sanitrak > Assignee: Ramesh Reddy > > Basic functionality of math functions floor and ceiling works properly as \[1\] describes, but these functions doesn't accept number as parameter. > Reference service which supports OData V4: > *ULR:* http://services.odata.org/V4/Northwind/Northwind.svc/Employees/?$filter=E... > *Result:* Employee with ID 4 > *ULR:* http://localhost:8080/odata4/olingo_basic/Source/SimpleTableView/?$filter... > *Actual result:* {"error":{"code": null, "message": "TEIID30069 The function 'FLOOR(\?)' has more than one possible signature."}} > *Expected result:* Entity with intkey 4 > *ULR:* http://localhost:8080/odata4/olingo_basic/Source/SimpleTableView/?$filter... > *Actual result:* {"error": {"code": null, "message": "TEIID30069 The function 'CEILING(\?)' has more than one possible signature."}} > *Expected result:* Entity with intkey 5 > See [\[OData-ABNF\]|http://docs.oasis-open.org/odata/odata/v4.0/errata02/os/complete/abnf/odata-abnf-construction-rules.txt] _Line:_ 539 - Math functions accepts _commonExpr_ > \[1\] http://docs.oasis-open.org/odata/odata/v4.0/errata02/os/complete/part2-ur... -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years

1
0
0 / 0

[JBoss JIRA] (TEIID-4075) Netezza translator to support common table expressions

by Johnathon Lee (JIRA)

[ https://issues.jboss.org/browse/TEIID-4075?page=com.atlassian.jira.plugin... ] Johnathon Lee updated TEIID-4075: --------------------------------- Fix Version/s: 8.7.5.6_2 > Netezza translator to support common table expressions > ------------------------------------------------------ > > Key: TEIID-4075 > URL: https://issues.jboss.org/browse/TEIID-4075 > Project: Teiid > Issue Type: Enhancement > Components: JDBC Connector > Affects Versions: 8.7.5.6_2 > Reporter: Johnathon Lee > Assignee: Steven Hawkins > Fix For: 9.0, 8.12.5, 8.7.5.6_2, 8.13.3 > > > netezza translator is not marked as supporting common table expressions, but Netezza does support. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years

1
0
0 / 0

[JBoss JIRA] (TEIID-4086) OData - Math functions floor and ceiling doesn't accept number as parameter

by Michal Sanitrak (JIRA)

Michal Sanitrak created TEIID-4086: -------------------------------------- Summary: OData - Math functions floor and ceiling doesn't accept number as parameter Key: TEIID-4086 URL: https://issues.jboss.org/browse/TEIID-4086 Project: Teiid Issue Type: Sub-task Components: OData Reporter: Michal Sanitrak Assignee: Ramesh Reddy Basic functionality of math functions floor and ceiling works properly as \[1\] describes, but these functions doesn't accept number as parameter. Reference service which supports OData V4: *ULR:* http://services.odata.org/V4/Northwind/Northwind.svc/Employees/?$filter=E... *Result:* Employee with ID 4 *ULR:* http://localhost:9080/odata4/olingo_basic/Source/SimpleTableView/?$filter... *Actual result:* {"error":{"code": null, "message": "TEIID30069 The function 'FLOOR(\?)' has more than one possible signature."}} *Expected result:* Entity with intkey 4 *ULR:* http://localhost:8080/odata4/olingo_basic/Source/SimpleTableView/?$filter... *Actual result:* {"error": {"code": null, "message": "TEIID30069 The function 'CEILING(\?)' has more than one possible signature."}} *Expected result:* Entity with intkey 5 See [\[OData-ABNF\]|http://docs.oasis-open.org/odata/odata/v4.0/errata02/os/complete/abnf/odata-abnf-construction-rules.txt] _Line:_ 539 - Math functions accepts _commonExpr_ \[1\] http://docs.oasis-open.org/odata/odata/v4.0/errata02/os/complete/part2-ur... -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years

1
0
0 / 0

[JBoss JIRA] (TEIID-4013) ODBC sessions never release

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4013?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-4013: --------------------------------------- Can you provide the exceptions? Or confirm that they match TEIID-3879? 2016-02-16 08:45:30,140 ERROR [Incoming-1,shared=tcp-teiid-1] org.teiid.replication.jgroups.JGroupsObjectReplicator$ReplicatorRpcDispatcher - exception marshalling object java.lang.IllegalStateException: unread block data at java.io.ObjectInputStream$BlockDataInputStream.setBlockDataMode(ObjectInputStream.java:2421) at java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1382) at java.io.ObjectInputStream.readArray(ObjectInputStream.java:1706) at java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1344) at java.io.ObjectInputStream.readObject(ObjectInputStream.java:370) at org.jgroups.blocks.MethodCall.readExternal(MethodCall.java:430) at java.io.ObjectInputStream.readExternalData(ObjectInputStream.java:1837) at java.io.ObjectInputStream.readOrdinaryObject(ObjectInputStream.java:1796) at java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1350) at java.io.ObjectInputStream.readObject(ObjectInputStream.java:370) at org.teiid.replication.jgroups.JGroupsObjectReplicator$ContextAwareMarshaller.objectFromBuffer(JGroupsObjectReplicator.java:611) at org.teiid.replication.jgroups.JGroupsObjectReplicator$ReplicatorRpcDispatcher.handle(JGroupsObjectReplicator.java:106) at org.jgroups.blocks.RequestCorrelator.handleRequest(RequestCorrelator.java:484) at org.jgroups.blocks.RequestCorrelator.receiveMessage(RequestCorrelator.java:391) > ODBC sessions never release > --------------------------- > > Key: TEIID-4013 > URL: https://issues.jboss.org/browse/TEIID-4013 > Project: Teiid > Issue Type: Bug > Affects Versions: 8.7.1.6_2 > Environment: Red Hat JBoss Data Virtualization 6.2.2 on EAP6.4.0 patched to version 6.4.5, > JBoss Developer Studio 8.1.0GA with Teiid Designer plugin 9.0.3.Final.v20150810-1438-B1157 > 64-bit Windows 7 environment > Reporter: Steve Tran > Assignee: Steven Hawkins > Attachments: Capture.PNG, Capture2.PNG, Capture3.PNG > > > I have 3 ODBC System DSNs on a Windows server. When I'm viewing the Deployed VDBs and looking at the Sessions tab, the ODBC connections never seem to time out or release. Not really sure if/when they should release, but they continue to multiply. See screenshots. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years

1
0
0 / 0

[JBoss JIRA] (TEIID-4041) OData response does not contain header "allow"

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-4041?page=com.atlassian.jira.plugin... ] Ramesh Reddy commented on TEIID-4041: ------------------------------------- Added the upstream change required to the build > OData response does not contain header "allow" > ---------------------------------------------- > > Key: TEIID-4041 > URL: https://issues.jboss.org/browse/TEIID-4041 > Project: Teiid > Issue Type: Sub-task > Components: OData > Reporter: Juraj Duráni > Assignee: Ramesh Reddy > > If user sends request to URL with unsupported HTTP method, OData service should return allowed methods in header _allow_. > *URL:* http://localhost:8080/odata4/olingo_basic/Source/SimpleTableView/ > *Method:* DELETE > *Response headers:* date=Wed, 09 Mar 2016 08:21:17 GMT, server=Apache-Coyote/1.1, content-length=192, expires=Thu, 01 Jan 1970 00:00:00 GMT+00:00, content-type=application/xml, cache-control=no-cache, pragma=No-cache, odata-version=4.0 > 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-4041) OData response does not contain header "allow"

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-4041?page=com.atlassian.jira.plugin... ] Work on TEIID-4041 started by Ramesh Reddy. ------------------------------------------- > OData response does not contain header "allow" > ---------------------------------------------- > > Key: TEIID-4041 > URL: https://issues.jboss.org/browse/TEIID-4041 > Project: Teiid > Issue Type: Sub-task > Components: OData > Reporter: Juraj Duráni > Assignee: Ramesh Reddy > > If user sends request to URL with unsupported HTTP method, OData service should return allowed methods in header _allow_. > *URL:* http://localhost:8080/odata4/olingo_basic/Source/SimpleTableView/ > *Method:* DELETE > *Response headers:* date=Wed, 09 Mar 2016 08:21:17 GMT, server=Apache-Coyote/1.1, content-length=192, expires=Thu, 01 Jan 1970 00:00:00 GMT+00:00, content-type=application/xml, cache-control=no-cache, pragma=No-cache, odata-version=4.0 > 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-4075) Netezza translator to support common table expressions

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4075?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-4075. ----------------------------------- Resolution: Done Marked as supporting common table expressions starting with version 7.0. > Netezza translator to support common table expressions > ------------------------------------------------------ > > Key: TEIID-4075 > URL: https://issues.jboss.org/browse/TEIID-4075 > Project: Teiid > Issue Type: Enhancement > Components: JDBC Connector > Affects Versions: 8.7.5.6_2 > Reporter: Johnathon Lee > Assignee: Steven Hawkins > Fix For: 9.0, 8.12.5, 8.13.3 > > > netezza translator is not marked as supporting common table expressions, but Netezza does support. -- 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