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

using an alter to add a key to a view doesn't work unless columns are explicitly declared

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Major Major
    • 12.1
    • None
    • Query Engine
    • None

      DDL such as:

      create view v as select 1 as c1, 2 as c2;
      alter view v add primary key (c1);

      does not work because the columns are not defined for the view until metadata validation.

              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: