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

Migration to Teiid 9.0.0 - Materialized views error: Expected integer, but was bigdecimal

    XMLWordPrintable

Details

    • Bug
    • Resolution: Can't Do
    • Critical
    • None
    • 9.0
    • Query Engine
    • None

    Description

      After migrating to Teiid 9.0.0, we are facing issues with existing views materialized on Oracle server.
      when fetching an Oracle materialized view that contains a column using date function like : "Month" or "Year" or "TIMESTAMPDIFF", we are getting the error : Expected integer, but was bigdecimal.

      If we go back to Teiid 8.11.3, the same materialized views fetch without any problem.

      Attachments

        Issue Links

          is caused by

          Quality Risk - A potential bug. TEIID-3999 more aspects of materialization metadata should be validated

          • 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

              rhn-engineering-shawkins Steven Hawkins
              mtawk Mark Tawk (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: