Merge 'trunk' into 'prefetch'

[dbsrgits/DBIx-Class.git] / t / 67pager.t

diff --git a/t/67pager.t b/t/67pager.t
index 17b05c3..6a6aabc 100644 (file)
--- a/t/67pager.t
+++ b/t/67pager.t
@@ -84,3 +84,19 @@ is($p->(), 10, 'default rows is 10');
 $schema->default_resultset_attributes({ rows => 5 });
 
 is($p->(), 5, 'default rows is 5');
+
+# test page with offset
+$it = $schema->resultset('CD')->search({}, {
+    rows => 2,
+    page => 2,
+    offset => 1,
+    order_by => 'cdid'
+});
+
+my $row = $schema->resultset('CD')->search({}, {
+    order_by => 'cdid', 
+    offset => 3,
+    rows => 1
+})->single;
+
+is($row->cdid, $it->first->cdid, 'page with offset');