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

make TIMESTAMP use whole 32-bit unsigned range

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

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

          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

          New Feature - A new feature of the product, which has yet to be developed. 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

            Ascending order - Click to sort in descending order
            serg Sergei Golubchik created issue -
            serg Sergei Golubchik made changes -
            Field Original Value New Value
            serg Sergei Golubchik made changes -
            serg Sergei Golubchik made changes -
            serg Sergei Golubchik made changes -
            Summary make TIMESTAMP to use whole 32-bit unsigned range make TIMESTAMP use whole 32-bit unsigned range
            serg Sergei Golubchik made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            serg Sergei Golubchik made changes -
            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 of the storage.             		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.
            monty Michael Widenius made changes -
            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.             		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.


            serg Sergei Golubchik made changes -
            serg Sergei Golubchik made changes -
            serg Sergei Golubchik made changes -
            serg Sergei Golubchik made changes -
            Fix Version/s 11.4 [ 29301 ]
            Fix Version/s 11.3 [ 28565 ]
            monty Michael Widenius made changes -
            Status In Progress [ 3 ] In Review [ 10002 ]
            monty Michael Widenius made changes -
            Assignee Michael Widenius [ monty ] Alexander Barkov [ bar ]
            Richard Richard Stracke made changes -
            Richard Richard Stracke made changes -
            julien.fritsch Julien Fritsch made changes -
            Priority Major [ 3 ] Critical [ 2 ]
            bar Alexander Barkov made changes -
            bar Alexander Barkov made changes -
            bar Alexander Barkov made changes -
            bar Alexander Barkov made changes -
            Assignee Alexander Barkov [ bar ] Michael Widenius [ monty ]
            Status In Review [ 10002 ] Stalled [ 10000 ]
            serg Sergei Golubchik made changes -
            serg Sergei Golubchik made changes -
            Status Stalled [ 10000 ] In Testing [ 10301 ]
            serg Sergei Golubchik made changes -
            Assignee Michael Widenius [ monty ] Elena Stepanova [ elenst ]
            julien.fritsch Julien Fritsch made changes -
            Issue Type Task [ 3 ] New Feature [ 2 ]
            elenst Elena Stepanova made changes -
            elenst Elena Stepanova made changes -
            elenst Elena Stepanova made changes -
            elenst Elena Stepanova made changes -
            serg Sergei Golubchik made changes -
            serg Sergei Golubchik made changes -
            serg Sergei Golubchik made changes -
            ralf.gebhardt Ralf Gebhardt made changes -
            Labels Preview_11.4
            elenst Elena Stepanova made changes -
            elenst Elena Stepanova made changes -
            elenst Elena Stepanova made changes -
            elenst Elena Stepanova made changes -
            elenst Elena Stepanova made changes -
            otto Otto Kekäläinen made changes -
            otto Otto Kekäläinen made changes -
            serg Sergei Golubchik made changes -
            sanja Oleksandr Byelkin made changes -
            elenst Elena Stepanova made changes -
            Assignee Elena Stepanova [ elenst ] Sergei Golubchik [ serg ]
            Status In Testing [ 10301 ] Stalled [ 10000 ]
            ralf.gebhardt Ralf Gebhardt made changes -
            Fix Version/s 11.5 [ 29506 ]
            Fix Version/s 11.4 [ 29301 ]
            serg Sergei Golubchik made changes -
            Status Stalled [ 10000 ] In Testing [ 10301 ]
            serg Sergei Golubchik made changes -
            Assignee Sergei Golubchik [ serg ] Elena Stepanova [ elenst ]
            elenst Elena Stepanova made changes -
            serg Sergei Golubchik made changes -
            greenman Ian Gilfillan made changes -
            ralf.gebhardt Ralf Gebhardt made changes -
            Labels Preview_11.4 Preview_11.4 Preview_11.5
            elenst Elena Stepanova made changes -
            elenst Elena Stepanova made changes -
            Assignee Elena Stepanova [ elenst ] Sergei Golubchik [ serg ]
            Status In Testing [ 10301 ] Stalled [ 10000 ]
            serg Sergei Golubchik made changes -
            Fix Version/s 11.5.1 [ 29634 ]
            Fix Version/s 11.5 [ 29506 ]
            Resolution Fixed [ 1 ]
            Status Stalled [ 10000 ] Closed [ 6 ]
            ralf.gebhardt Ralf Gebhardt made changes -
            mariadb-jira-automation Jira Automation (IT) made changes -
            Zendesk Related Tickets 112719 124111
            ralf.gebhardt Ralf Gebhardt made changes -

            People

              serg Sergei Golubchik
              serg Sergei Golubchik
              Votes:
              3 Vote for this issue
              Watchers:
              16 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.