[teiid-issues] [JBoss JIRA] (TEIID-2781) Unable to update database table with composite keys using OData

[Van Halbert (JIRA)]

Van Halbert created TEIID-2781:
----------------------------------

             Summary: 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


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: http://www.atlassian.com/software/jira