]
Steven Hawkins resolved TEIID-2781.
-----------------------------------
Resolution: Done
Changed to just toString and added validation to ensure that partial composite keys are
not used. This should probably be queued up for 8.4.2.
Unable to update database table with composite keys using OData
---------------------------------------------------------------
Key: TEIID-2781
URL:
https://issues.jboss.org/browse/TEIID-2781
Project: Teiid
Issue Type: Bug
Components: SOAP Services
Affects Versions: 8.4.1
Reporter: Van Halbert
Assignee: Steven Hawkins
Fix For: 8.7
Attachments: odataerror.txt, post-screen-shot.png, Shell00990083.tar
Using Postgres db, and created a table with composite keys.
CREATE TABLE composite_key
(
ou_id character varying(3) NOT NULL,
product_name character varying(15) NOT NULL,
product_price numeric(10,2),
CONSTRAINT composite_key_pkey PRIMARY KEY (ou_id, product_name)
)
WITH (
OIDS=FALSE
);
ALTER TABLE composite_key OWNER TO postgres;
INSERT INTO composite_key VALUES ('1','1',1);
INSERT INTO composite_key VALUES ('1','2',1.20);
INSERT INTO composite_key VALUES ('2','1',2.10);
Deploy the VDB and use SOAP UI to do PUT (aka SQL UPDATE) generates attached
odataerror.txt
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: