Hi, Otto, On Feb 03, Otto Kekäläinen via developers wrote:
Hello!
Does MariaDB already fully support 64-bit time_t (the year 2038 problem)?
No
MariaDB 10.11 was today uploaded to Debian experimental without any 64-bit time_t support changes, just a library name change[1] to test that it works with the Debian 64-bit time_t tooling as Debian is currently undergoing a transition to it[2]. So far MariaDB built successfully and passed the main MTR suite on 11 architectures[3].
Monty mentioned that some work is in progress, and indeed I found his commits in two branches [4,5] but looking at the commits and their link to buildbot it seems they are not passing the CI. I also found one MDEV[6] to make TIMESTAMP use the whole 32-bit unsigned range.
Are there any other efforts in progress?
Not that I know of
Does MTR main suite include tests for 64-bit time support? Should MTR automatically currently fail if toolchain time is 64-bit?
No and no. But, as you've seen, 11.4 or 11.5 will have MDEV-32188, which fixes the year 2038 problem, making timestamp good up to 2106. Regards, Sergei Chief Architect, MariaDB Server and security@mariadb.org