com.alibaba.innodb.java.reader.schema

类 Workaround

java.lang.Object

com.alibaba.innodb.java.reader.schema.Workaround

public class Workaround
extends Object

Workaround for features that supported in a non-standard way.

作者:

xu.zx

构造器概要

构造器

构造器和说明
Workaround()

方法概要

限定符和类型	方法和说明
static long	getSkRootPageNumber(TableDef tableDef, String skName, Optional<Integer> skOrdinal, java.util.function.Function<Long,Index> func) Get secondary key root page number.

从类继承的方法 java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

构造器详细资料

Workaround

public Workaround()

方法详细资料

getSkRootPageNumber

public static long getSkRootPageNumber(TableDef tableDef,
                                       String skName,
                                       Optional<Integer> skOrdinal,
                                       java.util.function.Function<Long,Index> func)

Get secondary key root page number.

Find clustered index root page and calculate sk page number based on it. Note that if table has ever been altered to add or remove indices, the secondary key root page number may be incorrect, and cause error.

MySQL will set FULLTEXT KEY, UNIQUE KEY ahead of normal KEY, but in SHOW CREATE TABLE command, the FULLTEXT KEY goes to the end, so here the workaround is to add the delta of fulltext key count.

More standard way would be to look up root page number by: SELECT * FROM INFORMATION_SCHEMA.INNODB_SYS_INDEXES; before 5.7 or SELECT * FROM INFORMATION_SCHEMA.INNODB_INDEXES; after 8.0

参数:

tableDef - table definition

skName - secondary key name

skOrdinal - secondary key ordinal in SHOW CREATE TABLE command

func - function to apply on page number and return the loaded index page

返回:

secondary key root page number