[Dbix-class] offset being doubled when creating a resultset from an existing resultset.

[brett gardner]

Okay if you have the following resultset

$rs = $schema->resultset('Foo')->search(
   undef,
   {
      page=>1,
      rows=>5
   }
);
Which would generate the following SQL when $rs->next is called

SELECT ... FROM ... WHERE ... LIMIT 5 OFFSET 5;

and then create a resultset from this again

$new_rs = $rs->search({foo=>'bar'});

This creates the following SQL when $new_rs->next is called.

SELECT ... FROM ... WHERE ... LIMIT 5 OFFSET 10;

Setting the 'page' in the $new_rs attributes does not fix this. Only by 
setting the
'offset' attribute to 0 is this fixed.

Is this behaviour by design or a fault?


_______________________________________________
List: http://lists.rawmode.org/cgi-bin/mailman/listinfo/dbix-class
Wiki: http://dbix-class.shadowcatsystems.co.uk/
IRC: irc.perl.org#dbix-class
SVN: http://dev.catalyst.perl.org/repos/bast/trunk/DBIx-Class/
Searchable Archive: http://www.mail-archive.com/dbix-class@lists.rawmode.org/