From 23a3967e89ade4492596ff74b2a50f5c0c08921e Mon Sep 17 00:00:00 2001 From: Marco van Wieringen Date: Mon, 5 Apr 2010 15:42:24 +0200 Subject: [PATCH] Lets call it COMMIT and not END as that seems to be the counterpart of BEGIN for transactions. Updated Ingres lock queries to only start a transaction as the current SQL is not valid Ingres SQL. --- bacula/src/cats/dbi.c | 8 ++++---- 1 file changed, 4 insertions(+), 4 deletions(-) diff --git a/bacula/src/cats/dbi.c b/bacula/src/cats/dbi.c index 593b130a52..f3c360ad71 100644 --- a/bacula/src/cats/dbi.c +++ b/bacula/src/cats/dbi.c @@ -1283,7 +1283,7 @@ const char *my_dbi_batch_lock_path_query[5] = { "BEGIN", /* SQLite3 */ "BEGIN", - /* Ingres (TODO) */ + /* Ingres */ "BEGIN" }; @@ -1296,7 +1296,7 @@ const char *my_dbi_batch_lock_filename_query[5] = { "BEGIN", /* SQLite3 */ "BEGIN", - /* Ingres (TODO) */ + /* Ingres */ "BEGIN" }; @@ -1332,7 +1332,7 @@ const char *my_dbi_batch_fill_path_query[5] = { "INSERT INTO Path (Path)" " SELECT DISTINCT Path FROM batch" " EXCEPT SELECT Path FROM Path", - /* Ingres (TODO) */ + /* Ingres */ "INSERT INTO Path (Path) " "SELECT a.Path FROM " "(SELECT DISTINCT Path FROM batch) AS a " @@ -1359,7 +1359,7 @@ const char *my_dbi_batch_fill_filename_query[5] = { "INSERT INTO Filename (Name)" " SELECT DISTINCT Name FROM batch " " EXCEPT SELECT Name FROM Filename", - /* Ingres (TODO) */ + /* Ingres */ "INSERT INTO Filename (Name) " "SELECT a.Name FROM " "(SELECT DISTINCT Name FROM batch) as a " -- 2.39.5