MySQL 4.0 crash on REPLACE SELECT

MySQL 4.0 crash on REPLACE SELECT

am 15.07.2006 19:26:12 von Jeremy Gardiner

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/bugs?unsub=gcdmb-bugs@m.gmane.org

Re: MySQL 4.0 crash on REPLACE SELECT

am 17.07.2006 08:45:31 von Oli Sennhauser

Hi Jeremy

I can reproduce it on my 4.0.26 and my 5.0.22. I think it is a bug and I
recommend you to file a bug. Would you like to do it (the honor is up to
you) or shall I?

Oli

mysql> REPLACE b9 SELECT * FROM a8 /* 27899 */;
ERROR 2013: Lost connection to MySQL server during query
mysql>
Number of processes running now: 0
060717 08:36:33 mysqld restarted


Jeremy Gardiner wrote:
> 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
>
>
>


--
------------------------------------------------------------ ------------

Haben Sie Ihre Firma schon im FOSS-Directory (www.foss-directory.net) eingetragen?

Oli Sennhauser
Rebenweg 6
CH - 8610 Uster / Switzerland

Phone (+41) 44 940 24 82
e-Mail oli.sennhauser@bluewin.ch
Website http://www.shinguz.ch/
Skype: oli_sennhauser


--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs@m.gmane.org