diff options
| -rw-r--r-- | lib/App/BorgRestore/DB.pm | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/lib/App/BorgRestore/DB.pm b/lib/App/BorgRestore/DB.pm index 010f916..3c9e0fb 100644 --- a/lib/App/BorgRestore/DB.pm +++ b/lib/App/BorgRestore/DB.pm @@ -171,7 +171,7 @@ method add_path($archive_id, $path, $time) { method update_path_if_greater($archive_id, $path, $time) { $self->_insert_path($archive_id, $path, $time); - my $st = $self->{dbh}->prepare_cached('update files set `'.$archive_id.'` = ? where `path` = ? and `'.$archive_id.'` < ?'); + my $st = $self->{dbh}->prepare_cached('update files set `'.$archive_id.'` = ? where `path` = ? and (`'.$archive_id.'` < ? or `'.$archive_id.'` is null)'); $st->execute($time, $path, $time); } |