[teiid-issues] [JBoss JIRA] (TEIID-4103) OData - wrong string indexing in string functions indexof and substring

[Steven Hawkins (JIRA)]

     [ https://issues.jboss.org/browse/TEIID-4103?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steven Hawkins closed TEIID-4103.
---------------------------------


> OData - wrong string indexing in string functions indexof and substring 
> ------------------------------------------------------------------------
>
>                 Key: TEIID-4103
>                 URL: https://issues.jboss.org/browse/TEIID-4103
>             Project: Teiid
>          Issue Type: Sub-task
>          Components: OData
>            Reporter: Michal Sanitrak
>            Assignee: Ramesh Reddy
>              Labels: Alpha3
>             Fix For: 9.0, 8.12.5
>
>
> By documentation \[1\] function indexof returns the zero-based character position of the first occurrence of the second parameter value in the first parameter value. 
> Function substring doens't have explicitly specified indexing, but based on _Example 60_  \[2\] is function substring _zero-based_ too.
> *indexof*
> Reference service which supports OData V4:
> *ULR:* http://services.odata.org/V4/Northwind/Northwind.svc/Customers/?$filter=indexof(CompanyName,'lfreds') eq 1
> *Result:* Customer with CompanyName equals "Alfreds Futterkiste"
> *URL:* http://localhost:8080/odata4/olingo_basic/Source/SimpleDataTable/?$filter=indexof(stringval,'alue') eq 1
> *Result:* No entities
> *Expected result:* Entity with intkey 1,2,3,4,8,9,10,11,12
> *substring*
> Reference service which supports OData V4:
> *URL:* http://services.odata.org/V4/Northwind/Northwind.svc/Customers/?$filter=indexof(CompanyName,'lfreds') eq 1
> *Result:* Customer with CompanyName equals "Alfreds Futterkiste"
> *ULR:* http://localhost:8080/odata4/olingo_basic/Source/SimpleDataTable/?$filter=substring(stringval, 1) eq 'alue_asdf'
> *Result:* No entities
> *Expected result:* Entity with intkey 10
> \[1\] https://docs.oasis-open.org/odata/odata/v4.0/errata02/os/complete/part2-url-conventions/odata-v4.0-errata02-os-part2-url-conventions-complete.html#_Toc406398121
> \[2\] https://docs.oasis-open.org/odata/odata/v4.0/errata02/os/complete/part2-url-conventions/odata-v4.0-errata02-os-part2-url-conventions-complete.html#_Toc406398122



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