History entries may not be ordered correctly after rapid password changes

Code to get password history from database:

  $query = db_select('password_policy_history', 'p');
  $query
    ->condition('p.uid', array_keys($accounts)) 
    ->fields('p', array('uid', 'pass', 'created'))
    ->orderBy('created', 'DESC');
    
  foreach ($query->execute() as $record) {
    $accounts[$record->uid]->password_history[] = $record;
  }

The order will be unspecified for multiple passwords submitted in same second.

This affects automated tests where multiple password changes may happen in the same second.