[Dbix-class] Chained searches and pager usage

[Nilson Santos Figueiredo Junior]

There's a currently known bug regarding paged resultsets when using
nested searches, ie:

  $rs->search(
      { field =3D> $value },
      { page =3D> $page }
  )->search(
      { another_field =3D> $another_value }
  );

This will usually produce wrong results for any page except the first.
Attached you'll find a patch against trunk for dbic's test suite which
tests this situation (and currently fails) as requested.

-Nilson Santos F. Jr.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: chained-search-paging.diff
Type: application/octet-stream
Size: 646 bytes
Desc: not available
Url : http://lists.scsys.co.uk/pipermail/dbix-class/attachments/20061215/57=
a74898/chained-search-paging.obj