[
https://issues.jboss.org/browse/TEIID-5782?page=com.atlassian.jira.plugin...
]
Christoph John commented on TEIID-5782:
---------------------------------------
Hello Steven, I think the answer is already partly covered in my response in the other
jira issue. So the problem in the past was, that I had to send a dummy value for the
primary key in order to get the create request via odata accepted from Teiid. I did not
sent NULL but "0" by the way. The response than contained the correct
autogenerated key.
To my opinion you are right, it should not be necessary to send a dummy value. Sometimes
less is more :) In case you decide to change this, please let me know, as the change like
you described, to refuse a create request with a given value for an autoincrement
property, would break my code in some places.
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 with
a dummy insert value
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Key: TEIID-5782
URL:
https://issues.jboss.org/browse/TEIID-5782
Project: Teiid
Issue Type: Quality Risk
Components: OData
Affects Versions: 12.3
Reporter: Christoph John
Assignee: Steven Hawkins
Priority: Major
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)