[teiid-designer-issues] [JBoss JIRA] Assigned: (TEIIDDES-604) Preview Data results do not update for changes in virtual table SQL

Preview Data results do not update for changes in virtual table SQL ------------------------------------------------------------------- Key: TEIIDDES-604 URL: https://jira.jboss.org/browse/TEIIDDES-604 Project: Teiid Designer Issue Type: Bug Components: Data Preview, VDB & Execution Affects Versions: 7.1 Reporter: Barry LaFond Assignee: Barry LaFond Priority: Blocker Fix For: 7.1.1 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".