Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.0(EOL), 10.1(EOL)
-
None
-
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
- causes
-
MDEV-10957 Assertion failure when dropping a myisam table with wsrep_replicate_myisam enabled
- Closed