From 63db0a310ea18fe03e5127d9e688e6fc8486a704 Mon Sep 17 00:00:00 2001 From: Marco van Wieringen Date: Tue, 27 Apr 2010 21:05:38 +0200 Subject: [PATCH] Change Ingres query filter to set a realy early timestamp instead of an empty string which doesn't seem to work on all Ingres versions. --- 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 9c3a7c3b5f..7ed398e2ca 100644 --- a/bacula/src/cats/sql_cmds.c +++ b/bacula/src/cats/sql_cmds.c @@ -954,7 +954,7 @@ const char *sql_media_order_most_recently_written[5] = { /* SQLite3 */ "ORDER BY LastWritten IS NULL,LastWritten DESC,MediaId", /* Ingres */ - "ORDER BY IFNULL(LastWritten, '') DESC,MediaId" + "ORDER BY IFNULL(LastWritten, '1970-01-01 00:00:00') DESC,MediaId" }; const char *sql_get_max_connections[5] = { -- 2.39.5