From fbee9f0755bdddb660eda7cb9ca2b9998146dab6 Mon Sep 17 00:00:00 2001 From: Eric Bollengier Date: Sun, 21 Nov 2010 12:35:13 +0100 Subject: [PATCH] Add missing MarkId in mysql accurate query --- bacula/src/cats/sql_cmds.c | 8 ++++---- 1 file changed, 4 insertions(+), 4 deletions(-) diff --git a/bacula/src/cats/sql_cmds.c b/bacula/src/cats/sql_cmds.c index 9dac77f7f7..7549452d3b 100644 --- a/bacula/src/cats/sql_cmds.c +++ b/bacula/src/cats/sql_cmds.c @@ -367,12 +367,12 @@ const char *select_recent_version_with_basejob_and_delta_default = "FROM Job, File, ( " "SELECT MAX(JobTDate) AS JobTDate, PathId, FilenameId, MarkId " "FROM ( " - "SELECT JobTDate, PathId, FilenameId " /* Get all normal files */ - "FROM File JOIN Job USING (JobId) " /* from selected backup */ + "SELECT JobTDate, PathId, FilenameId, MarkId " /* Get all normal files */ + "FROM File JOIN Job USING (JobId) " /* from selected backup */ "WHERE File.JobId IN (%s) " "UNION ALL " - "SELECT JobTDate, PathId, FilenameId " /* Get all files from */ - "FROM BaseFiles " /* BaseJob */ + "SELECT JobTDate, PathId, FilenameId, MarkId " /* Get all files from */ + "FROM BaseFiles " /* BaseJob */ "JOIN File USING (FileId) " "JOIN Job ON (BaseJobId = Job.JobId) " "WHERE BaseFiles.JobId IN (%s) " /* Use Max(JobTDate) to find */ -- 2.39.5