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:Microsoft Windows (Windows Server 2003)
Assigned to: CPU Architecture:Any

[9 Mar 2005 15:52] Disha
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.
[9 Mar 2005 17:59] Trudy Pelzer
This is a duplcate of two bugs: Bug#7417 and #8295.