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 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". -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira