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

CREATE INDEX may check the wrong maximum column length

Details

    Description

      In ha_innobase::prepare_inplace_alter_table() when the table is not being rebuilt, max_col_len must be determined based on the current table:

      diff --git a/storage/innobase/handler/handler0alter.cc b/storage/innobase/handler/handler0alter.cc
      		 
      index 3ac4f4fe4c1..1b4b48e90f7 100644
      		 
      --- a/storage/innobase/handler/handler0alter.cc
      		 
      +++ b/storage/innobase/handler/handler0alter.cc
      		 
      @@ -5601,7 +5601,14 @@ ha_innobase::prepare_inplace_alter_table(
      		 
       			       & 1U << DICT_TF_POS_DATA_DIR);
      		 
       	}
      		 
       
      -	max_col_len = DICT_MAX_FIELD_LEN_BY_FORMAT_FLAG(info.flags());
      		 
      +
      		 
      +	/* ALGORITHM=COPY uses the default row format while
      		 
      +	ALGORITHM=INPLACE uses the current format. Find the limit for
      		 
      +	the resulting format.*/
      		 
      +	max_col_len = DICT_MAX_FIELD_LEN_BY_FORMAT_FLAG(
      		 
      +		innobase_need_rebuild(ha_alter_info, this->table)
      		 
      +		? info.flags()
      		 
      +		: m_prebuilt->table->flags);
      		 
       
       	/* Check each index's column length to make sure they do not
      		 
       	exceed limit */

      When no ROW_FORMAT is explicitly specified and the value of innodb_default_row_format is changed between CREATE TABLE and ALTER TABLE…ADD INDEX (or CREATE INDEX), we could enforce the wrong maximum column length limitation. For ROW_FORMAT=REDUNDANT and ROW_FORMAT=COMPACT, the maximum column length for a full-column index is 767 bytes.

      Attachments

        Issue Links

          blocks

          Bug - A problem which impairs or prevents the functions of the product. MDEV-26205 Merge new release of InnoDB 5.7.35 to 10.2

          • Blocker - Blocks development and/or testing work, production could not run.
          • Closed

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

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