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

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

      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');
      

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

              Created:
              Updated:
              Resolved: