Uploaded image for project: 'Teiid Designer'
  1. Teiid Designer
  2. TEIIDDES-3028

Add "LoadNumber" column to Materialized View cache tables

    Details

    • Type: Enhancement
    • Status: Open (View Workflow)
    • Priority: Blocker
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: 11.2
    • Component/s: Modeling
    • Labels:
      None

      Description

      Based on TEIID-4628, to work with eager updates on materiliazed view, a materialized view's cached table MUST contain an additional column called "LoadNumber" along with rest of view columns. This column is used track the and update the cache contents according to the

      SYSADMIN.updatematView
      

      procedure. The relevant document can be found at https://teiid.gitbooks.io/documents/content/caching/External_Materialization.html

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  Unassigned
                  Reporter:
                  rareddy Ramesh Reddy
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  2 Start watching this issue

                  Dates

                  • Created:
                    Updated: