Description of problem:

When using getSubmissionID() to scan by qdate, mode = BEFORE, Aviary returns duplicate submission records.  The results of getSubmissionSummary() and getSubmissionID() scanning by name do not return duplicates.

Version-Release number of selected component (if applicable):

condor-aviary-7.8.3-0.1.el5

How reproducible:

100%

Steps to Reproduce:
1. Set up a condor installation with condor_aviary (I used the locator)
2. Submit multiple jobs 
3. Use the test programs in /usr/share/condor/aviary to retrieve submissions (shown below under Actual Results)
  
Actual results:

[root@somehost aviary]# ./locator.py --type=ANY
SCHEDULER | JOB | job.com | http://somehost.redhat.com:59108/services/job/
CUSTOM | QUERY_SERVER | query.com | http://somehost.redhat.com:45405/services/query/

[root@somehost aviary]# ./submissions.py --u=http://somehost.redhat.com:45405/services/query/getSubmissionSummary
[(SubmissionSummary){
   id = 
      (SubmissionID){
         name = "cat"
         owner = "admin"
         qdate = 1343740287
      }
   status = 
      (Status){
         code = "OK"
      }
   completed = 4
   held = 0
   idle = 0
   removed = 3
   running = 0
   suspended = 0
   transferring_output = 0
 }, (SubmissionSummary){
   id = 
      (SubmissionID){
         name = "dan"
         owner = "tmckay"
         qdate = 1345136722
      }
   status = 
      (Status){
         code = "OK"
      }
   completed = 0
   held = 0
   idle = 0
   removed = 1
   running = 0
   suspended = 0
   transferring_output = 0
 }, (SubmissionSummary){
   id = 
      (SubmissionID){
         name = "dog"
         owner = "admin"
         qdate = 1343740373
      }
   status = 
      (Status){
         code = "OK"
      }
   completed = 1
   held = 0
   idle = 0
   removed = 1
   running = 0
   suspended = 0
   transferring_output = 0
 }, (SubmissionSummary){
   id = 
      (SubmissionID){
         name = "george"
         owner = "tmckay"
         qdate = 1344006972
      }
   status = 
      (Status){
         code = "OK"
      }
   completed = 212
   held = 0
   idle = 0
   removed = 39
   running = 1
   suspended = 0
   transferring_output = 0
 }, (SubmissionSummary){
   id = 
      (SubmissionID){
         name = "jack"
         owner = "tmckay"
         qdate = 1345134766
      }
   status = 
      (Status){
         code = "OK"
      }
   completed = 0
   held = 0
   idle = 0
   removed = 0
   running = 1
   suspended = 0
   transferring_output = 0
 }, (SubmissionSummary){
   id = 
      (SubmissionID){
         name = "joe"
         owner = "joe"
         qdate = 1345048823
      }
   status = 
      (Status){
         code = "OK"
      }
   completed = 0
   held = 0
   idle = 0
   removed = 1
   running = 0
   suspended = 0
   transferring_output = 0
 }, (SubmissionSummary){
   id = 
      (SubmissionID){
         name = "test"
         owner = "tmckay"
         qdate = 1345048400
      }
   status = 
      (Status){
         code = "OK"
      }
   completed = 3
   held = 0
   idle = 0
   removed = 2
   running = 0
   suspended = 0
   transferring_output = 0
 }]


[root@somehost aviary]# ./submission_ids.py --u=http://somehost.redhat.com:45405/services/query/getSubmissionID --size=24 --name=cat
(reply){
   ids[] = 
      (SubmissionID){
         name = "cat"
         owner = "admin"
         qdate = 1343740287
      },
      (SubmissionID){
         name = "dan"
         owner = "tmckay"
         qdate = 1345136722
      },
      (SubmissionID){
         name = "dog"
         owner = "admin"
         qdate = 1343740373
      },
      (SubmissionID){
         name = "george"
         owner = "tmckay"
         qdate = 1344006972
      },
      (SubmissionID){
         name = "jack"
         owner = "tmckay"
         qdate = 1345134766
      },
      (SubmissionID){
         name = "joe"
         owner = "joe"
         qdate = 1345048823
      },
      (SubmissionID){
         name = "test"
         owner = "tmckay"
         qdate = 1345048400
      },
   remaining = 0
 }

[root@somehost aviary]# ./submission_ids.py --u=http://somehost.redhat.com:45405/services/query/getSubmissionID --size=24 --qdate=2000000000 --mode=BEFORE
(reply){
   ids[] = 
      (SubmissionID){
         name = "jack"
         owner = "tmckay"
         qdate = 1345134766
      },
      (SubmissionID){
         name = "george"
         owner = "tmckay"
         qdate = 1344006972
      },
      (SubmissionID){
         name = "george"
         owner = "tmckay"
         qdate = 1344006972
      },
      (SubmissionID){
         name = "dan"
         owner = "tmckay"
         qdate = 1345136722
      },
      (SubmissionID){
         name = "test"
         owner = "tmckay"
         qdate = 1345048400
      },
      (SubmissionID){
         name = "test"
         owner = "tmckay"
         qdate = 1345048400
      },
      (SubmissionID){
         name = "dog"
         owner = "admin"
         qdate = 1343740373
      },
      (SubmissionID){
         name = "cat"
         owner = "admin"
         qdate = 1343740287
      },
      (SubmissionID){
         name = "cat"
         owner = "admin"
         qdate = 1343740287
      },
      (SubmissionID){
         name = "cat"
         owner = "admin"
         qdate = 1343740287
      },
      (SubmissionID){
         name = "cat"
         owner = "admin"
         qdate = 1343740287
      },
      (SubmissionID){
         name = "joe"
         owner = "joe"
         qdate = 1345048823
      },
      (SubmissionID){
         name = "cat"
         owner = "admin"
         qdate = 1343740287
      },
      (SubmissionID){
         name = "test"
         owner = "tmckay"
         qdate = 1345048400
      },
      (SubmissionID){
         name = "test"
         owner = "tmckay"
         qdate = 1345048400
      },
      (SubmissionID){
         name = "test"
         owner = "tmckay"
         qdate = 1345048400
      },
      (SubmissionID){
         name = "george"
         owner = "tmckay"
         qdate = 1344006972
      },
      (SubmissionID){
         name = "george"
         owner = "tmckay"
         qdate = 1344006972
      },
      (SubmissionID){
         name = "george"
         owner = "tmckay"
         qdate = 1344006972
      },
      (SubmissionID){
         name = "george"
         owner = "tmckay"
         qdate = 1344006972
      },
      (SubmissionID){
         name = "george"
         owner = "tmckay"
         qdate = 1344006972
      },
      (SubmissionID){
         name = "cat"
         owner = "admin"
         qdate = 1343740287
      },
      (SubmissionID){
         name = "dog"
         owner = "admin"
         qdate = 1343740373
      },
      (SubmissionID){
         name = "cat"
         owner = "admin"
         qdate = 1343740287
      },
   remaining = 0
 }

Expected results:

Scans by qdate should not include duplicates

Additional info: