MySQL Forums
Forum List  »  Stored Procedures

Re: bug again?
Posted by: Mark Matthews
Date: June 20, 2005 07:37PM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
2561
June 20, 2005 08:52AM
1745
June 20, 2005 03:55PM
Re: bug again?
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.