[MDEV-32990] federatedx time_zone round trips - Jira

XML

Word

Printable

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

is caused by

MDEV-16157 federated corrupts timestamps

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.