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

[RH Bugzilla Integration (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-4086?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13283393#comment-13283393 ] 

RH Bugzilla Integration commented on TEIID-4086:
------------------------------------------------

Filip Elias <felias at redhat.com> changed the Status of [bug 1318434|https://bugzilla.redhat.com/show_bug.cgi?id=1318434] from VERIFIED to CLOSED

> 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
>              Labels: Alpha3
>             Fix For: 9.0, 8.12.5
>
>
> 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



--
This message was sent by Atlassian JIRA
(v6.4.11#64026)