Bug #40323 Create .frm file with size greater than 64KB
Submitted: 24 Oct 2008 21:37 Modified: 27 Oct 2008 18:34
Reporter: Joe Bremer Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server: General Severity:S2 (Serious)
Version:5.0.45 OS:Linux
Assigned to: CPU Architecture:Any

[24 Oct 2008 21:37] Joe Bremer
Description:
The documentation states 

"Each table has an .frm file that contains the table definition. The .frm file size limit is fixed at 64KB."

However, a table can be created where the actual size of the .frm file is over 80KB while the result of the formula for max columns is below 64KB.

How to repeat:
See the attached CREATE TABLE statement.

[root@lxxx xxxx]# ll DATEST*
-rw-rw----    1 mysql    mysql       84081 Jan 18 07:51 DATEST.frm
-rw-rw----    1 mysql    mysql           0 Jan 18 07:51 DATEST.MYD
-rw-rw----    1 mysql    mysql        9216 Jan 18 07:51 DATEST.MYI
[24 Oct 2008 21:37] Joe Bremer
Create Tabke

Attachment: GetColumns.txt (text/plain), 58.76 KiB.

[26 Oct 2008 7:04] Sveta Smirnova
Please do not submit the same bug more than once. An existing bug report already describes this very problem. Even if you feel that your issue is somewhat different, the resolution is likely
to be the same. Because of this, we hope you add your comments to the original bug instead.

Thank you for your interest in MySQL.

Duplicate of bug #33925
[27 Oct 2008 18:34] Joe Bremer
Wrong version