[teiid-issues] [JBoss JIRA] (TEIID-5072) Generated keys should be passed from triggers
Steven Hawkins (JIRA)
issues at jboss.org
Thu Sep 21 09:37:00 EDT 2017
[ https://issues.jboss.org/browse/TEIID-5072?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13466903#comment-13466903 ]
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)
More information about the teiid-issues
mailing list