LOCK view WRITE shouldn't block FLUSH view.
So we set the view's mdl_request type to it's tables.