Bug #118267 Can we extend timestamp range as mariadb, 2038 limit is approaching.

• Submitted: 26 May 2:47
• Modified: 26 May 4:27
• Reporter: Shi W
• Status: Verified
• Category: MySQL Server: Data Types
• Severity: S4 (Feature request)
• Version: 8.0
• OS: Any
• CPU Architecture: Any

[26 May 2:47] Shi W

Description:
MariaDB has extended timestamp range to '2106-02-07 06:28:15 UTC' from MariaDB 11.5. (https://jira.mariadb.org/browse/MDEV-32188) :
"Currently timestamp is 32-bit signed, although negative values are rejected, so it is de facto 31-bit, allowing values from 1970 to 2038.
We can make it 32-bit unsigned extending timestamp range to 2106, and it won't require many changes to the storage."

Is is possible for MySQL to support this feature too? thx

How to repeat:
see above

Suggested fix:
see above

[26 May 4:27] MySQL Verification Team

Hello Shi W,

Thank you for the feature request!

regards,
Umesh