diff options
| author | Thirunarayanan Balathandayuthapani <thiru@mariadb.com> | 2019-01-30 15:32:51 +0530 |
|---|---|---|
| committer | Thirunarayanan Balathandayuthapani <thiru@mariadb.com> | 2019-01-30 15:33:32 +0530 |
| commit | b8aef87221c46c82921377f18a6498a31f7e5367 (patch) | |
| tree | a716ea5d4d13450d4a2edccc22069922bba63ffd /sql/handler.h | |
| parent | 97930df13c0e403940969ebb47398760b59f753c (diff) | |
| download | mariadb-git-b8aef87221c46c82921377f18a6498a31f7e5367.tar.gz | |
MDEV-16849 Extending indexed VARCHAR column should be instantaneous
Analysis:
========
Increasing the length of the indexed varchar column is not an instant operation for
innodb.
Fix:
===
- Introduce the new handler flag 'Alter_inplace_info::ALTER_COLUMN_INDEX_LENGTH' to
indicate the index length differs due to change of column length changes.
- InnoDB makes the ALTER_COLUMN_INDEX_LENGTH flag as instant operation.
This is a port of Mysql fix.
commit 913071c0b16cc03e703308250d795bc381627e37
Author: Nisha Gopalakrishnan <nisha.gopalakrishnan@oracle.com>
Date: Wed May 30 14:54:46 2018 +0530
BUG#26848813: INDEXED COLUMN CAN'T BE CHANGED FROM VARCHAR(15)
TO VARCHAR(40) INSTANTANEOUSLY
Diffstat (limited to 'sql/handler.h')
| -rw-r--r-- | sql/handler.h | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/sql/handler.h b/sql/handler.h index 284fed7cd7e..229197a2c78 100644 --- a/sql/handler.h +++ b/sql/handler.h @@ -2002,6 +2002,11 @@ public: static const HA_ALTER_FLAGS ALTER_DROP_CHECK_CONSTRAINT= 1ULL << 40; /** + Change in index length such that it doesn't require index rebuild. + */ + static const HA_ALTER_FLAGS ALTER_COLUMN_INDEX_LENGTH= 1ULL << 41; + + /** Create options (like MAX_ROWS) for the new version of table. @note The referenced instance of HA_CREATE_INFO object was already |