Skip to content

PDO session timestamps out of range for MySQL #25665

@WhiteEagle88

Description

@WhiteEagle88
Q A
Bug report? yes
Feature request? no
BC Break report? yes/no
RFC? no
Symfony version 2.6+

After fix #24456, problem arose for MySQL. Because MySQL cast the result of the expression to unsigned types and in the case where sess_time < current time. Mysql throws an error:

SQLSTATE[22003]: Numeric value out of range: 1690 BIGINT UNSIGNED value is out of range in '(1514967355 - `demo`.`sessions`.`sess_time`)'

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions