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

Resolving an aliased view prevents inherent update from working

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Critical Critical
    • 8.4.1, 8.6, 7.7.9
    • 7.7
    • Query Engine
    • None

      If an aliased form of an inherently updatable view is resolved first, we will cache invalid update info which prevents inherent insert/update from functioning correctly.

      For example with the view gx, first running:

      select * from gx as x

      will prevent an inherent insert such as:

      insert into gx (e1, e2, e3, e4) select * from pm1.g1

      from working as expected

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

                Created:
                Updated:
                Resolved: