6.1该字段还是隐藏状态,6.2后就可以看到了。
处于隐藏状态的变量可以设置,但是你看不到。
https://github.com/pingcap/tidb/blob/73d82e330b02a39f74073d98daefbadd7deab9b9/sessionctx/variable/sysvar.go#L1500C98-L1500C102
Hidden: true
{Scope: ScopeGlobal | ScopeSession, Name: TiDBEnablePaging, Value: BoolToOnOff(DefTiDBEnablePaging), Type: TypeBool, Hidden: true, SetSession: func(s *SessionVars, val string) error {
s.EnablePaging = TiDBOptOn(val)
return nil
}
这个PR是remove掉Hidden关键字了,后面没这种情况了。
https://github.com/pingcap/tidb/pull/35740
// Deprecated: Hidden previously meant that the variable still responds to SET but doesn't show up in SHOW VARIABLES
// However, this feature is no longer used. All variables are visble.