Bug 1318434 - OData - Math functions floor and ceiling doesn't accept number as parameter
Summary: OData - Math functions floor and ceiling doesn't accept number as parameter
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: JBoss Data Virtualization 6
Classification: JBoss
Component: Teiid
Version: 6.3.0
Hardware: Unspecified
OS: Unspecified
unspecified
unspecified
Target Milestone: ER2
: 6.3.0
Assignee: Van Halbert
QA Contact: Juraj Duráni
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2016-03-16 21:18 UTC by Michal Sanitrak
Modified: 2016-08-24 11:36 UTC (History)
7 users (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2016-08-24 11:36:53 UTC
Type: Bug


Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
Red Hat Issue Tracker TEIID-4086 0 Major Resolved OData - Math functions floor and ceiling doesn't accept number as parameter 2016-06-20 10:30:25 UTC

Description Michal Sanitrak 2016-03-16 21:18:34 UTC
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=EmployeeID%20eq%20floor(4.2)
Result: Employee with ID 4

ULR: http://localhost:8080/odata4/olingo_basic/Source/SimpleTableView/?$filter=intkey%20eq%20floor(4.2)
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=intkey%20eq%20ceiling(4.2)
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-url-conventions/odata-v4.0-errata02-os-part2-url-conventions-complete.html#_Toc406398142

Comment 1 JBoss JIRA Server 2016-03-18 19:20:51 UTC
Ramesh Reddy <rareddy> updated the status of jira TEIID-4086 to Coding In Progress

Comment 2 JBoss JIRA Server 2016-03-18 19:30:38 UTC
Ramesh Reddy <rareddy> updated the status of jira TEIID-4086 to Resolved


Note You need to log in before you can comment on or make changes to this bug.