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

Preview Data results do not update for changes in virtual table SQL

    XMLWordPrintable

Details

    Description

      1) Created simple project containing Parts relational table.
      2) Create Virtual model
      3) Add base table (i.e. PartsInfo)
      4) Set SQL transformation to "SELECT * FROM PARTS WHERE PART_WEIGHT > 18" (PART_WEIGHT column name may be different depending on your DB source)
      5) Save all and "Preview Data". Should get good results back
      6) Change SQL to "SELECT * FROM PARTS WHERE PART_WEIGHT < 16"
      7) Save all and "Preview Data". Result that come back reflect the previous SQL ( > 18)

      Closing project, cleaning up .metadata folder, restarting Designer.

      Note: By creating a Teiid DTP connection to the PREVIEW project (See vdb name in workspace folder on file system), you can do an adhoc query of "SELECT * FROM PARTSINFO" and it'll come back with the results with " < 16".

      Attachments

        Issue Links

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: