MySQL Bugs: #9076: VARCHAR col with length above 65532 is not allowed by MyISAM engine

Bug #9076	VARCHAR col with length above 65532 is not allowed by MyISAM engine
Submitted:	9 Mar 2005 15:52	Modified:	9 Mar 2005 17:59
Reporter:	Disha	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Server: MyISAM storage engine	Severity:	S3 (Non-critical)
Version:	5.0.3-alpha-nt	OS:	Windows (Windows Server 2003)
Assigned to:		CPU Architecture:	Any

Description:
When we try to create a table having a field as VARCHAR with length more than 65532, an unexpected error is displayed if we use the MyISAM engine.

How to repeat:

 Repro Steps: 
 1. Connect to MySQL server with valid user name and password.
 
 2. Select the TEST database with the USE command as follows:
 USE TEST
 
 3. Drop any table having name T1
 
 4. Create a table with name T1 having a VARCHAR field of length more than 65532 having the MyISAM engine as follows:
 CREATE TABLE T1(F1 VARCHAR(65534)) ENGINE=MYISAM//
 
 Expected Results: The table should be created with VARCHAR column having length 65534.

 Actual Results: The table creation fails with the following error:
 "ERROR 1118 (42000): Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. You have to change some columns to TEXT or BLOBs"

 Additional Info: We observed this behavior for length values form 65533 to 65535. But if we specify the length as 65536 and above the datatype is silently converted to TEXT.

This is a duplcate of two bugs: Bug#7417 and #8295.