Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-32990

federatedx time_zone round trips

    XMLWordPrintable

Details

    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
      

      Attachments

        Issue Links

          Activity

            People

              TheLinuxJedi Andrew Hutchings
              mg MG
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

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