MySQL Forums
Forum List  »  Stored Procedures

Re: bug again?
Posted by: imaltai
Date: June 20, 2005 03:55PM

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 ;

Options: ReplyQuote


Subject
Views
Written By
Posted
2561
June 20, 2005 08:52AM
Re: bug again?
1744
June 20, 2005 03:55PM
1667
June 20, 2005 07:37PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.