[MDEV-16157] federated corrupts timestamps Created: 2018-05-14  Updated: 2023-12-12  Resolved: 2018-05-17

Status: Closed
Project: MariaDB Server
Component/s: Storage Engine - Federated
Affects Version/s: 5.5, 10.0, 10.1, 10.2, 10.3
Fix Version/s: 10.3.7

Type: Bug Priority: Major
Reporter: Sergei Golubchik Assignee: Sergei Golubchik
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Blocks
blocks MDEV-15969 System versioning and FEDERATED don't... Closed
Problem/Incident
causes MDEV-32990 federatedx time_zone round trips Closed
Relates
relates to MDEV-16246 insert timestamp into spider table fr... Closed

 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.


Generated at Thu Feb 08 08:26:48 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.