Details

      Description

      This warning:

      Warning |  139 | Row size too large (> 8126). Changing some columns to TEXT or BLOB or using ROW_FORMAT=DYNAMIC or ROW_FORMAT=COMPRESSED may help. In current row format, *BLOB prefix of 768 bytes is stored inline
      

      that one gets while creating an InnoDB table (see comments below for specific syntax) with many columns, including varchar(N) with small enough N and utf8 character set, is misleading. Using ROW_FORMAT=DYNAMIC is not going to help. You'll get error instead:

      ERROR 1118 (42000): Row size too large (> 8126). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 bytes is stored inline.
      

      I'd also rephrase the error above, "0 bytes is stored inline" does not seem the best way to explain how the data are stored.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                kevg Eugene Kosov
                Reporter:
                Manasa ManasaTulluri
              • Votes:
                1 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: