-
Type:
Bug
-
Status: Confirmed (View Workflow)
-
Priority:
Major
-
Resolution: Unresolved
-
Affects Version/s: 10.1.43
-
Fix Version/s: 10.1
-
Component/s: Galera, Scripts & Clients
-
Labels:None
When the sql-mode contains STRICT_ALL_TABLES or STRICT_TRANS_TABLES mysql_tzinfo_to_sql is not properly working because of the following statement
ALTER TABLE time_zone_transition ORDER BY Time_zone_id, Transition_time; |
with the following error message
ERROR 1105 (HY000) at line 146984: ORDER BY ignored as there is a user-defined clustered index in the table 'time_zone_transition'
This could be releated to MDEV-18778 (but I am not quite sure)
- is caused by
-
MDEV-18778 mysql_tzinfo_to_sql does not work correctly in MariaDB Galera
-
- Closed
-
- relates to
-
MDEV-21209 mysql_tzinfo_to_sql's Galera checks do not work
-
- Closed
-