Internal Website Search

;           String q1 = "select distinct s_location ... ;              q1 = "select distinct s ... distinct s.location "             + "from

distinct? I.e. doing something like SELECT DISTINCT $1, $2distinct(selection) so that I could do something like criteria.multiselect(builder.distinct($1), $2)... ?? Alex quasado Alexander Adam distinct is a method of 

Hi, I'm getting a NullPointerException thrown on using DISTINCT. The query works fine if I don't have distinct. However thats NOT a solution as the code generating the query is used for other queries, and some of them do need the distinct. Its only a simple query:

; distinct(  boolean distinct) distinct has not been specified ... > Parameters: distinct - boolean value specifying

/Subquery" title="Interface in javax.persistence.criteria">Subquery<T> distinct(  boolean distinct) Specify ... value will cause duplicates to be retained. If distinct has not been specified, duplicate results

; distinct(  boolean distinct) distinct has not been specified ... > Parameters: distinct - boolean value specifying

), but they are more lightweight, they are built faster and they consume less memory. SELECT DISTINCT more than once. Duplicate results can be eliminated easily in JPQL by using the DISTINCT keyword: SELECT DISTINCT c.currency FROM Country AS c WHERE c.name LIKE 'I

> GROUP BY as DISTINCT (no Aggregates) DISTINCT operator ... class="pre-query"> SELECT DISTINCT SUBSTRING(c.name, 1, 1) FROM Country c GROUP BY

It is getting more and more frustrating :( We've introduced distinct select instead ... : com.objectdb.o.UserException: Invalid order expression '$3' for distinct results at com.objectdb.o ... > support Support hi, Well, the query works perfect without using distinct select

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 ... DISTINCT and you will see no problems with this query Second, I have attached