From 5889285ed7e7c85020c29753b4b8150cc617d58a Mon Sep 17 00:00:00 2001 From: Eric Bollengier Date: Sun, 21 Nov 2010 13:39:13 +0100 Subject: [PATCH] Yet an other tweak of MySQL accurate query with Delta --- bacula/src/cats/sql_cmds.c | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/bacula/src/cats/sql_cmds.c b/bacula/src/cats/sql_cmds.c index 7549452d3b..8ba88be632 100644 --- a/bacula/src/cats/sql_cmds.c +++ b/bacula/src/cats/sql_cmds.c @@ -362,7 +362,7 @@ const char *select_recent_version_with_basejob[5] = { */ const char *select_recent_version_with_basejob_and_delta_default = "SELECT FileId, Job.JobId AS JobId, FileIndex, File.PathId AS PathId, " - "File.FilenameId AS FilenameId, LStat, MD5, MarkId, " + "File.FilenameId AS FilenameId, LStat, MD5, T1.MarkId AS MarkId, " "Job.JobTDate AS JobTDate " "FROM Job, File, ( " "SELECT MAX(JobTDate) AS JobTDate, PathId, FilenameId, MarkId " -- 2.39.5