Roland Bouman wrote:
> [...]
> I tried this from within a similar begin..end
> block, but i can't compile it.
>
> l: loop
> fetch csr into var;
> if csr_no_more_rows then
> leave l:
> end if;
> end loop l;
>
> In fact, anything I try with a LOOP..END LOOP,
> with or without cursors goes fine until i insert
> the loop labels or write the LEAVE statement.
>
> Anyone?
Please report problems, particularly nice reproducible ones, to the MySQL bugs system at bugs.mysql.com.
Thanks.
Regards, Arjen.
--
Arjen Lentz, Exec.Director @ Open Query (http://openquery.com)
Remote expertise & maintenance for MySQL/MariaDB server environments.
Follow us at
http://openquery.com/blog/ &
http://twitter.com/openquery