DISTINCT() doesn't return correct results against Modeshape VDB in EDS

Solution Verified - Updated -

Issue

  • DISTINCT() doesn't return correct results against Modeshape VDB in EDS, if you run the following query you will see all rows, not distinct values.
select distinct(jcr_primaryType) from modeshape.nt_base 

Environment

  • Red Hat JBoss Data Services (EDS) 5.3.1
  • EDS Metadata Repository VDB (Modeshape) 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