imaltai wrote:
> Sorry, that is my fault for the above post, but
> ,with this, i found out another bug,
> now it seems not a bug for MySQL,It's like a bug
> for connector
> in Java,(i'm using IBATIS SQLMap)
> if there is no "select @c", calling test() will be
> given out a SQLException error as expected,
> but, with " select @c", the calling will stall
> for ever, no returning from calling, just stall
> there
>
> delimiter $$
>
> CREATE PROCEDURE test()
> begin
> set @c = 0;
>
> select @c;
> call raiseDoubleKeyError(); /*raise an Error*/
> end$$
>
>
>
>
> /*definition for Err_doubleKey as follow*/
>
> create table Err_DoubleKey(
> id int not null,
> primary key (id)
> ) engine = MyISAM;
> insert into Err_DoubleKey values(1);
>
> delimiter $$
> CREATE PROCEDURE raiseDoubleKeyError()
> begin
> insert into Err_DoubleKey values(1);
> end$$
>
> delimiter ;
What happens if you try to call this stored procedure from the command line client?
-Mark
Mark Matthews
Consulting Member Technical Staff - MySQL Enterprise Tools
Oracle
http://www.mysql.com/products/enterprise/monitor.html