Drop Ingres specific versions of queries with #ifdefs

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

diff --git a/bacula/src/cats/sql_cmds.c b/bacula/src/cats/sql_cmds.c
index 84e2ddf0192d29e9f57c95881a383ae8d57bcbca..8679dd0e16699a9ceba37445e4f0f2c0bfcc13af 100644 (file)
--- a/bacula/src/cats/sql_cmds.c
+++ b/bacula/src/cats/sql_cmds.c
@@ -722,7 +722,7 @@ const char *uar_file[5] = {
    "AND Client.ClientId=Job.ClientId "
    "AND Job.JobId=File.JobId AND File.FileIndex > 0 "
    "AND Path.PathId=File.PathId AND Filename.FilenameId=File.FilenameId "
-   "AND Filename.Name='%s' ORDER BY StartTime DESC LIMIT 20"
+   "AND Filename.Name='%s' ORDER BY StartTime DESC FETCH FIRST 20 ROWS ONLY"
    };
 
 const char *uar_create_temp[5] = {
@@ -786,8 +786,8 @@ const char *uar_create_temp[5] = {
    "Level CHAR,"
    "JobFiles INTEGER,"
    "JobBytes BIGINT,"
-   "StartTime TEXT,"
-   "VolumeName TEXT,"
+   "StartTime VARCHAR(256),"
+   "VolumeName VARCHAR(256),"
    "StartFile INTEGER,"
    "VolSessionId INTEGER,"
    "VolSessionTime INTEGER)"