[ https://issues.jboss.org/browse/TEIID-5763?page=com.atlassian.jira.plugin... ] Christoph John commented on TEIID-5763: --------------------------------------- Hello Steven, here is the first example: {code:java} CREATE VIEW QuicklyAddedProducts ( fkProduct long NOT NULL AUTO_INCREMENT, fkProfile long NOT NULL, product_name string(20) NOT NULL, energy_100g double NOT NULL, carbohydrates_100g double NOT NULL, proteins_100g double NOT NULL, fat_100g double NOT NULL, CONSTRAINT "PRIMARY" PRIMARY KEY(fkProduct), CONSTRAINT fkQuicklyAddedProductsToProducts FOREIGN KEY(fkProduct) REFERENCES Products(idProduct), CONSTRAINT fkQuicklyAddedProductsToAccount FOREIGN KEY(fkProfile) REFERENCES Account(idProfile), CONSTRAINT fkQuicklyAddedProductsToAccount_idx INDEX(fkProfile) ) OPTIONS(UPDATABLE 'TRUE') AS SELECT qap.fkProduct as fkProduct, qap.fkProfile as fkProfile, qap.product_name as product_name, qap.energy_100g as energy_100g, qap.carbohydrates_100g as carbohydrates_100g, qap.proteins_100g as proteins_100g, qap.fat_100g as fat_100g FROM QuicklyAddedProducts_SRC as qap; -- /////////// CREATE TRIGGER ON QuicklyAddedProducts INSTEAD OF INSERT AS FOR EACH ROW BEGIN ATOMIC DECLARE long vIdProduct; INSERT INTO Products(fkDatabaseKey) VALUES (2); vIdProduct = cast(generated_key('idProduct') as long); key.fkProduct = vIdProduct; -- create a new record for the quickly added product INSERT INTO QuicklyAddedProducts_SRC(fkProfile, product_name, energy_100g, carbohydrates_100g, proteins_100g, fat_100g) VALUES (new.fkProfile, new.product_name, new.energy_100g, new.carbohydrates_100g, new.proteins_100g, new.fat_100g); END; {code} When I sent the following request to add a new record {"fkProduct":"0","fkProfile":"1","product_name":"This is a test","energy_100g":1255,"carbohydrates_100g":60.08,"proteins_100g":24.02,"fat_100g":15.89} {"@odata.context":"https://morpheus.fritz.box/odata4/svc/my_nutri_diary/$metadata#QuicklyAddedProducts","{color:red}fkProduct":"0"{color},"fkProfile":"1","product_name":"This is a test","energy_100g":1255.0,"carbohydrates_100g":60.08,"proteins_100g":24.02,"fat_100g":15.89} I get this object back. As a matter of principle in the past I always had to send a dummy for the primary key. Here fkProduct is the foreign key. Note, without defining a INSERT Trigger, the response correctly contains the key of the newly created item. In case of having a custom insert, simply the default dummy value is sent back. Hence if I would sent "1"as dummy, I receive "1" back instead of "0" like in the example above. However, the real autogenerated key which I would expect is a different one. -- This message was sent by Atlassian Jira (v7.12.1#712002)