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.4.1, 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: