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

Add "LoadNumber" column to Materialized View cache tables

    XMLWordPrintable

Details

    • Enhancement
    • Resolution: Won't Do
    • Blocker
    • 12.0
    • None
    • Modeling
    • 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

      Attachments

        Issue Links

          is related to

          Feature Request - Feature requests from customers and/or users TEIID-4628 Support incremental materialization refresh strategies

          • Major - To be worked after higher priority work items are addressed. When the severity is high and the effort to change it is low to moderate, this term is chosen. Issues in this category likely have an existing workaround but implementation or execution may be non-trivial.
          • Resolved

          Enhancement - An enhancement to or refactoring of existing functionality that is not configurable by an end user (typically a change made by an internal team that affects users) TEIIDDES-3010 Add feature to provide adding After Triggers to materialized views/tables

          • Blocker - To be worked above all other priorities. This term is chosen when the severity of the issue is very high, has no workaround, or the effort for the change is comparatively low. Issues that may be very publicly visible and could generate significant media attention may also drive a higher priority.
          • Resolved

          Enhancement - An enhancement to or refactoring of existing functionality that is not configurable by an end user (typically a change made by an internal team that affects users) TEIID-4627 High-level event handling

          • Major - To be worked after higher priority work items are addressed. When the severity is high and the effort to change it is low to moderate, this term is chosen. Issues in this category likely have an existing workaround but implementation or execution may be non-trivial.
          • Resolved

          Activity

            People

              blafond Barry LaFond
              rhn-engineering-rareddy Ramesh Reddy
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: