Comparing the behavior of INNER and LEFT JOINS in JBoss EDS

Solution Unverified - Updated -

Issue

  • Inner join retruns no data, left join does
  • wrong data (no data) being returned on a federated query

  • changing left join query to inner join query returns no data

Environment

  • JBoss Enterprise Data Services Platform (EDS-P) 5.1.0
  • LEFT and INNER JOIN logic SQL

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