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

Internal Materialization does not honor the cache hint

    XMLWordPrintable

Details

    • Bug
    • Resolution: Won't Do
    • Major
    • 7.4
    • 7.2
    • Query Engine
    • None

    Description

      When a internal materialization is loaded with /+ cache(pref_mem ttl:120000)/ select * from view.g1, to does not refresh/flush the matview contents from memory after two minutes (120000). Upon inspecting the code, it looks like the Cache Hint is being on searched on the created temp table rather than the original query.

      Attachments

        Activity

          People

            rhn-engineering-shawkins Steven Hawkins
            rhn-engineering-rareddy Ramesh Reddy
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: