update bug

[Michael Widenius]

Hi!

>>>>> "suopanki" == suopanki  <suopanki@stripped> writes:

>> Description:
suopanki> The following code will hang MySQL
suopanki> (tested on Solaris and Linux)

>> How-To-Repeat:

suopanki> CREATE TABLE ctest (ord int(10) NOT NULL,  KEY ord (ord));
suopanki> INSERT INTO ctest VALUES (8192);
suopanki> INSERT INTO ctest VALUES (24576);
suopanki> INSERT INTO ctest VALUES (28672);
suopanki> INSERT INTO ctest VALUES (32768);
suopanki> INSERT INTO ctest VALUES (53248);
suopanki> INSERT INTO ctest VALUES (65536);
suopanki> INSERT INTO ctest VALUES (69632);
suopanki> INSERT INTO ctest VALUES (69633);
suopanki> INSERT INTO ctest VALUES (69634);
suopanki> INSERT INTO ctest VALUES (69635);
suopanki> INSERT INTO ctest VALUES (69636);
suopanki> INSERT INTO ctest VALUES (73728);
suopanki> INSERT INTO ctest VALUES (94208);
suopanki> INSERT INTO ctest VALUES (98305);
suopanki> INSERT INTO ctest VALUES (102405);
suopanki> INSERT INTO ctest VALUES (106496);
suopanki> INSERT INTO ctest VALUES (110592);
suopanki> INSERT INTO ctest VALUES (131072);
suopanki> INSERT INTO ctest VALUES (135168);
suopanki> INSERT INTO ctest VALUES (147456);
suopanki> UPDATE ctest SET ord=ord+1 where (ord > 136000);
 
>> Fix:
suopanki> no fix

The above problem is described in the BUGS section in the MySQL manual
and is fixed in MySQL 3.23.

The query will continue forever, but the thread can be killed nicely
with 'mysqladmin kill'

Regards,
Monty