[MDEV-18692] Unexpected ER_TABLE_NOT_LOCKED_FOR_WRITE on DDL on table under WRITE CONCURRENT lock Created: 2019-02-22  Updated: 2023-04-27

Status: Open
Project: MariaDB Server
Component/s: Locking
Affects Version/s: 5.5, 10.0, 10.1, 10.2, 10.3, 10.4
Fix Version/s: 10.4

Type: Bug Priority: Minor
Reporter: Elena Stepanova Assignee: Vladislav Vaintroub
Resolution: Unresolved Votes: 0
Labels: None


 Description    

CREATE TABLE t1 (a INT);
 
LOCK TABLE t1 WRITE CONCURRENT;
 
ALTER TABLE t1;
 
 
 
# Cleanup
 
UNLOCK TABLES;
 
DROP TABLE t1;


mysqltest: At line 3: query 'ALTER TABLE t1' failed: 1099: Table 't1' was locked with a READ lock and can't be updated

I don't know if DDL under this kind of lock is supposed to be allowed or not. But if it is prohibited, it should be documented. Besides, it might deserve a better error message.
Generated at Thu Feb 08 08:46:01 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.