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

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

    Details

    • Sprint:
      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

              • Assignee:
                serg Sergei Golubchik
                Reporter:
                joce jocelyn fournier
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: