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] Assigned: (DERBY-466) Distinct in subselect can return wrong results
Date Wed, 20 Jul 2005 00:30:49 GMT
     [ http://issues.apache.org/jira/browse/DERBY-466?page=all ]

Manish Khettry reassigned DERBY-466:
------------------------------------

    Assign To: Manish Khettry

> 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
>     Assignee: 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:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira


Mime
View raw message