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

Generated key is not made available depending upon the number of column values on the insert

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Major
    • 12.3, 12.2.2
    • None
    • Query Engine
    • None

    Description

      The logic to calculate when to return the generated key was not generally correct. If there were other columns beside the key left out of the explicit insert variable list, then the generated key would not be returned.

      For example:

      create temporary table t (x serial, y string, primary key (x));

      would not return the generated key on:

      insert into t (y) values ('a');

      Attachments

        Issue Links

          relates to

          Quality Risk - A potential bug. TEIID-5782 When overwriting an Insert trigger with custom logic in a ddl file, the primary key is not correctly transferred back in the response of the odata layer with a dummy insert value

          • Major - To be worked after higher priority work items are addressed. When the severity is high and the effort to change it is low to moderate, this term is chosen. Issues in this category likely have an existing workaround but implementation or execution may be non-trivial.
          • Resolved

          Activity

            People

              rhn-engineering-shawkins Steven Hawkins
              rhn-engineering-shawkins Steven Hawkins
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: