164 lines
7.0 KiB
Go
164 lines
7.0 KiB
Go
// Copyright 2017 PingCAP, Inc.
|
|
//
|
|
// Licensed under the Apache License, Version 2.0 (the "License");
|
|
// you may not use this file except in compliance with the License.
|
|
// You may obtain a copy of the License at
|
|
//
|
|
// http://www.apache.org/licenses/LICENSE-2.0
|
|
//
|
|
// Unless required by applicable law or agreed to in writing, software
|
|
// distributed under the License is distributed on an "AS IS" BASIS,
|
|
// WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
|
|
// See the License for the specific language governing permissions and
|
|
// limitations under the License.
|
|
|
|
package ddl_test
|
|
|
|
import (
|
|
"context"
|
|
"sync/atomic"
|
|
"testing"
|
|
"time"
|
|
|
|
"github.com/pingcap/tidb/pkg/ddl"
|
|
"github.com/pingcap/tidb/pkg/parser/ast"
|
|
"github.com/pingcap/tidb/pkg/session"
|
|
"github.com/pingcap/tidb/pkg/sessionctx/vardef"
|
|
"github.com/pingcap/tidb/pkg/store/mockstore"
|
|
"github.com/pingcap/tidb/pkg/tablecodec"
|
|
"github.com/pingcap/tidb/pkg/testkit"
|
|
"github.com/stretchr/testify/require"
|
|
"github.com/tikv/client-go/v2/tikv"
|
|
)
|
|
|
|
func TestTableSplit(t *testing.T) {
|
|
store, err := mockstore.NewMockStore(mockstore.WithStoreType(mockstore.EmbedUnistore))
|
|
require.NoError(t, err)
|
|
defer func() {
|
|
err := store.Close()
|
|
require.NoError(t, err)
|
|
}()
|
|
vardef.SetSchemaLease(100 * time.Millisecond)
|
|
session.DisableStats4Test()
|
|
atomic.StoreUint32(&ddl.EnableSplitTableRegion, 1)
|
|
dom, err := session.BootstrapSession(store)
|
|
require.NoError(t, err)
|
|
tk := testkit.NewTestKit(t, store)
|
|
tk.MustExec("use test")
|
|
// Synced split table region.
|
|
tk.MustExec("set @@session.tidb_scatter_region = 'table'")
|
|
tk.MustExec(`create table t_part (a int key) partition by range(a) (
|
|
partition p0 values less than (10),
|
|
partition p1 values less than (20)
|
|
)`)
|
|
tk.MustQuery("select @@global.tidb_scatter_region;").Check(testkit.Rows(""))
|
|
tk.MustExec("set @@global.tidb_scatter_region = 'table'")
|
|
tk = testkit.NewTestKit(t, store)
|
|
tk.MustExec("use test")
|
|
tk.MustExec(`create table t_part_2 (a int key) partition by range(a) (
|
|
partition p0 values less than (10),
|
|
partition p1 values less than (20)
|
|
)`)
|
|
defer dom.Close()
|
|
atomic.StoreUint32(&ddl.EnableSplitTableRegion, 0)
|
|
infoSchema := dom.InfoSchema()
|
|
require.NotNil(t, infoSchema)
|
|
tbl, err := infoSchema.TableByName(context.Background(), ast.NewCIStr("mysql"), ast.NewCIStr("tidb"))
|
|
require.NoError(t, err)
|
|
checkRegionStartWithTableID(t, tbl.Meta().ID, store.(kvStore))
|
|
|
|
tbl, err = infoSchema.TableByName(context.Background(), ast.NewCIStr("test"), ast.NewCIStr("t_part"))
|
|
require.NoError(t, err)
|
|
pi := tbl.Meta().GetPartitionInfo()
|
|
require.NotNil(t, pi)
|
|
for _, def := range pi.Definitions {
|
|
checkRegionStartWithTableID(t, def.ID, store.(kvStore))
|
|
}
|
|
tbl, err = infoSchema.TableByName(context.Background(), ast.NewCIStr("test"), ast.NewCIStr("t_part_2"))
|
|
require.NoError(t, err)
|
|
pi = tbl.Meta().GetPartitionInfo()
|
|
require.NotNil(t, pi)
|
|
for _, def := range pi.Definitions {
|
|
checkRegionStartWithTableID(t, def.ID, store.(kvStore))
|
|
}
|
|
}
|
|
|
|
// TestScatterRegion test the behavior of the tidb_scatter_region system variable, for verifying:
|
|
// 1. The variable can be set and queried correctly at both session and global levels.
|
|
// 2. Changes to the global variable affect new sessions but not existing ones.
|
|
// 3. The variable only accepts valid values (”, 'table', 'global').
|
|
// 4. Attempts to set invalid values result in appropriate error messages.
|
|
func TestScatterRegion(t *testing.T) {
|
|
store := testkit.CreateMockStore(t)
|
|
tk := testkit.NewTestKit(t, store)
|
|
tk2 := testkit.NewTestKit(t, store)
|
|
|
|
tk.MustQuery("select @@tidb_scatter_region;").Check(testkit.Rows(""))
|
|
tk.MustExec("set @@tidb_scatter_region = 'table';")
|
|
tk.MustQuery("select @@tidb_scatter_region;").Check(testkit.Rows("table"))
|
|
tk.MustExec("set @@tidb_scatter_region = 'global';")
|
|
tk.MustQuery("select @@tidb_scatter_region;").Check(testkit.Rows("global"))
|
|
tk.MustExec("set @@tidb_scatter_region = 'TABLE';")
|
|
tk.MustQuery("select @@tidb_scatter_region;").Check(testkit.Rows("table"))
|
|
tk.MustExec("set @@tidb_scatter_region = 'GLOBAL';")
|
|
tk.MustQuery("select @@tidb_scatter_region;").Check(testkit.Rows("global"))
|
|
tk.MustExec("set @@tidb_scatter_region = '';")
|
|
tk.MustQuery("select @@tidb_scatter_region;").Check(testkit.Rows(""))
|
|
|
|
tk.MustExec("set global tidb_scatter_region = 'table';")
|
|
tk.MustQuery("select @@global.tidb_scatter_region;").Check(testkit.Rows("table"))
|
|
tk.MustQuery("select @@tidb_scatter_region;").Check(testkit.Rows(""))
|
|
tk2.MustQuery("select @@tidb_scatter_region;").Check(testkit.Rows(""))
|
|
tk2 = testkit.NewTestKit(t, store)
|
|
tk2.MustQuery("select @@tidb_scatter_region;").Check(testkit.Rows("table"))
|
|
|
|
tk.MustExec("set global tidb_scatter_region = 'global';")
|
|
tk.MustQuery("select @@global.tidb_scatter_region;").Check(testkit.Rows("global"))
|
|
tk.MustExec("set global tidb_scatter_region = '';")
|
|
tk.MustQuery("select @@global.tidb_scatter_region;").Check(testkit.Rows(""))
|
|
tk2 = testkit.NewTestKit(t, store)
|
|
tk2.MustQuery("select @@tidb_scatter_region;").Check(testkit.Rows(""))
|
|
|
|
tk.MustExec("set global tidb_scatter_region = 'TABLE';")
|
|
tk.MustQuery("select @@global.tidb_scatter_region;").Check(testkit.Rows("table"))
|
|
tk.MustQuery("select @@tidb_scatter_region;").Check(testkit.Rows(""))
|
|
tk2 = testkit.NewTestKit(t, store)
|
|
tk2.MustQuery("select @@tidb_scatter_region;").Check(testkit.Rows("table"))
|
|
|
|
tk.MustExec("set global tidb_scatter_region = 'GLOBAL';")
|
|
tk.MustQuery("select @@global.tidb_scatter_region;").Check(testkit.Rows("global"))
|
|
tk.MustExec("set global tidb_scatter_region = '';")
|
|
tk.MustQuery("select @@global.tidb_scatter_region;").Check(testkit.Rows(""))
|
|
|
|
err := tk.ExecToErr("set @@tidb_scatter_region = 'test';")
|
|
require.ErrorContains(t, err, "invalid value for 'test', it should be either '', 'table' or 'global'")
|
|
err = tk.ExecToErr("set @@tidb_scatter_region = 'te st';")
|
|
require.ErrorContains(t, err, "invalid value for 'te st', it should be either '', 'table' or 'global'")
|
|
err = tk.ExecToErr("set @@tidb_scatter_region = '1';")
|
|
require.ErrorContains(t, err, "invalid value for '1', it should be either '', 'table' or 'global'")
|
|
err = tk.ExecToErr("set @@tidb_scatter_region = 0;")
|
|
require.ErrorContains(t, err, "invalid value for '0', it should be either '', 'table' or 'global'")
|
|
|
|
tk.MustQuery("select @@tidb_scatter_region;").Check(testkit.Rows(""))
|
|
tk.MustExec("set @@tidb_scatter_region = 'TaBlE';")
|
|
tk.MustQuery("select @@tidb_scatter_region;").Check(testkit.Rows("table"))
|
|
tk.MustExec("set @@tidb_scatter_region = 'gLoBaL';")
|
|
tk.MustQuery("select @@tidb_scatter_region;").Check(testkit.Rows("global"))
|
|
}
|
|
|
|
type kvStore interface {
|
|
GetRegionCache() *tikv.RegionCache
|
|
}
|
|
|
|
func checkRegionStartWithTableID(t *testing.T, id int64, store kvStore) {
|
|
regionStartKey := tablecodec.EncodeTablePrefix(id)
|
|
var loc *tikv.KeyLocation
|
|
var err error
|
|
cache := store.GetRegionCache()
|
|
loc, err = cache.LocateKey(tikv.NewBackoffer(context.Background(), 5000), regionStartKey)
|
|
require.NoError(t, err)
|
|
// Region cache may be out of date, so we need to drop this expired region and load it again.
|
|
cache.InvalidateCachedRegion(loc.Region)
|
|
require.Equal(t, []byte(regionStartKey), loc.StartKey)
|
|
}
|