[#MDEV-5534] mysql_tzinfo_to_sql generates wrong query

[MDEV-5534] mysql_tzinfo_to_sql generates wrong query Created: 2014-01-16 Updated: 2014-02-14 Resolved: 2014-02-14
Status:	Closed
Project:	MariaDB Server
Component/s:	None
Affects Version/s:	5.5.34-galera
Fix Version/s:	5.5.36-galera

Type:

Bug

Priority:

Minor

Reporter:

Giuseppe Iannello

Assignee:

Nirbhay Choubey (Inactive)

Resolution:

Fixed

Votes:

Labels:

None

Environment:

Ubuntu 12.04

Description

executing

root@cluster01:~# mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root mysql

outputs the following error

ERROR 1229 (HY000) at line 1: Variable 'wsrep_replicate_myisam' is a GLOBAL variable and should be set with SET GLOBAL

The resulting file contains at line 1

SET SESSION wsrep_replicate_myisam=ON;

Removing the line (as it's already enabled on my instance) and feeding the remaining queries to mysql works without any problem

Comments

Comment by Nirbhay Choubey (Inactive) [ 2014-02-14 ]

Pushed to maria-5.5-galera.

Generated at Thu Feb 08 07:05:06 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.