mirror of
https://github.com/MariaDB/server.git
synced 2025-08-07 00:04:31 +03:00
7890388d91
$MYSQL_TZINFO_TO_SQL works by truncating tables. Truncation is an operation that cannot be done in-place and therefore is fundamentally incompatible with alter_algorithm='INPLACE'. As a result, we override the default alter_algorithm setting in tztime.cc to alter_algorithm='COPY' so that timezones can be loaded regardless of the previously set alter_algorithm. All new code of the whole pull request, including one or several files that are either new files or modified ones, are contributed under the BSD-new license. I am contributing on behalf of my employer Amazon Web Services, Inc.
19 lines
1.1 KiB
Plaintext
19 lines
1.1 KiB
Plaintext
set global alter_algorithm=INPLACE;
|
|
RENAME TABLE mysql.time_zone TO mysql.time_zone_BACKUP;
|
|
RENAME TABLE mysql.time_zone_name TO mysql.time_zone_name_BACKUP;
|
|
RENAME TABLE mysql.time_zone_transition TO mysql.time_zone_transition_BACKUP;
|
|
RENAME TABLE mysql.time_zone_transition_type TO mysql.time_zone_transition_type_BACKUP;
|
|
CREATE TABLE mysql.time_zone LIKE mysql.time_zone_BACKUP;
|
|
CREATE TABLE mysql.time_zone_name LIKE mysql.time_zone_name_BACKUP;
|
|
CREATE TABLE mysql.time_zone_transition LIKE mysql.time_zone_transition_BACKUP;
|
|
CREATE TABLE mysql.time_zone_transition_type LIKE mysql.time_zone_transition_type_BACKUP;
|
|
DROP TABLE mysql.time_zone;
|
|
DROP TABLE mysql.time_zone_name;
|
|
DROP TABLE mysql.time_zone_transition;
|
|
DROP TABLE mysql.time_zone_transition_type;
|
|
RENAME TABLE mysql.time_zone_BACKUP TO mysql.time_zone;
|
|
RENAME TABLE mysql.time_zone_name_BACKUP TO mysql.time_zone_name;
|
|
RENAME TABLE mysql.time_zone_transition_BACKUP TO mysql.time_zone_transition;
|
|
RENAME TABLE mysql.time_zone_transition_type_BACKUP TO mysql.time_zone_transition_type;
|
|
set global alter_algorithm=DEFAULT;
|