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

mysql_tzinfo_to_sql generates wrong query

        Details

        • Type: Bug
        • Status: Closed
        • Priority: Minor
        • Resolution: Fixed
        • Affects Version/s: 5.5.34-galera
        • Fix Version/s: 5.5.36-galera
        • Component/s: None
        • 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

            Gliffy Diagrams

              Attachments

                Activity

                Hide
                Permalink
                nirbhay_c Nirbhay Choubey added a comment -

                Pushed to maria-5.5-galera.

                Show
                nirbhay_c Nirbhay Choubey added a comment - Pushed to maria-5.5-galera.

                  People

                  • Assignee:
                    nirbhay_c Nirbhay Choubey
                    Reporter:
                    giannello Giuseppe Iannello
                  • Votes:
                    0 Vote for this issue
                    Watchers:
                    4 Start watching this issue

                    Dates

                    • Created:
                      Updated:
                      Resolved: