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

INNODB_ERROR|Cannot add field in table because after adding it, the row size is greater than the maximum allowed size for a record on index leaf page

    XMLWordPrintable

Details

    • Can result in unexpected behaviour

    Description

      CREATE TABLE t (a CHAR(1) KEY,b CHAR(10),c CHAR(10),l00 CHAR(255),l01 CHAR(255),l02 CHAR(255),l03 CHAR(255),l04 CHAR(255),l05 CHAR(255),l06 CHAR(255),l07 CHAR(255),l08 CHAR(255),l09 CHAR(255),l10 CHAR(255),l11 CHAR(255),l12 CHAR(255),l13 CHAR(255),l14 CHAR(255),l15 CHAR(255),l16 CHAR(255),l17 CHAR(255),l18 CHAR(255),l19 CHAR(255),l20 CHAR(255),l21 CHAR(255),l22 CHAR(255),l23 CHAR(255),l24 CHAR(255),l25 CHAR(255),l26 CHAR(255),l27 CHAR(255),l28 CHAR(255),l29 CHAR(255),l30 CHAR(255),l31 CHAR(255),INDEX (c,b)) ;
      

      Leads to:

      CS 11.4.9 7e76a58e0b35f8b126b4450fabdb165284b9b347 (Debug, Clang 18.1.3-11) Build 15/09/2025

       INNODB_ERROR|Cannot add field in table because after adding it, the row size is greater than the maximum allowed size for a record on index leaf page
      

      Bug Detection Matrix

          Rel    o/d  Build   Commit                                    UniqueID observed             
      CS  10.6   dbg  150925  6058e0273230adcf71019dcde0c4d390f49aefa5  INNODB_ERROR|Cannot add field in table because after adding it, the row size is greater than the maximum allowed size for a record on index leaf page
      CS  10.6   opt  150925  6058e0273230adcf71019dcde0c4d390f49aefa5  INNODB_ERROR|Cannot add field in table because after adding it, the row size is greater than the maximum allowed size for a record on index leaf page
      CS  10.11  dbg  150925  fe59b4ce96cd1318f3e73edc2452ef30b76696e2  INNODB_ERROR|Cannot add field in table because after adding it, the row size is greater than the maximum allowed size for a record on index leaf page
      CS  10.11  opt  150925  fe59b4ce96cd1318f3e73edc2452ef30b76696e2  INNODB_ERROR|Cannot add field in table because after adding it, the row size is greater than the maximum allowed size for a record on index leaf page
      CS  11.4   dbg  150925  7e76a58e0b35f8b126b4450fabdb165284b9b347  INNODB_ERROR|Cannot add field in table because after adding it, the row size is greater than the maximum allowed size for a record on index leaf page
      CS  11.4   opt  150925  7e76a58e0b35f8b126b4450fabdb165284b9b347  INNODB_ERROR|Cannot add field in table because after adding it, the row size is greater than the maximum allowed size for a record on index leaf page
      CS  11.8   dbg  150925  d203a8a5df95e2c5778a304a885fb7aedfbc095e  No bug found                  
      CS  11.8   opt  150925  d203a8a5df95e2c5778a304a885fb7aedfbc095e  No bug found                  
      CS  12.1   dbg  150925  667c5e0b002a24bc595d60955950200a588f4fb7  No bug found                  
      CS  12.1   opt  150925  667c5e0b002a24bc595d60955950200a588f4fb7  No bug found                  
      CS  12.2   dbg  150925  e02f4d7e311e214ea62ff2e59599849e229f4165  No bug found                  
      CS  12.2   opt  150925  e02f4d7e311e214ea62ff2e59599849e229f4165  No bug found                  
      ES  10.6   dbg  150925  03edb6e93d5eb550849287ed797c9b4032205233  INNODB_ERROR|Cannot add field in table because after adding it, the row size is greater than the maximum allowed size for a record on index leaf page
      ES  10.6   opt  150925  03edb6e93d5eb550849287ed797c9b4032205233  INNODB_ERROR|Cannot add field in table because after adding it, the row size is greater than the maximum allowed size for a record on index leaf page
      ES  11.4   dbg  150925  84994dfd14a8ed018a6794b7cab9b13f2e4bd7b8  INNODB_ERROR|Cannot add field in table because after adding it, the row size is greater than the maximum allowed size for a record on index leaf page
      ES  11.4   opt  150925  84994dfd14a8ed018a6794b7cab9b13f2e4bd7b8  INNODB_ERROR|Cannot add field in table because after adding it, the row size is greater than the maximum allowed size for a record on index leaf page
      ES  11.8   dbg  150925  0d06f96e3bd9ccbe19f23876a7b3117054c3a0fd  No bug found                  
      ES  11.8   opt  150925  0d06f96e3bd9ccbe19f23876a7b3117054c3a0fd  No bug found                  
      

      Attachments

        Activity

          People

            marko Marko Mäkelä
            saahil Saahil Alam
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.