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

Update to updatable internal materialized view should update the materialized view as well as the database

    Details

    • Type: Enhancement
    • Status: Resolved (View Workflow)
    • Priority: Major
    • Resolution: Done
    • Affects Version/s: 8.7
    • Fix Version/s: 9.2
    • Component/s: VDB
    • Labels:
      None
    • Environment:

      Red Hat JBoss Data Virtualization 6.2 based on Teiid 8.7.x

      Description

      Updating an updatable internal materized view updates the database but not the materialized view at present. The requested enhancement is that they, both, should be updated.

      Setup
      Client - SquirrelSQL to access JDV
      JDV 6.2 - with an updatable nternal materialized view of one table from the data source
      Data Source - just one data source: MySQL

      I can see from the console that the target table/view has been materialized
      Then I did the following:
      1) select a row from the materialized table
      2) update a field in a row in the materialized view
      3) select that row (value unchanged ie, same as int 1) - tried multiple times
      4) issue EXEC SYSADMIN.refreshMatViewRow(...) using primary key for the row that has been changed
      5) select that row (value unchanged) - now I can see the changed data

      This behaviour is counter-intuitive because I was expecting that since it is an updatable materialized view, my change will write through the materialized view ie, change both the materialized view as well as the database. But in this case, it changed the database and not the materialized view?

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  shawkins Steven Hawkins
                  Reporter:
                  andy.yuen Andy Yuen
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  4 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved: