From baa7b9a7e5686ebf7eb9947e3dca8705be2a3728 Mon Sep 17 00:00:00 2001
From: Eric Bollengier <eric@eb.homelinux.org>
Date: Thu, 7 Oct 2010 20:28:54 +0200
Subject: [PATCH] bvfs: fix mysql query, restore seems to be ok

---
 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 a1bbd698c9..48c27152bb 100644
--- a/bacula/src/cats/sql_cmds.c
+++ b/bacula/src/cats/sql_cmds.c
@@ -922,7 +922,7 @@ const char *sql_bvfs_select[5] = {
       "SELECT max(JobId) as JobId, FileIndex, FileId "
         "FROM btemp%s "
       "GROUP BY PathId, FilenameId "
-   "HAVING FileIndex > 0 ",
+   "HAVING FileIndex > 0)",
    /* Postgresql */
    "CREATE TABLE %s AS ( "
         "SELECT JobId, FileIndex, FileId "
-- 
2.39.5