[MDEV-33044] Loading time zones does not work with alter_algorithm INPLACE Created: 2023-12-16  Updated: 2024-01-04

Status: Open
Project: MariaDB Server
Component/s: Scripts & Clients, Time zones
Affects Version/s: 10.4, 10.5, 10.6, 10.11, 11.0, 11.1, 11.2
Fix Version/s: 10.4, 10.5, 10.6, 10.11, 11.0, 11.1, 11.2

Type: Bug Priority: Minor
Reporter: Elena Stepanova Assignee: Oleksandr Byelkin
Resolution: Unresolved Votes: 0
Labels: beginner-friendly


 Description    

set global alter_algorithm= INPLACE;
 
--exec $MYSQL_TZINFO_TO_SQL std_data/zoneinfo | $MYSQL mysql

10.4 ba94778d2c438d4c0f93ce031e504f7d78e895e1

 
ERROR 1845 (0A000) at line 28: ALGORITHM=INPLACE is not supported for this operation. Try ALGORITHM=COPY
 
mysqltest: At line 2: exec of '/mnt8t/bld/10.4-asan/sql/mysql_tzinfo_to_sql std_data/zoneinfo | /mnt8t/bld/10.4-asan/client//mysql --defaults-file=/mnt8t/bld/10.4-asan/mysql-test/var/my.cnf mysql' failed, error: 256, status: 1, errno: 11
 
Output from before failure:
 
set global alter_algorithm= INPLACE;



 Comments   
Comment by Anson [ 2024-01-04 ]

I'd like to work on this!

Generated at Thu Feb 08 10:35:58 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.