diff options
author | Nikita Malyavin <nikitamalyavin@gmail.com> | 2020-12-21 22:54:27 +1000 |
---|---|---|
committer | Nikita Malyavin <nikitamalyavin@gmail.com> | 2021-01-05 19:19:27 +1000 |
commit | 9a645dae9e59ec398cfda33529c44002625ddc87 (patch) | |
tree | 4419cc239868a3c4b45415c60b031bf69235476a /scripts/mysql_install_db.sh | |
parent | f0baa8648493a6368f45c6cbf459832d5027aaff (diff) | |
download | mariadb-git-9a645dae9e59ec398cfda33529c44002625ddc87.tar.gz |
MDEV-23632 ALTER TABLE...ADD KEY creates corrupted index on virtual column
mysql_col_offset was not updated after the new column has been added by an
INSTANT ALTER TABLE -- table data dictionary had been remaining the same.
When the virtual column is added or removed, table was usually evicted and
then reopened, which triggered vcol info rebuild on the next open.
However this also should be done when the usual column is added or removed:
mariadb always stores virtual field at the end of maria record,
so the shift should always happen.
Fix:
expand the eviction condition to the case when usual fields are
added/removed
Note:
this should happen only in the case of !new_clustered:
* When new_clustered is true, a new data dictionary is created, and vcol
metadata is rebuilt in `alter_rebuild_apply_log()`
* We can't do it in `new_clustered` case, because the old table is not yet
subctituted correctly
Diffstat (limited to 'scripts/mysql_install_db.sh')
0 files changed, 0 insertions, 0 deletions