DV query using UNION ALL and OPTION NOCACHE returns incorrect result
Issue
- Queries using UNION ALL returns incorrect result when one query used in the UNION ALL is using cache view and other one is using the same cache view with
option nocache.
select studynum,id,studyid, last_updated_dtm
from cacheviews.study
where studynum = 'BOxxxx'
union all
select studynum,id,studyid, last_updated_dtm
from cacheviews.study
where studynum = 'BOxxxx'
option nocache
Environment
- Red Hat JBoss Data Virtualization (DV) 6.2, 6.3
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.
Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.
