Hi, Oleksandr! On Jun 02, Oleksandr Byelkin wrote:

revision-id: 811e062f812e450a2d0ae2c3be7f4ad1b90eadc8 (mariadb-10.2.0-53-g811e062) parent(s): eb86c32225db2a76c6f256130e7bb316900a9408 committer: Oleksandr Byelkin timestamp: 2016-06-02 12:12:26 +0200 message:

MDEV-10035: DBUG_ASSERT on CREATE VIEW v1 AS SELECT * FROM t1 FOR UPDATE

Ability to print lock type added. Restoring correct lock type for CREATE VIEW added.

So your fix is to save/print the lock option, but not let it to affect the locking... I suppose it may be ok for views, let's keep it your way for now. Ok to push Regards, Sergei Chief Architect MariaDB and security@mariadb.org