"Name TEXT)",
/* Ingres */
"DECLARE GLOBAL TEMPORARY TABLE basefile%lld ("
- "Path TEXT NOT NULL,"
- "Name TEXT NOT NULL)"
+ "Path VARBYTE(32000) NOT NULL,"
+ "Name VARBYTE(32000) NOT NULL) "
"ON COMMIT PRESERVE ROWS WITH NORECOVERY"
};
"FROM ( %s ) AS Temp "
"JOIN Filename ON (Filename.FilenameId = Temp.FilenameId) "
"JOIN Path ON (Path.PathId = Temp.PathId) "
- "WHERE Temp.FileIndex > 0"
+ "WHERE Temp.FileIndex > 0 "
"ON COMMIT PRESERVE ROWS WITH NORECOVERY",
};
"PurgedFiles SMALLINT, "
"FileSetId INTEGER, "
"JobFiles INTEGER, "
- "JobStatus char(1))"
+ "JobStatus CHAR(1)) "
+ "ON COMMIT PRESERVE ROWS WITH NORECOVERY"
+};
+
+/* ======= ua_purge.c */
+
+/* Select the first available Copy Job that must be upgraded to a Backup job when the original backup job is expired. */
+
+const char *uap_upgrade_copies_oldest_job_default =
+"CREATE TEMPORARY TABLE cpy_tmp AS "
+ "SELECT MIN(JobId) AS JobId FROM Job " /* Choose the oldest job */
+ "WHERE Type='%c' " /* JT_JOB_COPY */
+ "AND ( PriorJobId IN (%s) " /* JobId selection */
+ "OR "
+ " PriorJobId IN ( "
+ "SELECT PriorJobId "
+ "FROM Job "
+ "WHERE JobId IN (%s) " /* JobId selection */
+ " AND Type='B' "
+ ") "
+ ") "
+ "GROUP BY PriorJobId "; /* one result per copy */
+
+const char *uap_upgrade_copies_oldest_job[5] = {
+ /* Mysql */
+ uap_upgrade_copies_oldest_job_default,
+ /* Postgresql */
+ uap_upgrade_copies_oldest_job_default,
+ /* SQLite */
+ uap_upgrade_copies_oldest_job_default,
+ /* SQLite3 */
+ uap_upgrade_copies_oldest_job_default,
+ /* Ingres */
+ "DECLARE GLOBAL TEMPORARY TABLE cpy_tmp AS "
+ "SELECT MIN(JobId) AS JobId FROM Job " /* Choose the oldest job */
+ "WHERE Type='%c' " /* JT_JOB_COPY */
+ "AND ( PriorJobId IN (%s) " /* JobId selection */
+ "OR "
+ " PriorJobId IN ( "
+ "SELECT PriorJobId "
+ "FROM Job "
+ "WHERE JobId IN (%s) " /* JobId selection */
+ " AND Type='B' "
+ ") "
+ ") "
+ "GROUP BY PriorJobId " /* one result per copy */
"ON COMMIT PRESERVE ROWS WITH NORECOVERY"
};
"JobId INTEGER NOT NULL,"
"JobTDate BIGINT,"
"ClientId INTEGER,"
- "Level CHAR,"
+ "Level CHAR(1),"
"JobFiles INTEGER,"
"JobBytes BIGINT,"
- "StartTime VARCHAR(256),"
- "VolumeName VARCHAR(256),"
+ "StartTime TIMESTAMP WITHOUT TIME ZONE,"
+ "VolumeName VARBYTE(128),"
"StartFile INTEGER,"
"VolSessionId INTEGER,"
- "VolSessionTime INTEGER)"
+ "VolSessionTime INTEGER) "
"ON COMMIT PRESERVE ROWS WITH NORECOVERY"
};
/* Ingres */
"DECLARE GLOBAL TEMPORARY TABLE temp1 ("
"JobId INTEGER NOT NULL,"
- "JobTDate BIGINT)"
+ "JobTDate BIGINT) "
"ON COMMIT PRESERVE ROWS WITH NORECOVERY"
};
/* 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] = {