[teiid-issues] [JBoss JIRA] (TEIID-5729) Introduce mechanism or option to allow for mapping of side effect free Teiid procedures to ODATA functions, and actions if procedure has side effects

[Christoph John (Jira)]

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

Christoph John edited comment on TEIID-5729 at 6/20/19 6:53 PM:
----------------------------------------------------------------

Hello Steven,
I have not found the relevant section in the documentation. Could you please add a link?

Furthermore, as far as I understand your comment, simply adding OPTIONS(UPDATECOUNT '0') will force the procedure to become a function? 

According to:
https://devblogs.microsoft.com/odata/tutorial-sample-functions-actions-in-web-api-v2-2-for-odata-v4-0-type-scenario/
http://docs.oasis-open.org/odata/odata/v4.0/errata01/os/complete/part1-protocol/odata-v4.0-errata01-os-part1-protocol-complete.html#_Functions_1

a function also always needs to have a return value. Is this also considered? 
I assume INOUT parameters are ignored as return values?



was (Author: cjohn001):
Hello Steven,
I have not found the relevant section in the documentation. Could you please add a link. Furthermore, as far as I understand your comment, simply adding OPTIONS(UPDATECOUNT '0') will force the procedure to become a function. According to

https://devblogs.microsoft.com/odata/tutorial-sample-functions-actions-in-web-api-v2-2-for-odata-v4-0-type-scenario/
http://docs.oasis-open.org/odata/odata/v4.0/errata01/os/complete/part1-protocol/odata-v4.0-errata01-os-part1-protocol-complete.html#_Functions_1

a function also always needs to have a return value. Is this also considered? I assume INOUT parameters are ignored?


> Introduce mechanism or option to allow for mapping of side effect free Teiid procedures to ODATA functions, and actions if procedure has side effects
> -----------------------------------------------------------------------------------------------------------------------------------------------------
>
>                 Key: TEIID-5729
>                 URL: https://issues.jboss.org/browse/TEIID-5729
>             Project: Teiid
>          Issue Type: Enhancement
>          Components: OData
>            Reporter: Christoph John
>            Assignee: Steven Hawkins
>            Priority: Major
>             Fix For: 12.3
>
>
> This is a follow up regarding https://issues.jboss.org/browse/TEIID-5725
> As discussed there, Teiid currently does not map virtual procedures and functions to odata functions and procedures according to the notion of "side effect free"
> Please introduce a mechanism to allow for a mapping according to adequate odata semantics.



--
This message was sent by Atlassian Jira
(v7.12.1#712002)