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
• Status: Verified
• Category: MySQL Server: DDL
• Severity: S3 (Non-critical)
• Version: 5.1.36
• OS: Any
• CPU Architecture: Any
• Tags: ALTER TABLE, Contribution

[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.