Details
-
Bug
-
Status: Open (View Workflow)
-
Minor
-
Resolution: Unresolved
-
5.5, 10.0, 10.1, 10.2, 10.3, 10.4
-
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.