About DISTINCT

11-20 of 67Refresh
Forum
24

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.anritsu.pa3.ttcn3' AND $2 ... Could you comment this? Raised issue: Issue #262 - DISTINCT key causing internal exception on 2.6.4.b10 Fixed in 2.6.5 release Teleca
Manual
16

FROM clause (JPQL / Criteria API)

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

JPA Criteria API Queries

are provided in the following page sections: SELECT clause (select, distinct, multiselect, array, tuple
Manual
16

JPA Query Structure (JPQL / Criteria)

on how to set criteria query clauses are provided as follows: Criteria SELECT (select, distinct, multiselect
JPA Doc
14

javax.persistence.criteria.Subquery

Subquery distinct(boolean distinct) Specify whether duplicate query results will be eliminated ... to be eliminated. A false value will cause duplicates to be retained. If distinct has not been specified ... AbstractQuery method. Parameters: distinct - boolean value specifying whether duplicate results
JPA Doc
14

javax.persistence.criteria.CriteriaQuery

distinct(boolean distinct) Specify whether duplicate query results will be eliminated. Specify ... to be eliminated. A false value will cause duplicates to be retained. If distinct has not been specified, duplicate results must be retained. Parameters: distinct - boolean value specifying whether duplicate
JPA Doc
9

javax.persistence.criteria.AbstractQuery

. Since: JPA 2.0 AbstractQuery distinct(boolean distinct) Specify whether duplicate query results ... duplicates to be eliminated. A false value will cause duplicates to be retained. If distinct has not been specified, duplicate results must be retained. Parameters: distinct - boolean value specifying
JPA Doc
9

javax.persistence.criteria.CriteriaBuilder

distinct operation. Create an aggregate expression applying the count distinct operation. Parameters: x - expression representing input value to count distinct operation Returns: count distinct expression
JPA Doc
8

countDistinct(x)

Method javax.persistence.criteria.CriteriaBuilder Expression countDistinct(   Expression x ) Create an aggregate expression applying the count distinct operation. Parameters: x - expression representing input value to count distinct operation Returns: count distinct expression Since: JPA 2.0
Issue
4

Strange Error with Criteria API and Sorting

We'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