[
https://issues.jboss.org/browse/TEIID-5072?page=com.atlassian.jira.plugin...
]
Ramesh Reddy commented on TEIID-5072:
-------------------------------------
Since you are saying the inherent case, how about the explicit trigger but single insert
statement case? I guess I am thinking each time insert happens Key is populated unless
user captured in another variable.
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)