db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Knut Anders Hatlen (JIRA)" <j...@apache.org>
Subject [jira] Created: (DERBY-4331) Join returns results in wrong order
Date Sat, 01 Aug 2009 23:14:14 GMT
Join returns results in wrong order
-----------------------------------

                 Key: DERBY-4331
                 URL: https://issues.apache.org/jira/browse/DERBY-4331
             Project: Derby
          Issue Type: Bug
          Components: SQL
    Affects Versions: 10.5.2.0
            Reporter: Knut Anders Hatlen


In Derby 10.5.2.0, the query below started returning results in wrong order (note the ORDER
BY clause). Derby 10.5.1.1 gives the expected ordering.

ij> SELECT CS.ID
FROM
    CHANGESETS CS, FILECHANGES FC, REPOSITORIES R, FILES F, AUTHORS A
WHERE
    R.PATH = '/var/tmp/source5923202038296723704opengrok/mercurial' AND F.REPOSITORY = R.ID
AND A.REPOSITORY = R.ID AND
    CS.REPOSITORY = R.ID AND CS.ID = FC.CHANGESET AND F.ID = FC.FILE AND
    A.ID = CS.AUTHOR AND
    EXISTS (
        SELECT 1
        FROM FILES F2
        WHERE
            F2.ID = FC.FILE AND F2.REPOSITORY = R.ID AND
            F2.PATH LIKE '/%' ESCAPE '#')
ORDER BY CS.ID DESC;
ID         
-----------
1          
2          
3          
2          
2          
3          

6 rows selected

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