Home » Search

About DISTINCT

31-40 of 65Refresh
Forum
3

multiple LEFT JOINs do not work as expected

like this: SELECT DISTINCT $1 FROM Organisation $1 JOIN $1.attributeList $2 LEFT ... ().commit();                 Query query = em.createQuery(             "SELECT DISTINCT n1 ... "); em.getTransaction().commit(); Query query = em.createQuery( "SELECT DISTINCT
Forum
3

Query with FETCH JOIN returns multiple results instead of one.

with DISTINCT: SELECT DISTINCT d FROM Demand d JOIN FETCH d.services WHERE d=:demand You are probably ... filtered unless DISTINCT is used, but many JPA providers do this (or used
Issue
3

Unexpected Query Token / Casting in Query

Hi! Please find the attached database. Doing a simple query with casting SELECT COUNT(DISTINCT $1 ... COUNT(DISTINCT $1) FROM com.quasado.foundation.contact.individual.IndividualContact $1 WHERE UPPER ... another casting: SELECT COUNT(DISTINCT $1) FROM com.quasado.foundation.contact.individual.IndividualContact
Forum
2

can removing an entity throw an exception if the entity is in use?

something like: SELECT DISTINCT b FROM A a, B b WHERE a = b.a OR a MEMBER OF b.list ... The query ... is simpler: SELECT DISTINCT b FROM B b WHERE :a = b.a OR :a MEMBER OF b.list ...   FastModel
Issue
2

ClassCastException in Tuple.get

.multiselect(joinDemand, rootDemandAnswer).distinct(true); cq.where( cb.equal ... (joinDemand.alias("d"), rootDemandAnswer.alias("a")).distinct(true); //... Demand demand = (Demand
Forum
2

First query takes 4+ minutes to complete

an index will help. Also, we tried a different query today: SELECT DISTINCT NEW com.arunta.base.db ... (); String qs = "SELECT DISTINCT NEW com.arunta.base.db.DateExtensionDTO(r.startDate, r
Issue
2

Internal Exception during query execution

of: SELECT DISTINCT $1, UPPER($1.name) AS $O0 FROM com.quasado.foundation.contact.Contact $1 ORDER BY ... : Without order by works perfectly: SELECT DISTINCT $1 FROM com.quasado.foundation.contact.Contact $1
Forum
2

Issue with upper?

Hi, Query 1: SELECT DISTINCT $1, $2.lastName AS $O0 FROM com.lexware.vereinsverwaltung.verein.mitglied.Mitglied $1 LEFT JOIN $1.profile $2 ORDER BY UPPER($2.lastName) Correctly returns all the different lastName's for each $1 Now the same but with upper SELECT DISTINCT $1, UPPER($2
Issue
2

JPQL support for mapped by (inverse) collections

Forum
2

Lazy Init / Eager / Join Fetch collection strategy ? What to choose ?

different. Is an "All eager strategy" more efficient that many join fetch ( cartesian product + distinct ... " more efficient that many join fetch (cartesian product + distinct)? > So ... "Eager fetch all strategy