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

Owner: Nobody in particular
Requestors: tvmaly [...]

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

Please report any issues with to