Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-14492

Record size greater than 64k

    XMLWordPrintable

    Details

      Description

      ERROR 1118 (42000): Row size too large. The maximum row size for the used table
      type, not counting BLOBs, is 65535. This includes storage overhead, check the ma
      nual. You have to change some columns to TEXT or BLOBs

      I don't want use blobs for long varbinary fields because there is possibility to index by them. The user in their CMS has possibility to "alter table add column" to configure their database. The length exceeded today 65535 and system is blocked. I retested the system on Windows. I don;t know what error is issued on production version.

      This bug probably by compatibility is present also in MariaDB.

        Attachments

          Activity

            People

            Assignee:
            serg Sergei Golubchik
            Reporter:
            MariaDB/MySQL user MariaDB/MySQL user
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: