X-Git-Url: https://git.sur5r.net/?a=blobdiff_plain;f=bacula%2Fsrc%2Fcats%2Fsql_cmds.c;h=b739d6d96691d52c062d8acb1d042aa470fdf70c;hb=57c3794986e8cd011788c1ea3bded6bf3bcfa431;hp=26ff05276cf91d783fa75245f0afbc8d6f9f11b7;hpb=edb9e442f3c77b8138aecb12fdb3d89d0a68ad46;p=bacula%2Fbacula

diff --git a/bacula/src/cats/sql_cmds.c b/bacula/src/cats/sql_cmds.c
index 26ff05276c..b739d6d966 100644
--- a/bacula/src/cats/sql_cmds.c
+++ b/bacula/src/cats/sql_cmds.c
@@ -813,6 +813,10 @@ const char *sql_get_max_connections[] = {
    "SELECT 0"
 };
 
+/* TODO: Check for corner cases with MySQL and SQLite3
+ *  The Group By can return strange numbers when having multiple
+ *  version of a file in the same dataset.
+ */
 const char *sql_bvfs_select[] = {
    /* Mysql */
    "CREATE TABLE %s AS ( "
@@ -833,7 +837,12 @@ const char *sql_bvfs_select[] = {
           "WHERE FileIndex > 0)",
 
    /* SQLite3 */
-   "SELECT 0",
+   "CREATE TABLE %s AS "
+      "SELECT JobId, FileIndex, FileId, max(JobTDate) as JobTDate "
+        "FROM btemp%s "
+      "GROUP BY PathId, FilenameId "
+   "HAVING FileIndex > 0",
+   
 
    /* Ingres (TODO) */
    "SELECT 0"