> When i executed 2 DIFFERENT queries on SAME VDB, the results were SAME, which should NOT have been the case.
There is no know issues with concurrency. You should validate that the table does have more than 5 rows and you should be using separate connections (or a single connection in a thread-safe manner). Beyond that you'd have to provide the full source / vdb / any custom translator involved, etc. to make a further determination.
> I have posted same question on stack overflow also multithreading - Teiid JDBC give same result set object for different queries - Stack Overflow
No need to cross post. This is the primary forum.