db-jdo-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Andy Jefferson (JIRA)" <j...@apache.org>
Subject [jira] Commented: (JDO-529) ChangeQuery - DISTINCT is expected even though it is not specified
Date Thu, 20 Sep 2007 11:29:31 GMT

    [ https://issues.apache.org/jira/browse/JDO-529?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12529067
] 

Andy Jefferson commented on JDO-529:
------------------------------------

This query now has the ordering constraint of 
firstname, lastname ASCENDING

If I read the spec 14.6.6 it says 
"The ordering statement is a String containing one or more ordering declarations separated
by commas. Each ordering declaration is a Java expression of an orderable type:
  • primitives (boolean is non-portable);
  • wrappers (Boolean is non-portable);
  • BigDecimal;
  • BigInteger;
  • String;
  • Date
followed by one of the following words: "ascending", "descending","asc", or "desc"."

So shouldn't the ordering constraint should be 
firstname ASCENDING, lastname ASCENDING
???
"firstname ASCENDING" is an "ordering declaration" using spec verbage, as is "lastname ASCENDING".
Unless we're having inbuilt default of ASCENDING, but I didn't read that from the spec.

> ChangeQuery - DISTINCT is expected even though it is not specified
> ------------------------------------------------------------------
>
>                 Key: JDO-529
>                 URL: https://issues.apache.org/jira/browse/JDO-529
>             Project: JDO
>          Issue Type: Test
>          Components: tck2
>            Reporter: Ilan Kirsh
>            Assignee: Craig Russell
>             Fix For: JDO 2 maintenance release 1
>
>         Attachments: jdo-529.patch
>
>
> Test org.apache.jdo.tck.query.api.ChangeQuery expects 3 result objects:
> List expectedResult = Arrays.asList(new Object[] {
>             new FullName("emp1First", "emp1Last"), 
>             new FullName("emp2First", "emp2Last"),
>             new FullName("emp5First", "emp5Last")});
> But actually there should be 4 result objects:
> List expectedResult = Arrays.asList(new Object[] {
>             new FullName("emp1First", "emp1Last"), 
>             new FullName("emp2First", "emp2Last"),
>             new FullName("emp2First", "emp2Last"),
>             new FullName("emp5First", "emp5Last")});
> because the result is not specified as DISTINCT.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message