Internal Website Search

11-20 of 78 resultsRefresh

ObjectDB internal error on 2.6.4.b10 for query with DISTINCT

I observed that on new ObjectDb v.2.6.4.b10 query below causes internal exception SELECT DISTINCT $1 FROM Pa3DictionaryItem $2 JOIN $2.values $1 WHERE ($2.namespace == 'com ... "> Issue #1176 - DISTINCT key causing internal exception on 2.6.4.b10 Harman

JPA Query Structure (JPQL / Criteria)

="/api/java/jpa/criteria/CriteriaQuery/distinct_boolean">distinct,

JPA Criteria API Queries

/criteria/CriteriaQuery/distinct_boolean">distinct,

FROM clause (JPQL / Criteria API)

_TIMESTAMP,DELETE, DESC, DISTINCT, ELSE, EMPTY, END, ENTRY, ESCAPE, EXISTS, FALSE, FETCH,FROM, GROUP

javax.persistence.criteria.Subquery

; distinct_boolean" title="Method of javax.persistence.criteria.Subquery">distinct (boolean distinct) distinct has not been specified, duplicate results

javax.persistence.criteria.CriteriaQuery

">distinct_boolean" title="Method of javax.persistence.criteria.AbstractQuery">distinct (boolean distinct) distinct has not been specified, duplicate results must be retained

javax.persistence.criteria.AbstractQuery

/criteria/AbstractQuery/distinct_boolean" title="Method of javax.persistence.criteria.AbstractQuery">distinct (boolean distinct) Specify ... . If distinct has not been specified, duplicate results must be retained.

javax.persistence.criteria.CriteriaBuilder

"> Create an aggregate expression applying the count distinct operation. distinct operation. Parameters ... value to count distinct operation

countDistinct(x)

"> Create an aggregate expression applying the count distinct operation. - expression representing input value to count distinct operation Returns: count distinct expression

combined index not used

it takes 47 ms, version 2.8.0_02 it takes 700 ms): SELECT DISTINCT o.parentNode FROM ObjectNode ... on executing this query what we never had before: SELECT DISTINCT o from ObjectNode o join o ... it goes in 2.7.6 ?): SELECT DISTINCT o from ObjectNode o join o.properties p1 join o.properties