Re: ERROR 1117 "too many columns" in create stmt

[Shane Bester]

Well, this code explains why < max row size and < 4096 fields may be tolerated:


in unireg.cc

/* Hack to avoid bugs with small static rows in MySQL */
reclength=max(file->min_record_length(table_options),reclength);
if (info_length+(ulong) create_fields.elements*FCOMP+288+
n_length+int_length+com_length > 65535L || int_count > 255)
{
my_message(ER_TOO_MANY_FIELDS, ER(ER_TOO_MANY_FIELDS), MYF(0));
DBUG_RETURN(1);
}


So, in 5.0.44 max number in tinyint cols is 2410..