db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Peter Balon (JIRA)" <j...@apache.org>
Subject [jira] Created: (DERBY-3231) Sorting on COUNT with OR and GROUP BY delivers wrong results.
Date Tue, 27 Nov 2007 10:16:43 GMT
Sorting on COUNT with OR and GROUP BY delivers wrong results.
-------------------------------------------------------------

                 Key: DERBY-3231
                 URL: https://issues.apache.org/jira/browse/DERBY-3231
             Project: Derby
          Issue Type: Bug
          Components: SQL
    Affects Versions: 10.3.1.4
         Environment: Eclipse 3.2.2; java 1.5.0_11; 
            Reporter: Peter Balon
            Priority: Critical


The result of the select is not sorted in "order by COUNT(*) DESC" or "order by COUNT(*) ASC"


create table yy (a double, b double);

insert into yy values (2, 4);
insert into yy values (5, 7);
insert into yy values (2, 3);
insert into yy values (2, 3);
insert into yy values (2, 3);
insert into yy values (2, 3);
insert into yy values (9, 7);


select b, COUNT(*) AS "COUNT_OF", SUM(b) AS "sum b" 
from yy
where a = 5 or a = 2
group by b
order by COUNT(*) asc

-- same result as:

select b, COUNT(*) AS "COUNT_OF", SUM(b) AS "sum b" 
from yy
where a = 5 or a = 2
group by b
order by COUNT(*) desc


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