[teiid-issues] [JBoss JIRA] (TEIID-5782) When overwriting an Insert trigger with custom logic in a ddl file, the primary key is not correctly transferred back in the response of the odata layer.

Christoph John (Jira) issues at jboss.org
Sun Jun 23 18:58:00 EDT 2019


Christoph John created TEIID-5782:
-------------------------------------

             Summary: When overwriting an Insert trigger with custom logic in a ddl file, the primary key is not correctly transferred back in the response of the odata layer.
                 Key: TEIID-5782
                 URL: https://issues.jboss.org/browse/TEIID-5782
             Project: Teiid
          Issue Type: Bug
          Components: OData
    Affects Versions: 12.3
            Reporter: Christoph John
            Assignee: Steven Hawkins


Hello,
in the past we had an issue in the odata layer, that the generated primary key of an autoincrement key was not corretly transfered back in the odata response. This issue was fixed.
However, the current issues derives from the discussion in

https://issues.jboss.org/browse/TEIID-5763

where we havewritten an INSTEAD OF INSERT trigger. According to my last comment to https://issues.jboss.org/browse/TEIID-5763, there are two situations which can arrise. I have to set the 1. key group explicitely or 2. it is set implicitely.
Now in both situations I observe the same result. When I POST an INSERT with a dummy primary key, say key=0 (as it was NOT NULL in the past, and I am still using the old sources) I retrieve key=0 in the odata response. Correct would be to get a response with the generated key instead.



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


More information about the teiid-issues mailing list