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

          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.