MySQL 4.0 crash on REPLACE SELECT

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?

Thanks,
Jeremy Gardiner


-- 
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe:    http://lists.mysql.com/[email protected]