Details
-
Task
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
None
-
None
-
None
Description
This feature is ported from upstream 8.0.
|
|
As 8.0 introduces Data Dictionary which substitute metadata files
|
in server layer used in previous version(such as frm) , so there are
|
some subtle differences.
|
1. we store index visibility info in frm
|
2. we use the HA_SORT_ALLOWS_SAME flag, which was not stored in frm
|
before, in frm to indicate HA_INVISIBLE_KEY, so that we don't need
|
to expand frm format, and compatibility is held.
|
https://github.com/alibaba/AliSQL/commit/238c63990e85fa6c11cce1b5af8350ea5664fef8
Description
|
============
|
bug#88847, this issue is related to invisible indexes feature which we ported
|
from 8.0 upstream. Invisible index is not considered by slave SQL row applier
|
when searching index to use, and choosed anyway as long as the index is fit for
|
update.
|
|
Solution:
|
============
|
Make slave SQL applier thread respecting invisible indexes and don't choose them
|
when searching index to use.
|
https://github.com/alibaba/AliSQL/commit/229996d67b4caaf27a330491b9e668dc7e0c0120
Attachments
Issue Links
- causes
-
MDEV-19102 [bugfix] Issue: #56 invisible index is not respected by slave under row format
- Closed
- is part of
-
MDEV-28906 MySQL 8.0 desired compatibility
- Open