From d6cdf147c4fcf6e9bfab12c77ed1c9faef60f79a Mon Sep 17 00:00:00 2001 From: Eric Bollengier Date: Mon, 28 Apr 2008 18:13:47 +0000 Subject: [PATCH] ebl Fix SQL query in migration code git-svn-id: https://bacula.svn.sourceforge.net/svnroot/bacula/trunk@6851 91ce42f0-d328-0410-95d8-f526ca767f89 --- bacula/src/dird/migrate.c | 2 +- bacula/technotes-2.3 | 1 + 2 files changed, 2 insertions(+), 1 deletion(-) diff --git a/bacula/src/dird/migrate.c b/bacula/src/dird/migrate.c index c9618d5df0..27b201af51 100644 --- a/bacula/src/dird/migrate.c +++ b/bacula/src/dird/migrate.c @@ -542,7 +542,7 @@ const char *sql_oldest_vol = /* Get JobIds when we have selected MediaId */ const char *sql_jobids_from_mediaid = "SELECT DISTINCT Job.JobId,Job.StartTime FROM JobMedia,Job" - " WHERE JobMedia.JobId=Job.JobId AND JobMedia.MediaId=%s" + " WHERE JobMedia.JobId=Job.JobId AND JobMedia.MediaId IN (%s)" " AND Job.Type='B'" " ORDER by Job.StartTime"; diff --git a/bacula/technotes-2.3 b/bacula/technotes-2.3 index f9f5b52f4f..24152de4c0 100644 --- a/bacula/technotes-2.3 +++ b/bacula/technotes-2.3 @@ -25,6 +25,7 @@ Add long term statistics job table General: 28Apr08 +ebl Fix SQL query in migration code. ebl Make accurate mode with hash disk pass regression tests 27Apr08 ebl Implement first cut of accurate backup with hash disk. -- 2.39.5