Internal Website Search
31-40 of 78 resultsRefreshmultiple LEFT JOINs do not work as expected an example. The test query looks like this: SELECT DISTINCT ... ; "SELECT DISTINCT n1 " +   ... .createQuery( "SELECT DISTINCT n1 " + "FROM Node n1 LEFT JOIN n1.parent n2 LEFT | |
Query with FETCH JOIN returns multiple results instead of one.; Maciek hobson Maciek Chabros You should be able to filter duplicates with DISTINCT: SELECT DISTINCT d FROM Demand d JOIN FETCH d.services WHERE d=:demandDISTINCT is used, but many JPA providers | |
Issue with upper? Hi, Query 1: SELECT DISTINCT $1, $2.lastName AS $O0 FROM com.lexware.vereinsverwaltung.verein.mitglied.Mitglied $1 LEFT JOIN $1 ... for each $1 Now the same but with upper SELECT DISTINCT $1 | |
IN expression in a Criteria Query; <token name="DISTINCT" code="94" postion="7:15" />   ... ;queryRequest query="SELECT DISTINCT COUNT($1) FROM Computer $1 WHERE (($1.workplace.id=:l1) AND $1 | |
each 1-2 days objects on some objectdb level lock/block each other' and p1.doubleValue > 0) select distinct o from ObjectNode o join o ... = 0))) select distinct o from ObjectNode o join o.properties p1   ... >select distinct o from ObjectNode o JOIN o.properties p2 JOIN o.properties p3 JOIN o.properties ps | |
InternalException when using MEMBER OF on a large list in a query query = "SELECT DISTINCT property.uid FROM " + propertyClassName + " AS property ... an unless condition. That means the following query don't works: "SELECT DISTINCT property ... works "SELECT DISTINCT property.uid FROM CovPropImpl AS property, CovRecImpl AS record WHERE 3< | |
Different behavior for casting and not casting which works and selects a few entities: SELECT DISTINCT $1 FROM com ... > SELECT DISTINCT $1 FROM com.lexware.vereinsverwaltung.verein.mitglied ... when the previous issue with casting is resolved: SELECT DISTINCT $1 FROM com | |
Unexpected Query Token / Casting in Query SELECT COUNT(DISTINCT $1) FROM com.quasado.foundation.contact ... COUNT(DISTINCT $1) FROM com.quasado.foundation.contact.individual.IndividualContact $1 WHERE UPPER ... another casting: SELECT COUNT(DISTINCT $1) FROM com | |
queries more than 10 times slower using 2.8.1 versus 2.7.6 seconds: SELECT DISTINCT o.parentNode FROM ObjectNode o WHERE o.classIdentifier = "(OP ... distinct o from ObjectNode o join o.properties p1 join o.properties p2 join o.properties p10 join o ... hint does not help, measures: version 2.8.1 query: select distinct o | |
Internal Exception during query execution one might think of: SELECT DISTINCT $1, UPPER($1.name) AS $O0 FROM ... -query"> SELECT DISTINCT $1 FROM com.quasado.foundation.contact.Contact $1 Alex |