From 626b80d3bc5887e032753eac3e4b98fa0f15210f Mon Sep 17 00:00:00 2001 From: Dan Langille Date: Fri, 12 Dec 2003 16:09:56 +0000 Subject: [PATCH] remove GROUP BY on db_get_job_volume_names. REVIEW. git-svn-id: https://bacula.svn.sourceforge.net/svnroot/bacula/trunk@876 91ce42f0-d328-0410-95d8-f526ca767f89 --- bacula/src/cats/sql_get.c | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/bacula/src/cats/sql_get.c b/bacula/src/cats/sql_get.c index 4c47c1ebbd..e93a09ea90 100644 --- a/bacula/src/cats/sql_get.c +++ b/bacula/src/cats/sql_get.c @@ -323,7 +323,7 @@ int db_get_job_volume_names(JCR *jcr, B_DB *mdb, uint32_t JobId, POOLMEM **Volum Mmsg(&mdb->cmd, "SELECT VolumeName,JobMedia.VolIndex FROM JobMedia,Media WHERE " "JobMedia.JobId=%u AND JobMedia.MediaId=Media.MediaId " - "GROUP BY VolumeName ORDER BY JobMedia.VolIndex", JobId); + "ORDER BY JobMedia.VolIndex", JobId); Dmsg1(130, "VolNam=%s\n", mdb->cmd); *VolumeNames[0] = 0; -- 2.39.5