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 thoughts on “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. 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

This site uses Akismet to reduce spam. Learn how your comment data is processed.