[ https://issues.jboss.org/browse/TEIID-2706?page=com.atlassian.jira.plugin... ] Debbie Steigner commented on TEIID-2706: ---------------------------------------- Using VDB Execute in the Designer, you can see the hint coming thru, so /*+ cache */ select * from bqt.SmallA Shows it using the cache hint: 2013-10-21 07:22:29,923 DEBUG [org.teiid.PROCESSOR] CCeIPNy1zUVF.0 Using cache hint /*+ cache */ 2013-10-21 07:22:29,923 TRACE [org.teiid.PROCESSOR] Adding to global/distributed cache Cache Entry<CCeIPNy1zUVF=user@teiid-security> params:null sql:/*+ cache */ select * from bqt.SmallA 2013-10-21 07:22:29,924 TRACE [org.teiid.BUFFER_MGR] Add batch to BufferManager 3 with size estimate 83866 2013-10-21 07:22:29,924 DEBUG [org.teiid.PROCESSOR] [RequestWorkItem.sendResultsIfNeeded] requestID: CCeIPNy1zUVF.0 resultsID: 16 done: true 2013-10-21 07:22:29,925 DEBUG [org.teiid.TRANSPORT] send message: MessageHolder: key=35 contents=ResultsMessage rowCount=50 finalRow=50 But then when I rerun the same query: /*+ cache */ select * from bqt.SmallA It shows it hitting the cache, but it returns 0 rows. 2013-10-21 07:22:43,356 TRACE [org.teiid.PROCESSOR] Cache hit for Cache Entry<QJa3VEi6VZAC=user@teiid-security> params:null sql:/*+ cache */ select * from bqt.SmallA 2013-10-21 07:22:43,356 TRACE [org.teiid.PLANNER.RESOLVER] Resolving command /*+ cache */ SELECT * FROM bqt.SmallA 2013-10-21 07:22:43,356 DEBUG [org.teiid.PROCESSOR] [RequestWorkItem.sendResultsIfNeeded] requestID: QJa3VEi6VZAC.0 resultsID: 16 done: true 2013-10-21 07:22:43,356 DEBUG [org.teiid.TRANSPORT] send message: MessageHolder: key=41 contents=ResultsMessage rowCount=0 finalRow=0 -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira