[teiid-issues] [JBoss JIRA] (TEIID-5072) Generated keys should be passed from triggers

[Steven Hawkins (JIRA)]

Steven Hawkins created TEIID-5072:
-------------------------------------

             Summary: Generated keys should be passed from triggers
                 Key: TEIID-5072
                 URL: https://issues.jboss.org/browse/TEIID-5072
             Project: Teiid
          Issue Type: Sub-task
          Components: Query Engine
            Reporter: Steven Hawkins
            Assignee: Steven Hawkins
             Fix For: 10.0


In the context of an update trigger we should be able to convey the generated keys to the caller.  In the case where only a single insert occurs, this should be automatic.  Otherwise we'll need functions/variables to get/set the generated keys in the procedure.  For example see the LAST_INSERT_ID function on mysql.



--
This message was sent by Atlassian JIRA
(v7.2.3#72005)