[teiid-issues] [JBoss JIRA] (TEIID-5725) Please improve documentation on definition of stored procedures, virtual functions and virtual procedures

[Christoph John (Jira)]

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

Christoph John commented on TEIID-5725:
---------------------------------------

>>Another thing to consider is if you even need an atomic block. Are you worried about a competing update to NutritionGoal in between the select and update?

Yes, this is the situation I would like to safeguard.

>> Yes that is the workaround in this case if you want it as an action. More than likely though we'd want the semantics of "side effect free" to be represented rather than documenting this as a corner case. Can you log an issue about this?

I will do that.

>>You could combine both of the selects, and you may find it easier to read using a loop rather than a lot of scalar subqueries:

Thanks for the code improvement

> Please improve documentation on definition of stored procedures, virtual functions and virtual procedures
> ---------------------------------------------------------------------------------------------------------
>
>                 Key: TEIID-5725
>                 URL: https://issues.jboss.org/browse/TEIID-5725
>             Project: Teiid
>          Issue Type: Enhancement
>          Components: Documentation
>            Reporter: Christoph John
>            Assignee: Steven Hawkins
>            Priority: Critical
>
> I refer to the discussion with Ramesh in 
> https://developer.jboss.org/message/989048#989048 and would like to ask for a more detailed explanation on how to write virtual procedures and functions. 
> -Especially, how are OUT and INOUT params set and how can they be obtained via odata. 
> - How is the return value of a virtual function set?
> - How are collections and arrays of collections returned?



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