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

create table fails with row size too large in 10.3 but not 10.1

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Critical
    • Resolution: Duplicate
    • Affects Version/s: 10.3.17
    • Fix Version/s: N/A
    • Component/s: Server
    • Labels:
      None

      Description

      The following create table fails on 10.3 but works fine on 10.1.

      Error is: 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.

      How to reproduce:

      CREATE TABLE `orders` (   `id` int(11) NOT NULL AUTO_INCREMENT,   `field1` varchar(255) DEFAULT NULL,   `field2` varchar(255) DEFAULT NULL,   `creationDate` datetime DEFAULT NULL,   `modificationDate` datetime DEFAULT NULL,   `modifiedBy` varchar(255) DEFAULT NULL,   `modifiedBySystem` varchar(255) DEFAULT NULL,   `field4` datetime DEFAULT NULL,   `field5` varchar(255) DEFAULT NULL,   `field6` varchar(255) DEFAULT NULL,   `field7` varchar(255) DEFAULT NULL,   `field8` datetime DEFAULT NULL,   `fuffa` varchar(255) DEFAULT NULL,   `field9` varchar(255) DEFAULT NULL,   `field10` varchar(255) DEFAULT NULL,   `fuffa2` datetime DEFAULT NULL,   `field11` varchar(255) DEFAULT NULL,   `field12` varchar(255) DEFAULT NULL,   `field13` varchar(255) DEFAULT NULL,   `field14` varchar(255) DEFAULT NULL,   `field15` varchar(255) DEFAULT NULL,   `field16` varchar(255) DEFAULT NULL,   `field17` int(11) DEFAULT NULL,   `field18` varchar(255) DEFAULT NULL,   `field19` varchar(255) DEFAULT NULL,   `field20` varchar(255) DEFAULT NULL,   `field21` varchar(255) DEFAULT NULL,   `field22` int(11) DEFAULT NULL,   `field23` varchar(255) DEFAULT NULL,   `field24` varchar(255) DEFAULT NULL,   `field25` varchar(255) DEFAULT NULL,   `field26` varchar(255) DEFAULT NULL,   `field27` varchar(255) DEFAULT NULL,   `field28` varchar(255) DEFAULT NULL,   `field29` varchar(255) DEFAULT NULL,   `field30` varchar(255) DEFAULT NULL,   `field31` int(11) DEFAULT NULL,   `field32` varchar(255) DEFAULT NULL,   `field33` varchar(255) DEFAULT NULL,   `field34` varchar(255) DEFAULT NULL,   `field35` varchar(255) DEFAULT NULL,   `field36` varchar(255) DEFAULT NULL,   `field37` varchar(255) DEFAULT NULL,   `field38` varchar(255) DEFAULT NULL,   `field39` varchar(255) DEFAULT NULL,   `field40` varchar(255) DEFAULT NULL,   `field41` varchar(25T NULL,   `field46` varchar(255) DEFAULT NULL,   `field47` varchar(255) DEFAULT NULL,   `field48` varchar(255) DEFAULT NULL,   `field49` varchar(255) DEFAULT NULL,   `field50` varchar(255) DEFAULT NULL,   `field51` varchar(255) DEFAULT NULL,   `field52` int(11) DEFAULT NULL,   `field53` varchar(255) DEFAULT NULL,   `field54` varchar(255) DEFAULT NULL,   `field55` tinyint(1) DEFAULT NULL,   `field56` varchar(255) DEFAULT NULL,   `field57` varchar(255) DEFAULT NULL,   `field58` varchar(255) DEFAULT NULL,   PRIMARY KEY (`id`)) Engine=InnoDB;
      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.
      

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                kevg Eugene Kosov
                Reporter:
                rpizzi Rick Pizzi
              • Votes:
                1 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: