You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
 
 

258 lines
6.5 KiB

// Copyright 2016 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,
// See the License for the specific language governing permissions and
// limitations under the License.
package tables_test
import (
"context"
"io"
"time"
. "github.com/pingcap/check"
"github.com/pingcap/parser/model"
"github.com/pingcap/parser/mysql"
"github.com/pingcap/parser/terror"
"github.com/pingcap/tidb/domain"
"github.com/pingcap/tidb/kv"
"github.com/pingcap/tidb/session"
"github.com/pingcap/tidb/sessionctx/stmtctx"
"github.com/pingcap/tidb/store/mockstore"
"github.com/pingcap/tidb/table/tables"
"github.com/pingcap/tidb/types"
"github.com/pingcap/tidb/util/mock"
"github.com/pingcap/tidb/util/testleak"
)
var _ = Suite(&testIndexSuite{})
type testIndexSuite struct {
s kv.Storage
dom *domain.Domain
}
func (s *testIndexSuite) SetUpSuite(c *C) {
testleak.BeforeTest()
store, err := mockstore.NewMockTikvStore()
c.Assert(err, IsNil)
s.s = store
s.dom, err = session.BootstrapSession(store)
c.Assert(err, IsNil)
}
func (s *testIndexSuite) TearDownSuite(c *C) {
s.dom.Close()
err := s.s.Close()
c.Assert(err, IsNil)
testleak.AfterTest(c)()
}
func (s *testIndexSuite) TestIndex(c *C) {
tblInfo := &model.TableInfo{
ID: 1,
Indices: []*model.IndexInfo{
{
ID: 2,
Name: model.NewCIStr("test"),
Columns: []*model.IndexColumn{
{Offset: 0},
{Offset: 1},
},
},
},
Columns: []*model.ColumnInfo{
{ID: 1, Name: model.NewCIStr("c2"), State: model.StatePublic, Offset: 0, FieldType: *types.NewFieldType(mysql.TypeVarchar)},
{ID: 2, Name: model.NewCIStr("c2"), State: model.StatePublic, Offset: 1, FieldType: *types.NewFieldType(mysql.TypeString)},
},
}
index := tables.NewIndex(tblInfo.ID, tblInfo, tblInfo.Indices[0])
// Test ununiq index.
txn, err := s.s.Begin()
c.Assert(err, IsNil)
values := types.MakeDatums(1, 2)
mockCtx := mock.NewContext()
_, err = index.Create(mockCtx, txn, values, 1)
c.Assert(err, IsNil)
it, err := index.SeekFirst(txn)
c.Assert(err, IsNil)
getValues, h, err := it.Next()
c.Assert(err, IsNil)
c.Assert(getValues, HasLen, 2)
c.Assert(getValues[0].GetInt64(), Equals, int64(1))
c.Assert(getValues[1].GetInt64(), Equals, int64(2))
c.Assert(h, Equals, int64(1))
it.Close()
sc := &stmtctx.StatementContext{TimeZone: time.Local}
exist, _, err := index.Exist(sc, txn, values, 100)
c.Assert(err, IsNil)
c.Assert(exist, IsFalse)
exist, _, err = index.Exist(sc, txn, values, 1)
c.Assert(err, IsNil)
c.Assert(exist, IsTrue)
err = index.Delete(sc, txn, values, 1)
c.Assert(err, IsNil)
it, err = index.SeekFirst(txn)
c.Assert(err, IsNil)
_, _, err = it.Next()
c.Assert(terror.ErrorEqual(err, io.EOF), IsTrue, Commentf("err %v", err))
it.Close()
_, err = index.Create(mockCtx, txn, values, 0)
c.Assert(err, IsNil)
_, err = index.SeekFirst(txn)
c.Assert(err, IsNil)
_, hit, err := index.Seek(sc, txn, values)
c.Assert(err, IsNil)
c.Assert(hit, IsTrue)
err = index.Drop(txn)
c.Assert(err, IsNil)
it, hit, err = index.Seek(sc, txn, values)
c.Assert(err, IsNil)
c.Assert(hit, IsFalse)
_, _, err = it.Next()
c.Assert(terror.ErrorEqual(err, io.EOF), IsTrue, Commentf("err %v", err))
it.Close()
it, err = index.SeekFirst(txn)
c.Assert(err, IsNil)
_, _, err = it.Next()
c.Assert(terror.ErrorEqual(err, io.EOF), IsTrue, Commentf("err %v", err))
it.Close()
err = txn.Commit(context.Background())
c.Assert(err, IsNil)
tblInfo = &model.TableInfo{
ID: 2,
Indices: []*model.IndexInfo{
{
ID: 3,
Name: model.NewCIStr("test"),
Unique: true,
Columns: []*model.IndexColumn{
{Offset: 0},
{Offset: 1},
},
},
},
Columns: []*model.ColumnInfo{
{ID: 1, Name: model.NewCIStr("c2"), State: model.StatePublic, Offset: 0, FieldType: *types.NewFieldType(mysql.TypeVarchar)},
{ID: 2, Name: model.NewCIStr("c2"), State: model.StatePublic, Offset: 1, FieldType: *types.NewFieldType(mysql.TypeString)},
},
}
index = tables.NewIndex(tblInfo.ID, tblInfo, tblInfo.Indices[0])
// Test uniq index.
txn, err = s.s.Begin()
c.Assert(err, IsNil)
_, err = index.Create(mockCtx, txn, values, 1)
c.Assert(err, IsNil)
_, err = index.Create(mockCtx, txn, values, 2)
c.Assert(err, NotNil)
it, err = index.SeekFirst(txn)
c.Assert(err, IsNil)
getValues, h, err = it.Next()
c.Assert(err, IsNil)
c.Assert(getValues, HasLen, 2)
c.Assert(getValues[0].GetInt64(), Equals, int64(1))
c.Assert(getValues[1].GetInt64(), Equals, int64(2))
c.Assert(h, Equals, int64(1))
it.Close()
exist, h, err = index.Exist(sc, txn, values, 1)
c.Assert(err, IsNil)
c.Assert(h, Equals, int64(1))
c.Assert(exist, IsTrue)
exist, h, err = index.Exist(sc, txn, values, 2)
c.Assert(err, NotNil)
c.Assert(h, Equals, int64(1))
c.Assert(exist, IsTrue)
err = txn.Commit(context.Background())
c.Assert(err, IsNil)
_, err = index.FetchValues(make([]types.Datum, 0), nil)
c.Assert(err, NotNil)
// Test the function of Next when the value of unique key is nil.
values2 := types.MakeDatums(nil, nil)
_, err = index.Create(mockCtx, txn, values2, 2)
c.Assert(err, IsNil)
it, err = index.SeekFirst(txn)
c.Assert(err, IsNil)
getValues, h, err = it.Next()
c.Assert(err, IsNil)
c.Assert(getValues, HasLen, 2)
c.Assert(getValues[0].GetInterface(), Equals, nil)
c.Assert(getValues[1].GetInterface(), Equals, nil)
c.Assert(h, Equals, int64(2))
it.Close()
}
func (s *testIndexSuite) TestCombineIndexSeek(c *C) {
tblInfo := &model.TableInfo{
ID: 1,
Indices: []*model.IndexInfo{
{
ID: 2,
Name: model.NewCIStr("test"),
Columns: []*model.IndexColumn{
{Offset: 1},
{Offset: 2},
},
},
},
Columns: []*model.ColumnInfo{
{Offset: 0},
{Offset: 1},
{Offset: 2},
},
}
index := tables.NewIndex(tblInfo.ID, tblInfo, tblInfo.Indices[0])
txn, err := s.s.Begin()
c.Assert(err, IsNil)
mockCtx := mock.NewContext()
values := types.MakeDatums("abc", "def")
_, err = index.Create(mockCtx, txn, values, 1)
c.Assert(err, IsNil)
index2 := tables.NewIndex(tblInfo.ID, tblInfo, tblInfo.Indices[0])
sc := &stmtctx.StatementContext{TimeZone: time.Local}
iter, hit, err := index2.Seek(sc, txn, types.MakeDatums("abc", nil))
c.Assert(err, IsNil)
defer iter.Close()
c.Assert(hit, IsFalse)
_, h, err := iter.Next()
c.Assert(err, IsNil)
c.Assert(h, Equals, int64(1))
}