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

[Matt S Trout]

On Sun, Nov 11, 2007 at 12:46:05AM +0300, dreel at bk.ru wrote:
> 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.

Don't reply to an existing message to start a new thread, your mail will
get lost.

-- 
      Matt S Trout       Need help with your Catalyst or DBIx::Class project?
   Technical Director                    http://www.shadowcat.co.uk/catalyst/
 Shadowcat Systems Ltd.  Want a managed development or deployment platform?
http://chainsawblues.vox.com/            http://www.shadowcat.co.uk/servers/