[MDEV-32990] federatedx time_zone round trips Created: 2023-12-12  Updated: 2024-01-22  Resolved: 2024-01-22

Status: Closed
Project: MariaDB Server
Component/s: Storage Engine - Federated
Affects Version/s: 10.11.6
Fix Version/s: 10.4.33, 10.5.24, 10.6.17, 10.11.7, 11.0.5, 11.1.4, 11.2.3

Type: Bug Priority: Minor
Reporter: MG Assignee: Andrew Hutchings
Resolution: Fixed Votes: 0
Labels: beginner-friendly, federated, federatedx

Issue Links:
Problem/Incident
is caused by MDEV-16157 federated corrupts timestamps Closed

 Description   

Looking at the general log on the remote side, while testing MDEV-32984, you can see that the client sets time_zone too frequently, eg:

231212  1:14:45	     6 Query	set time_zone='+00:00'
		     6 Query	SET AUTOCOMMIT=0
		     6 Query	set time_zone='+00:00'
		     6 Query	SAVEPOINT save1
		     6 Query	set time_zone='+00:00'
		     6 Query	SHOW TABLE STATUS LIKE 'users'
		     6 Query	set time_zone='+00:00'
		     6 Query	SELECT `id`, `name`, `password` FROM `users` WHERE  ( (`name` = 'test') ) AND ( (1=1) )
		     6 Query	set time_zone='+00:00'
		     6 Query	UPDATE `users` SET `id` = 1, `password` = '123456' WHERE `id` = 1 AND `name` = 'test'
		     6 Query	set time_zone='+00:00'
		     6 Query	ROLLBACK



 Comments   
Comment by Sisi Huang [ 2024-01-12 ]

Hi, I'm interested in this issue and this is my fix: https://github.com/MariaDB/server/pull/3000

Comment by Daniel Black [ 2024-01-22 ]

Thanks hsser.

Generated at Thu Feb 08 10:35:33 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.