[Dbix-class] Pager bug - last page has more results then entries_on_this_page

[dreel at bk.ru]

There is a bug of SQL::Abstract::Limit.
In my case DB it is SQL Server. But I thibk it's common bug for all
DBD. As I suggest SQL::Abstract::Limit don't consider Data::Page
params generating SQL for DB.

Simplest query it's
SELECT * FROM
(
    SELECT TOP $rows * FROM
    (
        SELECT TOP ($rows*$page}) $sql $order_by_up
    ) AS foo
    $order_by_down
) AS bar
$order_by_up

SQLAL don't consider Data::Page  entries_on_this_page.
Possible decision it's make a generation of query depend on Data::Page
params.

Maybe someone have already done this?
If not, I'll be trying myself to do it.

-- 
 dreel                          mailto:dreel at bk.ru