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

System table in InnoDB format allowed in MariaDB could lead to crash

    XMLWordPrintable

Details

    • 10.1.18

    Description

      Hi,

      After working on an upstream bug with a time_zone_name table created in InnoDB format, I figured out than trying to create them in InnoDB is forbidden in MySQL, but not in MariaDB.

      The original bugreport : http://bugs.mysql.com/bug.php?id=82910

      When I try to import the timezone.sql from this bugreport in MySQL, it's forbidden :

      MySQL 5.6.33 :

      mysql mysql < timezone.sql
      ERROR 1726 (HY000) at line 72: Storage engine 'InnoDB' does not support system tables. [mysql.time_zone_name]
      

      However in MariaDB it works like a charm, and it leads to the crashes described in the bugreport, easily reproducible in MariaDB.

      It would be great to have the same check than in MySQL (since MariaDB also crashes with a time_zone_name table in InnoDB format).

      Thanks and regards,
      Jocelyn Fournier

      Attachments

        Issue Links

          Activity

            People

              serg Sergei Golubchik
              joce jocelyn fournier
              Votes:
              0 Vote for this issue
              Watchers:
              3 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.