FunTester

Sep 28, 2019 · Backend Development

When VIP Expiration Hits 2038: Uncovering MySQL INT Overflow

A bug was discovered where a user's VIP expiration date could not extend beyond a specific day in 2038 because the timestamp was stored in a signed INT column, whose maximum value (2147483647) corresponds to 2038‑01‑19 11:14:07, causing the system to fail to save later dates.