[
https://issues.jboss.org/browse/TEIID-5072?page=com.atlassian.jira.plugin...
]
Ramesh Reddy commented on TEIID-5072:
-------------------------------------
I like the variable group "Key", so it will have all the columns of a key
columns of the view. I did not understand the need for the generated_key? shouldn't
this be automatic when the insert is finished Key group is populated?
The next question is how can we push this Key back into JDBC resultset?
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)