[teiid-issues] [JBoss JIRA] (TEIID-5799) GENERATED_KEY cannot resolve primary key, if created via insert trigger on view

[Christoph John (Jira)]

     [ https://issues.jboss.org/browse/TEIID-5799?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Christoph John updated TEIID-5799:
----------------------------------
    Description: 
Hello Steven,
I just ran into the next issue with the generated key functionality. Attached you find an example. The relevant section is  given in
CREATE TRIGGER ON Diary INSTEAD OF INSERT AS
with the block following:
ELSE IF (new.fkDatabaseKey = 3)

In the insert trigger I am trying to duplicate a record from table "UserDefinedProducts" and reference it in the row to be created from the trigger.

I again the the error message:

POST on 'Diary' failed; will be repeated automatically - Error: TEIID16016 Insert into Diary success, but failed to retrieve auto generated keys from source, thus failed to show result entity; Supply the key values.

I am using the most recent sources checked out about an hour ago.

Do you see a bug in my code, or is it again an issue I have hit? Thanks for your help!

Let me know if I shall assemble a docker-compose file for you to debug the issue.

Best regards,
 Christoph

  was:
Hello Steven,
I just ran into the next issue with the generated key functionality. Attached you find an example. The relevant section is  given in
CREATE TRIGGER ON Diary INSTEAD OF INSERT AS
with the block following:
ELSE IF (new.fkDatabaseKey = 3)

In the insert trigger I am trying to duplicate a record from table "UserDefinedProducts" and reference it in the row to be created from the trigger.

I again the the error message:

POST on 'Diary' failed; will be repeated automatically - Error: TEIID16016 Insert into Diary success, but failed to retrieve auto generated keys from source, thus failed to show result entity; Supply the key values.

I am using the most recent sources checked out about an hour ago.

Do you see a bug in my code, or is it again an issue I have hit? Thanks for your help!

Best regards,
 Christoph



> GENERATED_KEY cannot resolve primary key, if created via insert trigger on view
> -------------------------------------------------------------------------------
>
>                 Key: TEIID-5799
>                 URL: https://issues.jboss.org/browse/TEIID-5799
>             Project: Teiid
>          Issue Type: Bug
>    Affects Versions: 13.0
>            Reporter: Christoph John
>            Assignee: Steven Hawkins
>            Priority: Blocker
>         Attachments: svc-vdb-example.ddl
>
>
> Hello Steven,
> I just ran into the next issue with the generated key functionality. Attached you find an example. The relevant section is  given in
> CREATE TRIGGER ON Diary INSTEAD OF INSERT AS
> with the block following:
> ELSE IF (new.fkDatabaseKey = 3)
> In the insert trigger I am trying to duplicate a record from table "UserDefinedProducts" and reference it in the row to be created from the trigger.
> I again the the error message:
> POST on 'Diary' failed; will be repeated automatically - Error: TEIID16016 Insert into Diary success, but failed to retrieve auto generated keys from source, thus failed to show result entity; Supply the key values.
> I am using the most recent sources checked out about an hour ago.
> Do you see a bug in my code, or is it again an issue I have hit? Thanks for your help!
> Let me know if I shall assemble a docker-compose file for you to debug the issue.
> Best regards,
>  Christoph



--
This message was sent by Atlassian Jira
(v7.12.1#712002)