From be8684bce7c8c866afd3b103d9eff1b1ef944aa6 Mon Sep 17 00:00:00 2001 From: Eric Bollengier Date: Mon, 28 Apr 2008 18:12:20 +0000 Subject: [PATCH] ebl Fix SQL query in migration code git-svn-id: https://bacula.svn.sourceforge.net/svnroot/bacula/branches/Branch-2.2@6850 91ce42f0-d328-0410-95d8-f526ca767f89 --- bacula/src/dird/migrate.c | 2 +- bacula/technotes-2.1 | 2 ++ 2 files changed, 3 insertions(+), 1 deletion(-) diff --git a/bacula/src/dird/migrate.c b/bacula/src/dird/migrate.c index e239197e35..e5fd3fdba4 100644 --- a/bacula/src/dird/migrate.c +++ b/bacula/src/dird/migrate.c @@ -535,7 +535,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.1 b/bacula/technotes-2.1 index eabd080bff..ecffb41d9c 100644 --- a/bacula/technotes-2.1 +++ b/bacula/technotes-2.1 @@ -1,6 +1,8 @@ Technical notes on version 2.2 General: +28Apr08 +ebl Fix SQL query in migration code 19Apr08 kes Force unload of volume when wrong volume mounted in SD. 17Apr08 -- 2.39.5