bug #24579 pdo session fix (mxp100)

fabpot · fabpot · commit 60adbdd0598d · 2017-10-16T13:29:26.000-07:00
This PR was merged into the 2.7 branch. Discussion ---------- pdo session fix | Q | A | ------------- | --- | Branch? | 2.7 | Bug fix? | yes | New feature? | no | BC breaks? | no | Deprecations? | no | Tests pass? | yes | Fixed tickets | #24456 | License | MIT | Doc PR | Fix PDO session timestamp out of range for postgres. (branch from 2.7) P.S. please delete this pull #24457 Commits ------- 56b29a7 pdo session fix
diff --git a/src/Symfony/Component/HttpFoundation/Session/Storage/Handler/PdoSessionHandler.php b/src/Symfony/Component/HttpFoundation/Session/Storage/Handler/PdoSessionHandler.php
@@ -387,7 +387,7 @@ public function close()
             $this->gcCalled = false;
 
             // delete the session records that have expired
-            $sql = "DELETE FROM $this->table WHERE $this->lifetimeCol + $this->timeCol < :time";
+            $sql = "DELETE FROM $this->table WHERE $this->lifetimeCol < :time - $this->timeCol";
 
             $stmt = $this->pdo->prepare($sql);
             $stmt->bindValue(':time', time(), \PDO::PARAM_INT);
