From ab28a05a26549a45eb6f119e80e451846c78bcd3 Mon Sep 17 00:00:00 2001 From: Fridolin Somers Date: Tue, 21 Jul 2020 12:26:55 +0200 Subject: [PATCH] Bug 26032: Add unit test Run prove t/db_dependent/Items.t --- t/db_dependent/Items.t | 15 ++++++++++++++- 1 file changed, 14 insertions(+), 1 deletion(-) diff --git a/t/db_dependent/Items.t b/t/db_dependent/Items.t index 010b41e97a..197e2e7667 100755 --- a/t/db_dependent/Items.t +++ b/t/db_dependent/Items.t @@ -432,7 +432,7 @@ subtest q{Test Koha::Database->schema()->resultset('Item')->itemtype()} => sub { }; subtest 'SearchItems test' => sub { - plan tests => 15; + plan tests => 17; $schema->storage->txn_begin; my $dbh = C4::Context->dbh; @@ -630,6 +630,19 @@ subtest 'SearchItems test' => sub { ($items, $total_results) = SearchItems($filter); is($total_results, 1, "Search items.issues issues = 0 returns result (items.issues defaults to 0)"); + # Is null + $filter = { + field => 'new_status', + query => 0, + operator => '=' + }; + ($items, $total_results) = SearchItems($filter); + ok(scalar @$items == 0, 'found no item with new_status=0 without ifnull'); + + $filter->{ifnull} = 0; + ($items, $total_results) = SearchItems($filter); + ok(scalar @$items == 3, 'found all items with new_status=0 with ifnull = 0'); + $schema->storage->txn_rollback; }; -- 2.27.0