Bug #43662 Specific table structure occured connection lost
Submitted: 16 Mar 2009 5:51 Modified: 16 Mar 2009 6:38
Reporter: YOUNSANG KIM Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Server Severity:S1 (Critical)
Version:5.1.32-0.rhel4.i386 OS:Linux (CentOS 4.7 Latest)
Assigned to: CPU Architecture:Any
Tags: connection lost when running query

[16 Mar 2009 5:51] YOUNSANG KIM 
Description:
CREATE TABLE `Patrol` (
  `idx` double NOT NULL AUTO_INCREMENT,
  `game_code` tinyint(4) DEFAULT NULL,
  `date_register` date DEFAULT NULL,
  `time_register` time DEFAULT NULL,
  `date_process` datetime DEFAULT NULL,
  `complete` enum('Y','N','H','D') DEFAULT 'N',
  `s_handid` varchar(30) DEFAULT NULL,
  `s_userid` varchar(30) DEFAULT NULL,
  `t_handid` varchar(30) DEFAULT NULL,
  `t_userid` varchar(30) DEFAULT NULL,
  `cause_code` tinyint(1) DEFAULT '0',
  `cause_text` varchar(200) DEFAULT NULL,
  `chat` blob,
  PRIMARY KEY (`idx`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

insert into Patrol (game_code) values (2); 

or any other query which update Patrol table will make connection lost.

How to repeat:
Create above table and run query

insert into Patrol (game_code) values (2);
[16 Mar 2009 5:53] YOUNSANG KIM 
This schema and query have worked properly In 5.0.77-0.rhel4.i386 .
[16 Mar 2009 6:00] YOUNSANG KIM 
Oh sorry, I think this is a server problem not clients.
[16 Mar 2009 6:38] Sveta Smirnova 
Thank you for the report.

I can not repeat described behavior with current development sources, although bug is repeatable with 5.0.32 release.
[16 Mar 2009 6:49] Sveta Smirnova 
Forgot to add: please wait next release with fix.