maximum number of columns (hard limit)

#define MAX_FIELDS 4096 /* Limit in the .frm file */

I should be able to remove this limitation soon. Although if you come anywhere near it, you probably have already lost (and written your own engine).

2 Responses to “maximum number of columns (hard limit)”

  1. Hi!

    yeah…”no hard-wired limits” is good. But for practical purposes, the 64k row length is a much bigger problem. Or maybe that has been torn out of Drizzle?

    regards,

    Roland

  2. Arjen Lentz says:

    Some engines have other limitations of 512 or 1024 columns. The rule is indeed that if you get even close, your design is wrong.
    While I agree with the “no hardcoded limits” in principle, for this one I really don’t give a stuff that it exists. Roland Bouman addresses the more relevant concern of max row length (excluding blob/text fields).

Leave a Reply