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

              Assignee:
              serg Sergei Golubchik
              Reporter:
              serg Sergei Golubchik
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: