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