13 | JPQL IN Operator with EclipseLink / postgres but throws an exception in objectDB: select distinct dv.creationtime from ... ", query = " select distinct dv.creationtime from DataValue dv" + " where dv.capabilityId ... the query [DataValue.findDistinctCreationtimesWithLimitDesc: select distinct dv.creationtime from |
13 | Query with FETCH JOIN returns multiple results instead of one. duplicates with DISTINCT: SELECT DISTINCT d FROM Demand d JOIN FETCH d.services WHERE d=:demand ... mentions that duplicates are not filtered unless DISTINCT is used, but many JPA providers do this (or |
11 | 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 |
11 | Updating Entities (and is noted in the manual you linked) - objects within two separate EntityManagers are in fact distinct ... EntityManagers that contain a distinct Entity each: Employee and Paygrade. Paygrade must remain unique |
2 | queries more than 10 times slower using 2.8.1 versus 2.7.6 in 2.7.6 around 5-10 seconds takes in 2.8.1 around 150-200 seconds: SELECT DISTINCT o.parentNode FROM ... 2: "select distinct o from ObjectNode o join o.properties p1 join o.properties p2 join o.properties ... Support the query hint does not help, measures: version 2.8.1 query: select distinct o from ObjectNode o |
2 | each 1-2 days objects on some objectdb level lock/block each other distinct o from ObjectNode o join o.properties p1 join o.properties p2 where (o.classIdentifier ... = "startableState" and p2.doubleValue = 0))) select distinct o from ObjectNode o join o.properties p1 ... != 13) and (p1.name = 'plannedState' and p1.doubleValue > 0 ) select distinct o from ObjectNode o |
2 | Different behavior for casting and not casting: SELECT DISTINCT $1 FROM com.lexware.vereinsverwaltung.verein.mitglied.Mitglied $1 WHERE $1 ... NO entities: SELECT DISTINCT $1 FROM com.lexware.vereinsverwaltung.verein.mitglied.Mitglied $1 ... is resolved: SELECT DISTINCT $1 FROM com.lexware.vereinsverwaltung.verein.mitglied.Mitglied $1 |
2 | InternalException when using MEMBER OF on a large list in a query(); String propertyClassName = propertyClass.getName(); String query = "SELECT DISTINCT property.uid ... the following query don't works: "SELECT DISTINCT property.uid FROM CovPropImpl AS property ... , which should always be true, the query works "SELECT DISTINCT property.uid FROM CovPropImpl AS |
2 | Unexpected Query Token / Casting in QueryHi! 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 ... . Then I had to add another casting: SELECT COUNT(DISTINCT $1) FROM com.quasado.foundation.contact |
2 | New issues with queries using build 2.7.6_08 DISTINCT verdict FROM com.btc.ep.analysis.verdict.bl.internal.dmos.VerdictImpl as verdict, com.btc.ep ... : SELECT DISTINCT verdict FROM com.btc.ep.analysis.verdict.bl.internal.dmos.VerdictImpl as verdict |
