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
Close

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