[DoctrineBridge] fix case sensitivity issue in RememberMe\DoctrineTokenProvider

PF4Public · nicolas-grekas · commit 0248d4f566bf · 2018-11-24T18:17:47.000+01:00
diff --git a/src/Symfony/Bridge/Doctrine/Security/RememberMe/DoctrineTokenProvider.php b/src/Symfony/Bridge/Doctrine/Security/RememberMe/DoctrineTokenProvider.php
@@ -50,15 +50,16 @@ public function __construct(Connection $conn)
      */
     public function loadTokenBySeries($series)
     {
-        $sql = 'SELECT class, username, value, lastUsed'
+        // the alias for lastUsed works around case insensitivity in PostgreSQL
+        $sql = 'SELECT class, username, value, lastUsed as last_used'
             .' FROM rememberme_token WHERE series=:series';
         $paramValues = array('series' => $series);
         $paramTypes = array('series' => \PDO::PARAM_STR);
         $stmt = $this->conn->executeQuery($sql, $paramValues, $paramTypes);
         $row = $stmt->fetch(\PDO::FETCH_ASSOC);
 
         if ($row) {
-            return new PersistentToken($row['class'], $row['username'], $series, $row['value'], new \DateTime($row['lastUsed']));
+            return new PersistentToken($row['class'], $row['username'], $series, $row['value'], new \DateTime($row['last_used']));
         }
 
         throw new TokenNotFoundException('No token found.');
