2 messages in com.mysql.lists.bugsMySQL 4.0 crash on REPLACE SELECT| From | Sent On | Attachments |
|---|---|---|
| Jeremy Gardiner | 15 Jul 2006 10:25 | |
| Oli Sennhauser | 16 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?
Thanks, Jeremy Gardiner




