db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Manish Khettry (JIRA)" <derby-...@db.apache.org>
Subject [jira] Created: (DERBY-466) Distinct in subselect can return wrong results
Date Wed, 20 Jul 2005 00:30:47 GMT
Distinct in subselect can return wrong results

         Key: DERBY-466
         URL: http://issues.apache.org/jira/browse/DERBY-466
     Project: Derby
        Type: Bug
  Components: SQL  
 Environment: All Platforms
    Reporter: Manish Khettry

The second query should return two rows but returns just one.

ij> select * from t1;
I          |V         
1          |row 1     
2          |row 2     

2 rows selected
ij> select * from t1, (select distinct 1 from t1) as sub(c);
I          |V         |C          
1          |row 1     |1          

1 row selected

More specifically, this bug will show up when the sql layer does duplication elimination for
distinct *without* a sorter (i.e. the underlying result set is already sorted). The result
set will return correct data the first time, but after it is closed and re-opened it will
not return any data rows.

This message is automatically generated by JIRA.
If you think it was sent incorrectly contact one of the administrators:
For more information on JIRA, see:

View raw message