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

Inherent insert using WHERE partitioning is incomplete

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Major
    • 8.3
    • 7.7
    • Query Engine
    • None
    • Workaround Exists
    • Hide

      Define an explicit update procedure using a instead of trigger.

      Show
      Define an explicit update procedure using a instead of trigger.

    Description

      Using a metadata structure such as:

      create foreign table b (custid integer, field1 varchar) options updatable true)
      create view c options (updatable true) as select * from b where custid = 1 union all select * from b where custid = 2;

      will fail to process INSERT into c (custid, field1) values (1, 'foo')

      because a null value will be inserted into be for the custid field. The logic is treating the WHERE partitioning as if it were projected literals from the SELECT cause inappropriately.

      Attachments

        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: