DV query using UNION ALL and OPTION NOCACHE returns incorrect result

Solution Verified - Updated -

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.

Current Customers and Partners

Log in for full access

Log In
Close

Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.