From 2a9078f30a25b9f127c3c1fb54ad4593dbc32113 Mon Sep 17 00:00:00 2001 From: Kern Sibbald Date: Thu, 12 Feb 2004 13:36:20 +0000 Subject: [PATCH] Apply sql_find fix for sorting NULL LastWritten git-svn-id: https://bacula.svn.sourceforge.net/svnroot/bacula/trunk@1048 91ce42f0-d328-0410-95d8-f526ca767f89 --- bacula/src/cats/sql_find.c | 2 +- bacula/src/version.h | 4 ++-- 2 files changed, 3 insertions(+), 3 deletions(-) diff --git a/bacula/src/cats/sql_find.c b/bacula/src/cats/sql_find.c index c7cb8d1369..c192b09110 100644 --- a/bacula/src/cats/sql_find.c +++ b/bacula/src/cats/sql_find.c @@ -226,7 +226,7 @@ db_find_next_volume(JCR *jcr, B_DB *mdb, int item, bool InChanger, MEDIA_DBR *mr Mmsg(&mdb->cmd, "SELECT MediaId,VolumeName,VolJobs,VolFiles,VolBlocks," "VolBytes,VolMounts,VolErrors,VolWrites,MaxVolBytes,VolCapacityBytes," "VolRetention,VolUseDuration,MaxVolJobs,MaxVolFiles,Recycle,Slot," - "FirstWritten,LastWritten,VolStatus " + "FirstWritten,IFNULL(LastWritten,0),VolStatus " "FROM Media WHERE PoolId=%u AND MediaType='%s' AND VolStatus IN ('Full'," "'Recycle','Purged','Used','Append') " "ORDER BY LastWritten LIMIT 1", mr->PoolId, mr->MediaType); diff --git a/bacula/src/version.h b/bacula/src/version.h index a9e90ddd16..9646139af4 100644 --- a/bacula/src/version.h +++ b/bacula/src/version.h @@ -2,8 +2,8 @@ #undef VERSION #define VERSION "1.33.3" #define VSTRING "1" -#define BDATE "10 Feb 2004" -#define LSMDATE "10Feb04" +#define BDATE "12 Feb 2004" +#define LSMDATE "12Feb04" /* Debug flags */ #undef DEBUG -- 2.39.5