Skip to content

Index column offset out of bound #40192

@wjhuang2016

Description

@wjhuang2016

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

	store, dom := testkit.CreateMockStoreAndDomainWithSchemaLease(t, dbTestLease)

	tk := testkit.NewTestKit(t, store)
	tk2 := testkit.NewTestKit(t, store)
	tk.MustExec("use test")
	tk2.MustExec("use test")
	tk.MustExec("CREATE TABLE t (  `b7b8a741-2759-4111-a78c-66f85cad4b59` bigint(20) DEFAULT '-5604021856061349662',   `5183ba5d-7305-4e49-8859-9b0e3ca99393` float DEFAULT '1.5656552',  UNIQUE KEY `b668df57-0687-4b20-a829-790ebd5cc2bf` (`b7b8a741-2759-4111-a78c-66f85cad4b59`),  KEY `5d3a3c82-ede6-4583-8f83-28f3a8cb8777` (`b7b8a741-2759-4111-a78c-66f85cad4b59`),  KEY `23501b4f-3274-4d3f-8305-f355d4949ae6` (`b7b8a741-2759-4111-a78c-66f85cad4b59`),  KEY `4ad74ca0-1470-44e7-94bd-772dcad6fa5f` (`b7b8a741-2759-4111-a78c-66f85cad4b59`))")

	hook := &ddl.TestDDLCallback{Do: dom}
	var checkErr1, checkErr2 error
	hook.OnJobRunBeforeExported = func(job *model.Job) {
		if job.SchemaState != model.StateWriteOnly {
			return
		}
		_, checkErr1 = tk2.Exec("insert ignore into t values (1)")
		if checkErr1 != nil && strings.Contains(checkErr1.Error(), "Index column") {
			checkErr2 = checkErr1
		}
	}
	dom.DDL().SetHook(hook)
	tk.MustExec("alter table t drop column `b7b8a741-2759-4111-a78c-66f85cad4b59`")
	require.NoError(t, checkErr2)

2. What did you expect to see? (Required)

Pass

3. What did you see instead (Required)

Index column b7b8a741-2759-4111-a78c-66f85cad4b59 offset out of bound, offset: 1, row: [KindFloat32 1]

4. What is your TiDB version? (Required)

master

Metadata

Metadata

Assignees

Labels

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions