Bug #46506 Lost CONNECTION string after executing "alter table" statement
Submitted: 1 Aug 2009 6:36 Modified: 1 Aug 2009 8:33
Reporter: kentoku shiba Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: DDL Severity:S3 (Non-critical)
Version:5.1.36 OS:Any
Assigned to: CPU Architecture:Any
Tags: ALTER TABLE, Contribution
Triage: Triaged: D4 (Minor)

[1 Aug 2009 6:36] kentoku shiba
Description:
Lost CONNECTION string after executing "alter table" statement.

How to repeat:
mysql> create table t1(
    -> id int NOT NULL default 0
    -> ) ENGINE=myisam DEFAULT CHARSET=utf8
    -> CONNECTION='test string';
Query OK, 0 rows affected (0.00 sec)

mysql> show create table t1\G
*************************** 1. row ***************************
       Table: t1
Create Table: CREATE TABLE `t1` (
  `id` int(11) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 CONNECTION='test string'
1 row in set (0.01 sec)

mysql> alter table t1 engine=myisam;
Query OK, 0 rows affected (0.04 sec)
Records: 0  Duplicates: 0  Warnings: 0

mysql> show create table t1\G
*************************** 1. row ***************************
       Table: t1
Create Table: CREATE TABLE `t1` (
  `id` int(11) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8
1 row in set (0.00 sec)
[1 Aug 2009 6:39] kentoku shiba
Contribution patch file for fixing this problem.

Attachment: mysql-5.1.36.spider.diff (, text), 1.09 KiB.

[1 Aug 2009 8:33] Sveta Smirnova
Thank you for the report.

Verified as described.
[21 Jul 2010 22:32] Chris Calender
Workaround: specify CONNECTION="..." again in your ALTER statement.