Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
5.5(EOL), 10.0(EOL), 10.1(EOL), 10.2(EOL), 10.3(EOL)
-
None
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
- blocks
-
MDEV-15969 System versioning and FEDERATED don't work well together: DML and discovery fail
- Closed
- causes
-
MDEV-32990 federatedx time_zone round trips
- Closed
- relates to
-
MDEV-16246 insert timestamp into spider table from mysqldump gets wrong time zone.
- Closed