Bug #22769 column's type text change to mediumtext auto

• Submitted: 28 Sep 2006 4:29
• Modified: 28 Sep 2006 11:54
• Reporter: zhang yan
• Status: Can't repeat
• Category: MySQL Server
• Severity: S2 (Serious)
• Version: MySQL 5.0.x
• OS: Windows (Windows XP SP2)
• CPU Architecture: Any
• Tags: text mediumtext

[28 Sep 2006 4:29] zhang yan

Description:
if The table have any columns(above two),and some column's type are text.Then,I change anyone of the others,or insert a new column.The type will change to mediumtext auto except changed or inserted.

How to repeat:
by email [e-mail]

Suggested fix:
Yes

[28 Sep 2006 11:54] Valeriy Kravchuk

Sorry, but I can not repeat the results you described based on your report:

mysql> create table t22769 (c1 int, c2 text, c3 text);
Query OK, 0 rows affected (0.02 sec)

mysql> show create table t22769\G
*************************** 1. row ***************************
       Table: t22769
Create Table: CREATE TABLE `t22769` (
  `c1` int(11) default NULL,
  `c2` text,
  `c3` text
) ENGINE=MyISAM DEFAULT CHARSET=latin1
1 row in set (0.00 sec)

mysql> alter table t22769 modify c1 decimal;
Query OK, 0 rows affected (0.02 sec)
Records: 0  Duplicates: 0  Warnings: 0

mysql> show create table t22769\G
*************************** 1. row ***************************
       Table: t22769
Create Table: CREATE TABLE `t22769` (
  `c1` decimal(10,0) default NULL,
  `c2` text,
  `c3` text
) ENGINE=MyISAM DEFAULT CHARSET=latin1
1 row in set (0.01 sec)

mysql> alter table t22769 add c4 varchar(100);
Query OK, 0 rows affected (0.02 sec)
Records: 0  Duplicates: 0  Warnings: 0

mysql> show create table t22769\G
*************************** 1. row ***************************
       Table: t22769
Create Table: CREATE TABLE `t22769` (
  `c1` decimal(10,0) default NULL,
  `c2` text,
  `c3` text,
  `c4` varchar(100) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1
1 row in set (0.01 sec)

If you have a set of SQL statements that demonstrates the behaviour described, please, send it.