Translation of security criteria to table groups not correct in JDV

Solution Verified - Updated -

Issue

  • problems with queries on a view in a VDB that has security and joins.
  • If a view over a left outer join has a row condition and is used in a simple aggregation:
select count(*) from vw

Then a null pointer exception will occur when considering optional joins.

  • If intervening criteria is added:
select count(*) from vw where ...

we can get past the initial error, but will fail in initializing the join node with an assertion error. Both of these have the same root issue, which is our attempt to make the logic selective about when assign output elements is run, which leads to the output elements not being in place when later needed.

Environment

  • Red Hat JBoss Data Virtualization 6

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.