$ diff -u /tmp/mysql_tzinfo_to_sql-basic.txt /tmp/mysql_tzinfo_to_sql-MDEV-23440-basic.txt
|
--- /tmp/mysql_tzinfo_to_sql-basic.txt 2020-08-11 16:24:29.171950052 +1000
|
+++ /tmp/mysql_tzinfo_to_sql-MDEV-23440-basic.txt 2020-08-11 16:27:58.112286396 +1000
|
@@ -11,6 +11,7 @@
|
TRUNCATE TABLE time_zone_name;
|
TRUNCATE TABLE time_zone_transition;
|
TRUNCATE TABLE time_zone_transition_type;
|
+START TRANSACTION;
|
INSERT INTO time_zone (Use_leap_seconds) VALUES ('N');
|
SET @time_zone_id= LAST_INSERT_ID();
|
INSERT INTO time_zone_name (Name, Time_zone_id) VALUES ('Africa/Abidjan', @time_zone_id);
|
@@ -142081,6 +142082,7 @@
|
INSERT INTO time_zone_transition_type (Time_zone_id, Transition_type_id, Offset, Is_DST, Abbreviation) VALUES
|
(@time_zone_id, 0, 0, 0, 'UTC')
|
;
|
+COMMIT;
|
ALTER TABLE time_zone_transition ORDER BY Time_zone_id, Transition_time;
|
ALTER TABLE time_zone_transition_type ORDER BY Time_zone_id, Transition_type_id;
|
\d |
|
|
$ diff -u /tmp/mysql_tzinfo_to_sql--skip-write-binlog.txt /tmp/mysql_tzinfo_to_sql-MDEV-23440--skip-write-binlog.txt
|
--- /tmp/mysql_tzinfo_to_sql--skip-write-binlog.txt 2020-08-11 16:25:19.976265142 +1000
|
+++ /tmp/mysql_tzinfo_to_sql-MDEV-23440--skip-write-binlog.txt 2020-08-11 16:27:27.476086092 +1000
|
@@ -5,6 +5,7 @@
|
TRUNCATE TABLE time_zone_name;
|
TRUNCATE TABLE time_zone_transition;
|
TRUNCATE TABLE time_zone_transition_type;
|
+START TRANSACTION;
|
INSERT INTO time_zone (Use_leap_seconds) VALUES ('N');
|
SET @time_zone_id= LAST_INSERT_ID();
|
INSERT INTO time_zone_name (Name, Time_zone_id) VALUES ('Africa/Abidjan', @time_zone_id);
|
@@ -142075,5 +142076,6 @@
|
INSERT INTO time_zone_transition_type (Time_zone_id, Transition_type_id, Offset, Is_DST, Abbreviation) VALUES
|
(@time_zone_id, 0, 0, 0, 'UTC')
|
;
|
+COMMIT;
|
ALTER TABLE time_zone_transition ORDER BY Time_zone_id, Transition_time;
|
ALTER TABLE time_zone_transition_type ORDER BY Time_zone_id, Transition_type_id;
|
bb-10.1-
MDEV-23440-danielblack-mysql_tzinfo_to_sql-with-transactions pushedSimple patch: https://github.com/MariaDB/server/commit/23bdab05a7cf5aff5d2c6451227315bde6ef53a5