mysql>
mysql>
mysql>
mysql> drop table if exists t1//
Query OK, 0 rows affected (0.00 sec)

mysql> create table t1(f1 char(0), f2 decimal (64) unsigned not null DEFAULT 9.9, f3 tinyint, f5 int)//
Query OK, 0 rows affected (0.03 sec)

mysql> insert into t1(f2,f3,f5) values(1,1,1),(2,2,2),(3,3,0),(4,4,4),(5,5,5),(6,6,6),(7,7,0),(8,8,8),(9,9,9),(10,10,10)//
Query OK, 10 rows affected (0.00 sec)
Records: 10  Duplicates: 0  Warnings: 0

mysql>
mysql> drop table if exists t2//
Query OK, 0 rows affected (0.00 sec)

mysql> create table t2(f4 char binary, f5 int)//
Query OK, 0 rows affected (0.02 sec)

mysql> insert into t2 values('a',1),('a',2),('a',0),('a',4),('a',5),('a',6),('a',0),('a',8),('a',9),('a',10)//
Query OK, 10 rows affected (0.02 sec)
Records: 10  Duplicates: 0  Warnings: 0

mysql>
mysql> drop view if exists v1//
Query OK, 0 rows affected (0.00 sec)

mysql> create view v1 as select t1.f1, t1.f2, t1.f3, t2.f4, t2.f5 from t1 inner join t2 using (f5)//
Query OK, 0 rows affected (0.00 sec)

mysql>
mysql> drop procedure if exists sp01//
Query OK, 0 rows affected (0.00 sec)

mysql> create procedure sp01 ()
    -> p1: begin
    ->  update v1 set v1.f2=0 where v1.f5<=0;
    ->  select * from v1;
    -> end p1//
Query OK, 0 rows affected (0.00 sec)

mysql>
mysql> call sp01()//
ERROR 1099 (HY000): Table 't1' was locked with a READ lock and can't be updated
mysql>