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

ERROR Previewing data for nested mapping class in XML Document model

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Won't Do
    • Icon: Major Major
    • None
    • None
    • None
    • None

      During testing of Books XML tried to query nested mapping class. Received SQL Server error which was masking the real problem with unresolved/unindexed Input Set objects in criteria.

      Suggest we disable previewing Mapping Classes (Staging tables would be OK) until we can find a solution, which may be treating a mapping class like an access pattern. Ramesh suggested we "Swipe" the SQL for a mapping class, present to user a list of "Input Set Parameters" (similar to procedures & access patterns), and inject the user-supplied values into the SQL. The actual SQL called will NOT be Select * FROM XXXXX, but the modified Mapping Class's SQL.

      NOTE that the Preview data will be success for the "TOP" mapping class because it doesn't utilize an Input Set.

            blafond Barry LaFond
            blafond Barry LaFond
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: