Bug #64375 create table fails if record size is bigger than 8k using CHAR fields
Submitted: 19 Feb 2012 0:33 Modified: 13 Apr 2012 11:34
Reporter: Gabor Zele Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Cluster: Cluster (NDB) storage engine Severity:S3 (Non-critical)
Version:mysql-5.5.19 ndb-7.2.4 OS:Linux (Debian 6.0 64-bit)
Assigned to: CPU Architecture:Any
Tags: char, ndbcluster

[19 Feb 2012 0:33] Gabor Zele
Description:
I cannot create more than 10 char(250) fields (utf8) or 30 char(250) fields (latin1) using 5.5.19/7.2.4. This quantity does not exceeds the 14.000 bytes record limit, actually it works in version 5.1/7.1.15a. 10 char(250) and 1 varchar(1000) field in a UTF8 table also works.

How to repeat:
 create table t14(c1 char(250),c2 char(250), c3 char(250), c4 char(250), c5 char(250), c6 char(250), c7 char(250), c8 char(250), c9 char (250), c10 char(250),c11 char(250)) engine=ndb default charset=utf8;
ERROR 1005 (HY000): Can't create table 'test.t14' (errno: 851)

but this works:
 create table t13(c1 char(250),c2 char(250), c3 char(250), c4 char(250), c5 char(250), c6 char(250), c7 char(250), c8 char(250), c9 char (250), c10 char(250),c11 varchar(1000)) engine=ndb default charset=utf8;

Also the same with latin1:
create table t11(c1 char(250),c2 char(250), c3 char(250), c4 char(250), c5 char(250), c6 char(250), c7 char(250), c8 char(250), c9 char (250), c10 char(250),c11 char(250), c12 char(250), c13 char(250), c14 char(250), c15 char(250), c16 char(250), c17 char(250), c18 char(250), c19 char(250), c20 char(250), c21 char(250), c22 char(250), c23 char(250), c24 char(250), c25 char(250), c26 char(250), c27 char(250), c28 char(250), c29 char(250), c30 char(250), c31 char(250), c32 char(250), c33 char(250), c34 char(250) ) engine=ndb default charset=latin1;
ERROR 1005 (HY000): Can't create table 'test.t11' (errno: 851)

both queries work with previous version 5.1/7.1.15a
[13 Apr 2012 11:34] MySQL Verification Team
Verified just as described on #64375:

Testcase details attached separately 64375.txt.