On Saturday 23 June 2007 15:23, Sergey Svishchev wrote: > Good day, > > If a job spans multiple volumes, it will be inserted into the list of > candidates multiple times. Proposed fix attached.
Hmmm. Not too good. Thanks for spotting that. I'll look over your patch in more detail, but it seems to me that the basic flaw is back in the original SQL statement. It probably needs to be "enhanced". Typically for this kind of problem one just needs to add a DISTINCT keyword in the SQL that is getting the JobIds to avoid pulling the JobId twice because of muliple JobMedia or Media records. Regards, Kern > > -- > Sergey Svishchev > ------------------------------------------------------------------------- This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ _______________________________________________ Bacula-devel mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/bacula-devel
