Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-2781

Unable to update database table with composite keys using OData

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Major Major
    • 8.4.1, 8.7
    • 8.4.1
    • SOAP Services
    • None

      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

        1. Shell00990083.tar
          182 kB
        2. post-screen-shot.png
          post-screen-shot.png
          110 kB
        3. odataerror.txt
          5 kB

              rhn-engineering-shawkins Steven Hawkins
              van.halbert Van Halbert (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Created:
                Updated:
                Resolved: