UNION of federated sources are returning results like UNION ALL in EDS

Solution Verified - Updated -

Issue

  • The UNION of two or more federated sources are producing the wrong results and behaving like UNION ALL instead.
select <col1> from <schema>.<table1> where <col2> = 'X' and <col1> = 'Y'
union
select <col1> from <schema2>.<table2> where <col2> = 'X' and <col1> = 'Y'
union
select <col1> from <table3> where <col1> = 'Y'
  • expect to see 1 record but the query is returning 2 records.

Environment

  • Red Hat JBoss Data Services 5.3.1

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