20 | Searching lists within objects query = "SELECT DISTINCT t FROM com.contextspace.datamodel.party.CDI t JOIN t.attributeList attr ... DISTINCT t FROM com.contextspace.datamodel.party.CDI t JOIN t.attributeList attr WHERE attr.value ... ); assertEquals(3, searchResult.size()); query = "SELECT DISTINCT t FROM com |
18 | com.objectdb.o.NLV cannot be cast to com.objectdb.o.RSVHello! This query is working fine SELECT DISTINCT $1 FROM ChatHistoryItem $1 JOIN $1.recipient ... "com.objectdb.o.NLV cannot be cast to com.objectdb.o.RSV" SELECT DISTINCT $1 FROM ... ) galandor Orlov Sergey I can confirm that the following query causes an exception: SELECT DISTINCT |
18 | JPA query of a Set of terms that are already persisted. em.createQuery( "SELECT DISTINCT si.page FROM SearchIndex si ... that are already persisted. TypedQuery<Page> query = em.createQuery( "SELECT DISTINCT si.page ... = em.createQuery( "SELECT DISTINCT p FROM Page p, SearchIndex s1, SearchIndex s2 |
18 | Left join fetch behaviour doesn't retrieve children? = em.createQuery("SELECT DISTINCT m FROM MyEntity m JOIN FETCH m.entityChildren", MyEntity ... .createEntityManager(); TypedQuery<MyEntity> query = em .createQuery( "SELECT DISTINCT m FROM ... fetch feature for all my collection beans. But ... in some cases doing left join (+ distinct) retrieve |
16 | @ElementCollection query returning extra result per element in collection an ObjectDB query optimization - use an explicit DISTINCT as a workaround until a fix is released: query.select(companyRoot).distinct(true); support Support Yes i can work around this for now ... objects if DISTINCT is not specified. Could you please check this query with EclipseLink |
16 | Using aliases in WHERE clauseHi, I'm trying to run query : SELECT DISTINCT ppi.inquiries AS i FROM ProjectPartInfo ppi WHERE i ... ===================== Unexpected query token 'i' SELECT DISTINCT ppi.inquiries AS i FROM ... my WHERE statement, query runs correctly : SELECT DISTINCT ppi.inquiries AS i FROM ProjectPartInfo ppi |
14 | 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 |
4 | Strange Error with Criteria API and SortingWe're creating a simple selection (distinct) including an order clause. When watching the created criteria in debugger we get the correct expression: SELECT DISTINCT $1 FROM MyEntity $1 ... .objectdb.o.UserException: Invalid order expression '$2' for distinct results at com.objectdb.o.MSG |
3 | Query Execution ErrorThis query SELECT DISTINCT $1 FROM com.lexware.vereinsverwaltung.verein.mitglied.Mitglied $1 LEFT ... just fine before!!! See this more simple query (no collection and the such) SELECT DISTINCT $1 FROM ... check for map return first as there might be null values): SELECT DISTINCT $1 FROM com.lexware |
2 | queries under 2.7.6_4 significantly slower than under 2.7.6. What we can report is: using a reference query (you have our test db) select distinct o from ObjectNode o join o ... 1: select distinct o from ObjectNode o join o.properties p1 where o.classIdentifier = "(OP ... = 0)) Query 2: select distinct o from ObjectNode o join o.properties p1 where o.classIdentifier |
