From a17ab8458dcd9ee81a27b73c1d6ccef05f544c02 Mon Sep 17 00:00:00 2001 From: Kern Sibbald Date: Mon, 1 Mar 2010 17:12:39 +0100 Subject: [PATCH] Tweak SQL for future additions --- bacula/src/cats/sql_find.c | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/bacula/src/cats/sql_find.c b/bacula/src/cats/sql_find.c index e492035a51..ee3948b642 100644 --- a/bacula/src/cats/sql_find.c +++ b/bacula/src/cats/sql_find.c @@ -211,7 +211,7 @@ db_find_failed_job_since(JCR *jcr, B_DB *mdb, JOB_DBR *jr, POOLMEM *stime, int & db_lock(mdb); /* Differential is since last Full backup */ Mmsg(mdb->cmd, -"SELECT Level FROM Job WHERE JobStatus!='T' AND Type='%c' AND " +"SELECT Level FROM Job WHERE JobStatus NOT IN ('T') AND Type='%c' AND " "Level IN ('%c','%c') AND Name='%s' AND ClientId=%s " "AND FileSetId=%s AND StartTime>'%s' " "ORDER BY StartTime DESC LIMIT 1", -- 2.39.5