From d97be87bf87c6c50bc565c2d09beca164802271c Mon Sep 17 00:00:00 2001 From: Christian Schneider Date: Tue, 21 Apr 2020 15:38:57 +0200 Subject: Add test for LIMIT with offset, add test descriptions --- test/it_dbi.t | 7 +++++-- 1 file changed, 5 insertions(+), 2 deletions(-) diff --git a/test/it_dbi.t b/test/it_dbi.t index dbcc6bb..a5d9f92 100755 --- a/test/it_dbi.t +++ b/test/it_dbi.t @@ -350,8 +350,11 @@ $r->update(['key4' => "val4'", 'key5' => "val5'"]); is($r->_writes, 1); is($r- # Check LIMIT $count = $r->select(['ID >' => 0, 'ORDER BY ID DESC', 'LIMIT' => 1]); -is($count, 1); -is($r->ID, 6); +is($count, 1, "Simple LIMIT: count"); +is($r->ID, 6, "Simple LIMIT: id"); +$count = $r->select(['ID >' => 0, 'ORDER BY ID DESC', 'LIMIT' => "1, 2"]); +is($count, 2, "LIMIT with offset: count"); +is($r->ID, 5, "LIMIT with offset: id"); # Check if iterator clears dynfields left over from previous record $r->delete(["WHERE 1"]); -- cgit v1.2.3