syntax fix, test improved, empty results fixed

[bacula/bacula] / bacula / src / cats / sql_create.c

diff --git a/bacula/src/cats/sql_create.c b/bacula/src/cats/sql_create.c
index 5290b99e55dc26179c07d72fccce4fe0abb5e6de..256755118fbb34e75c788687f582ea17ef335294 100644 (file)
--- a/bacula/src/cats/sql_create.c
+++ b/bacula/src/cats/sql_create.c
@@ -1126,6 +1126,7 @@ const char *create_temp_basefile[5] = {
    "DECLARE GLOBAL TEMPORARY TABLE basefile%lld (" 
    "Path TEXT NOT NULL,"
    "Name TEXT NOT NULL)"
+   "ON COMMIT PRESERVE ROWS WITH NORECOVERY"
 };
 
 /*