List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:November 6 1999 6:42pm
Subject:Re: [BUG] MySQL bug on some update query.
View as plain text  
At 1:07 PM -0500 11/6/99, Bob Kline wrote:
>On Sat, 6 Nov 1999, Oh Junseon wrote:
>
>>  I found infinite loop bug on mysql update query .
>>  Let's excute below query sequencely .
>>
>>
>>  Let's create a new table width index ;
>>
>>       CREATE TABLE test ( no int not null default 0 , INDEX idx_no(no) ) ;
>>
>>  Inserting data ;
>>
>>       INSERT INTO test VALUES (1) ;
>>       INSERT INTO test VALUES (2) ;
>>       ..........
>>       ..........
>>       ..........
>>       INSERT INTO test VALUES (30) ;
>>
>>  Updating data for meet the bug(?) :) ;
>>
>>       UPDATE test SET no = no + 1 where no >= 2 ;
>>       INSERT INTO test VALUES (2) ;
>>
>>       ( LOOP THIS TWO LINE FOR 10 TIMES.. )
>>
>>  Let's meet the bug !! ;
>>
>>       UPDATE test SET no = no + 1 where no >= 40 ;
>>
>>  Mysql doing infinite loop for updating this query.
>>  Did you meet the bug ..? :)
>>
>
>Please the instructions in the manual for reporting bugs.
>http://www.mysql.com/Manual_chapter/manual_Questions.html#Bug_reports
>
>I was unable to reproduce the bug using 3.23.4 on Intel/Linux 2.2.5-15,
>so either the bug is platform or build environment dependent, or it has
>been fixed in a version later than the version you are running.  You
>haven't supplied any information about platform or versions.


It's been fixed in the 3.23.xx series.

-- 
Paul DuBois, paul@stripped
Thread
[BUG] MySQL bug on some update query.Oh Junseon6 Nov
  • Re: [BUG] MySQL bug on some update query.Paul DuBois6 Nov
  • Re: [BUG] MySQL bug on some update query.Bob Kline6 Nov
    • Re: [BUG] MySQL bug on some update query.Oh Junseon6 Nov
      • Re: [BUG] MySQL bug on some update query.Bob Kline6 Nov
    • Re: [BUG] MySQL bug on some update query.Paul DuBois6 Nov