2 This patch fixes a case problem in an SQL command, and could potentially
3 fix the DiskToCatalog problem reported in bug #1149.
4 Apply the patch to version 2.4.2 (and previous versions) with:
7 patch -p0 <2.4.2-verifydisk.patch
8 ./configure <your-options>
14 Index: src/cats/sql_get.c
15 ===================================================================
16 --- src/cats/sql_get.c (revision 7507)
17 +++ src/cats/sql_get.c (working copy)
20 "SELECT FileId, LStat, MD5 FROM File,Job WHERE "
21 "File.JobId=Job.JobId AND File.PathId=%s AND "
22 -"File.FilenameId=%s AND Job.Type='B' AND Job.JobSTATUS='T' AND "
23 +"File.FilenameId=%s AND Job.Type='B' AND Job.JobStatus='T' AND "
24 "ClientId=%s ORDER BY StartTime DESC LIMIT 1",
25 edit_int64(fdbr->PathId, ed1),
26 edit_int64(fdbr->FilenameId, ed2),