Details
-
Bug
-
Resolution: Done
-
Blocker
-
7.1
-
None
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
- relates to
-
TEIID-1256 Clear caches when VDB with same version re-deployed
- Closed