@@ -, +, @@ --- t/db_dependent/Items.t | 15 ++++++++++++++- 1 file changed, 14 insertions(+), 1 deletion(-) --- a/t/db_dependent/Items.t +++ a/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; }; --