Unknown table 'p.rid': SELECT p.rid.* FROM {role} r {}

PDOException: SQLSTATE[42S02]: Base table or view not found: 1051 Unknown table 'p.rid': SELECT p.rid.* FROM {role} r {} WHERE (r.name = :db_condition_placeholder_0) ; Array ( [:db_condition_placeholder_0] => authenticated user ) in function _password_policy_load_active_policy()

The problem is that select doesn't include table with alias 'p'. p.rid should be replaced with r.rid.

  // If the role is a name, not an ID, replace with the ID.
  for ($i = 0; $i < count($roles); $i++) {
    if (!is_numeric($roles[$i])) {
      $row = db_select('role', 'r', array('target' => 'slave'))
        ->fields('p.rid')
        ->condition('r.name', $roles[$i])
        ->execute()
        ->fetchAssoc();
      if (!empty($row['rid'])) {
        $roles[$i] = $row['rid'];
      }
    }
  }