Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-32188

make TIMESTAMP use whole 32-bit unsigned range

    XMLWordPrintable

Details

    Description

      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.

      Storage of timestamp is not affected but the change.
      However storage of 'row_end' for system versioned tables must change from storing a 2038 based timestamp to a 2106 based one.

      Attachments

        Issue Links

          causes

          Bug - A problem which impairs or prevents the functions of the product. MDEV-32930 mysqlbinlog --verbose shows incorrect values for timestamps >= 2^31 if binlog was created with mysql56_temporal_format=off

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. MDEV-33013 versioning.insert2 fails on 32-bit with wrong result

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-33017 Assertion `temp > 1969' fails in Field_timestamp::val_str on 32-bit

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-33032 Live and dump upgrade from previous versions to the extended timestamp fails for system-versioned tables

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-33239 mysqlbinlog cannot parse events written with system timestamp 4294967295

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. MDEV-33248 Connect engine does not support 32-bit timestamp

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-33302 Columnstore does not support 32-bit timestamps: CAL0001: MCS-2025: Data truncated for column

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. MDEV-33310 mariadb-upgrade does not fix InnoDB versioned tables upon upgrade to 32-bit timestamp

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-33358 ROW END needs to be adjusted to 32-bit timestamp upon OM => NS replication

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-33718 mariadb-dump help refers to the wrong version for timestamp upgrades

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-34121 Extension of timestamp range can cause OM=>NS replication discrepancy and failure

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Open
          is blocked by

          New Feature - A new feature of the product, which has yet to be developed. MDEV-33449 improving repair of tables

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed
          is duplicated by

          Task - A task that needs to be done. MDEV-9444 MariaDB needs to be Y2038-compliant

          • Major - Major loss of function.
          • Closed

          Task - A task that needs to be done. MDEV-20192 Change timestamp to 64-bit integer for number of seconds to extend its life with EPOCH defined as '1970-01-01 00:00:01 UTC'

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-26736 UNIX_TIMESTAMP doesn't work beyond 2038 (aka y2.038k)

          • Major - Major loss of function.
          • Closed
          relates to

          Task - A task that needs to be done. MDEV-15750 preserve MYSQL_TYPE_TIMESTAMP in temporal arithmetics

          • Major - Major loss of function.
          • Stalled

          Task - A task that needs to be done. MDEV-16135 Service does not start if date set beyond Y2038

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed

          Task - A task that needs to be done. MDEV-32582 Events fuctionality after 2038

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. MDEV-33381 armhf: MTR failures in Spider and versioning tests

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Open

          New Feature - A new feature of the product, which has yet to be developed. MDEV-33449 improving repair of tables

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          New Feature - A new feature of the product, which has yet to be developed. MDEV-341 64-bit support in FROM_UNIXTIME()

          • Major - Major loss of function.
          • Open

          New Feature - A new feature of the product, which has yet to be developed. MDEV-10018 Timestamp with time zone

          • Major - Major loss of function.
          • Open

          Task - A task that needs to be done. MDEV-32496 TIMESTAMP variant to support YEAR range -4713 and +9999

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. MDEV-33442 REPAIR TABLE corrupts UUIDs

          • Blocker - Blocks development and/or testing work, production could not run.
          • Closed
          links to

          Web Link Debian libmariadbd19t64 library name update for libc toolchain transition

          Activity

            People

              serg Sergei Golubchik
              serg Sergei Golubchik
              Votes:
              3 Vote for this issue
              Watchers:
              15 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.