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

Unable to update database table with composite keys using OData

    XMLWordPrintable

Details

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

    Description

      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

      Attachments

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

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved: