[OPENJPA-420] JPQL constructor query close the <SELECT DISTINCT> feature?

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.0.0
• Fix Version/s: 1.0.2, 1.1.0
• Component/s: kernel
• Assignee: Unassigned
• Reporter: minewile
• Created: 26/Oct/07 07:46
• Updated: 09/Mar/10 18:32
• Resolved: 31/Jan/08 19:43

Description

DISTINCT keyword,It can be supported in the simple query and subquery,but use constructor query,example:select distinct new org.apache.A(a.id...),the distinct keyword is ignored .
I fixed as so:
java file:org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder
private Expression evalSelectClause(QueryExpressions exps) {
if (exps.operation != QueryOperations.OP_SELECT)
return null;

JPQLNode selectNode = root();

JPQLNode constructor = selectNode.findChildByID(JJTCONSTRUCTOR, true);
if (constructor != null)

{ ... // add:now assign the distinct of the select clause JPQLNode selectClause = selectNode.findChildByID(JJTSELECTCLAUSE, false); if (selectClause != null && selectClause.hasChildID(JJTDISTINCT)) exps.distinct = exps.DISTINCT_TRUE | exps.DISTINCT_AUTO; else exps.distinct = exps.DISTINCT_FALSE; return assignProjections(right(constructor), exps); }

else

{ .. }