Bug #28049 Falcon Hang after fifteen exceptions

• Submitted: 23 Apr 2007 21:38
• Reporter: Hakan Küçükyılmaz
• Status: Closed
• Category: MySQL Server: Falcon storage engine
• Severity: S3 (Non-critical)
• Version: 6.0.0-alpha
• OS: Any
• CPU Architecture: Any

[23 Apr 2007 21:38] Hakan Küçükyılmaz

Description:
I create a table with a unique column.
I create a procedure which will cause a 'duplicate key' error
when updating the table, catch the exception, and proceed.
The procedure catches the exception and proceeds about 15 times.
Then it hangs.

How to repeat:
delimiter //
set @@autocommit=0//
create procedure p ()
begin
  declare v int default 0;
  declare continue handler for sqlexception begin end;
  create table t1 (s1 int unique) engine=falcon;
  while v < 1000 do
    insert into t1 values (v);
    update t1 set s1 = s1 * 2;
    select distinct v from t1;
    set v = v + 1;
    end while;
  end;
//
call p()//

[23 Apr 2007 21:38] Hakan Küçükyılmaz

Test case is falcon_bug_28049.test.