Skip Menu |
 

This queue is for tickets about the DBD-SQLite CPAN distribution.

Report information
The Basics
Id: 26460
Status: resolved
Priority: 0/
Queue: DBD-SQLite

People
Owner: Nobody in particular
Requestors: tvmaly [...] gmail.com
Cc:
AdminCc:

Bug Information
Severity: Important
Broken in: 1.13
Fixed in: (no value)



Subject: Sorting numeric values in aggregate functions
Download (untitled) / with headers
text/plain 250b
I have a table that has a column sales NUMERIC(20,3) that can have both positive and negative values if I try to get a sum over a date range and sort by that aggregate value with a limit to 40 results it does not correctly sort by numeric order.
Download (untitled) / with headers
text/plain 233b
I've added a regression test for this group/sum/sort/limit style query, but I can't replicate your problem. I'm tentatively resolving this ticket. If you are still having this problem in 1.19_09 or higher, please reopen this ticket.


This service is sponsored and maintained by Best Practical Solutions and runs on Perl.org infrastructure.

Please report any issues with rt.cpan.org to rt-cpan-admin@bestpractical.com.