use warnings;
use base 'DBIx::Class::ResultSet';
-__PACKAGE__->load_components('Helper::ResultSet');
use Debbugs::DB::Util qw(select_one);
-use List::MoreUtils qw(natatime);
+use List::AllUtils qw(natatime);
=over
INSERT INTO bug_status_cache AS bsc
(bug,suite,arch,status,modified,asof)
VALUES (?,?,?,?,NOW(),NOW())
-ON CONFLICT (bug,suite,arch) DO
+ON CONFLICT (bug,COALESCE(suite,0),COALESCE(arch,0)) DO
UPDATE
SET asof=NOW(),modified=CASE WHEN bsc.status=? THEN bsc.modified ELSE NOW() END
RETURNING status;