2 messages in com.mysql.lists.bugsMySQL 4.0 crash on REPLACE SELECT
FromSent OnAttachments
Jeremy Gardiner15 Jul 2006 10:25 
Oli Sennhauser16 Jul 2006 23:45 
Subject:MySQL 4.0 crash on REPLACE SELECT
From:Jeremy Gardiner (jere@btinternet.com)
Date:07/15/2006 10:25:49 AM
List:com.mysql.lists.bugs

Can anyone tell me if this is a known bug?

I haven't been able to find anything similar in the bug database.

With MySQL version 4.0.12 running on Windows 2000:

CREATE TABLE s7 (col9 DOUBLE (1, 1) UNSIGNED NULL DEFAULT 1 AUTO_INCREMENT PRIMARY KEY ) /* 1518 */; 0000 SUCCESS

CREATE TABLE b9 (col0 MEDIUMINT UNSIGNED NULL AUTO_INCREMENT PRIMARY KEY ) AVG_ROW_LENGTH = 1 AVG_ROW_LENGTH = 1 PACK_KEYS = DEFAULT TYPE = MERGE INSERT_METHOD = FIRST REPLACE SELECT * FROM s7 /* 3443 */; 0000 SUCCESS

CREATE TABLE a8 (col6 FLOAT (1, 1) NOT NULL DEFAULT 1 ) /* 7284 */; 0000 SUCCESS

CREATE TABLE m5 (col4 LONGTEXT ) /* 7833 */; 0000 SUCCESS

CREATE TEMPORARY TABLE IF NOT EXISTS a8 (col8 DATETIME NULL PRIMARY KEY REFERENCES g8 ) MIN_ROWS = 1 INSERT_METHOD = NO REPLACE SELECT * FROM m5 /* 9670 */; 0000 SUCCESS

INSERT IGNORE INTO a8 (col8 ) VALUES ("") , (NULL) /* 25906 */; 0000 SUCCESS

REPLACE b9 SELECT * FROM a8 /* 27899 */; 2013 Lost connection to MySQL server during query

----- While I'm on the subject, here is another one: -----

CREATE TEMPORARY TABLE p1 (col8 TINYINT UNSIGNED NULL PRIMARY KEY ) AUTO_INCREMENT = 60 COMMENT = "o" INDEX DIRECTORY = "my_index_directory" INSERT_METHOD = FIRST TYPE = HEAP RAID_TYPE = STRIPED RAID_CHUNKS = +9 RAID_CHUNKSIZE = 6 TYPE = MERGE /* 6176 */; 0000 SUCCESS

REPLACE p1 VALUES (NULL) , (NULL) , (NULL) /* 15030 */; 2013 Lost connection to MySQL server during query

Again, I haven't found anything similar in the bug database - can anyone tell me if this is a known bug?

Perhaps it is another manifestation of the bug at the top of this thread?