[teiid-issues] [JBoss JIRA] (TEIID-5072) Generated keys should be passed from triggers
[
https://issues.jboss.org/browse/TEIID-5072?page=com.atlassian.jira.plugin...
]
Steven Hawkins commented on TEIID-5072:
---------------------------------------
I did not understand the need for the generated_key? shouldn't
this be automatic when the insert is finished Key group is populated?
No, it would not be automatic unless we are in the inherent case. Here the trigger could
contain n number of inserts and a view transformation that doesn't clearly map the pk
value. Rather than try to infer what insert(s) map appropriately, it's up to the user
to associate the value.
The next question is how can we push this Key back into JDBC
resultset?
Do you mean Statement.getGeneratedKeys? That would be the outcome of this yes.
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)