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

federated corrupts timestamps

    XMLWordPrintable

Details

    Description

      federated converts all literals to strings when sending them to the remote host. And remote host does the same.

      For timestamp, to/from string conversions depend on the current time zone. If local and remote have different current time zones, a wrong value will be inserted. Effects:

      • minimal possible, but valid, timestamp on the local host may be invalid (and not insert-able) on the remote.
      • maximal possible, but valid, timestamp on the local host may be invalid (and not insert-able) on the remote.
      • two distinct timestamp values may have the same string representation in some time zones (around October DST switch) and they'll be inserted as identical values on remote.

      To fix first two issues, Federated must set the same time zone on remote, as it has locally. To fix the last issue, this time zone must have no DST.

      Attachments

        Issue Links

          Activity

            People

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