Sergei Golubchik added a comment - 2016-05-13 09:26 I'm not sure they should be disallowed. I see this can be solved in one of the following ways: disallow FOR UPDATE (and other clauses like LOCK IN SHARE MODE , SQL_BIG_RESULT , etc — everything that applies to a SELECT statetement) in subqueries, derived, and views allow them, but ignore — possible, but it's a bad choice allow them, issue a warning that this clause will only have an effect when the view/derived/subquery is executed into a temporary table implicitly always switch to temporary table execution path when one of these clauses is present like the above, but issue an error for views, requesting a user to specify TEMPTABLE explicitly

Elena Stepanova added a comment - 2016-05-14 00:01 Also reproducible with MySQL 5.6, 5.7.

Alice Sherepa added a comment - 2020-09-22 12:17 in MySQL 8.0 seems to be "allow them, but ignore"   mysql> CREATE VIEW v2 AS SELECT a FROM t1 FOR UPDATE; Query OK, 0 rows affected (0.06 sec)   mysql> show create view v2; +------+---------------------------------------------------------------------------------------------------------------------------------------------+----------------------+----------------------+ | View | Create View | character_set_client | collation_connection | +------+---------------------------------------------------------------------------------------------------------------------------------------------+----------------------+----------------------+ | v2 | CREATE ALGORITHM=UNDEFINED DEFINER=`skip-grants user`@`skip-grants host` SQL SECURITY DEFINER VIEW `v2` AS select `t1`.`a` AS `a` from `t1` | utf8mb4 | utf8mb4_0900_ai_ci | +------+---------------------------------------------------------------------------------------------------------------------------------------------+----------------------+----------------------+ 1 row in set (0.00 sec)   mysql> select * from v2; +------+ | a | +------+ | 10 | +------+ 1 row in set (0.00 sec)   mysql> SELECT * FROM v1; +-------------------------------+ | (SELECT a FROM t1 FOR UPDATE) | +-------------------------------+ | 10 | +-------------------------------+ 1 row in set (0.00 sec)   mysql> show create view v1; +------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------+----------------------+ | View | Create View | character_set_client | collation_connection | +------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------+----------------------+ | v1 | CREATE ALGORITHM=UNDEFINED DEFINER=`skip-grants user`@`skip-grants host` SQL SECURITY DEFINER VIEW `v1` AS select (select `t1`.`a` from `t1`) AS `(SELECT a FROM t1 FOR UPDATE)` from `t1` | utf8mb4 | utf8mb4_0900_ai_ci | +------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------+----------------------+ 1 row in set (0.00 sec)   mysql> select version(); +-----------+ | version() | +-----------+ | 8.0.21 | +-----------+ 1 row in set (0.00 sec)