Skip to content

IndexLookUpExecutor got panic #40857

@wjhuang2016

Description

@wjhuang2016

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

CREATE TABLE `263b2d5c-986d-4458-864b-b6b2d89387e4` (
  `c67143a0-a8c8-471f-b1e0-f418cc6321eb` mediumint(9) DEFAULT '-4747160',
  `54e46aad-e21c-49ff-b28a-72defacde844` year(4) NOT NULL DEFAULT '2075',
  `e71c6ef8-68c4-4d76-b6aa-edcb278d5644` double DEFAULT '1.1559030660251948',
  `1308c586-a669-4d1c-b59d-14a324a15f6d` enum('wbv4','eli','d8ym','m3gsx','lz7td','o','d1k7l','y1x','xcxq','bj','n7') DEFAULT 'xcxq',
  `48ad39ce-e61b-4afb-a096-d555fc6de442` int(11) DEFAULT '255080866',
  `c62add10-e17f-4c8f-a3e1-220d4c972b87` tinyint(1) DEFAULT '1',
  PRIMARY KEY (`54e46aad-e21c-49ff-b28a-72defacde844`) /*T![clustered_index] CLUSTERED */,
  KEY `8876a554-c88c-4fa6-86a0-a49f475f00a2` (`54e46aad-e21c-49ff-b28a-72defacde844`),
  KEY `e2a4c927-c4fb-49bb-9740-0e202ba73ad7` (`54e46aad-e21c-49ff-b28a-72defacde844`),
  UNIQUE KEY `bf2aa2b8-247b-4742-9b73-a7c182068846` (`54e46aad-e21c-49ff-b28a-72defacde844`),
  UNIQUE KEY `66fa4367-79da-4cc3-8696-6640239a5abe` (`e71c6ef8-68c4-4d76-b6aa-edcb278d5644`),
  UNIQUE KEY `ce5b6a42-045d-48ba-9069-402dbe5c039a` (`54e46aad-e21c-49ff-b28a-72defacde844`,`e71c6ef8-68c4-4d76-b6aa-edcb278d5644`,`1308c586-a669-4d1c-b59d-14a324a15f6d`),
  KEY `4096b35b-98eb-43c0-916e-c7d93e5ae03d` (`54e46aad-e21c-49ff-b28a-72defacde844`,`1308c586-a669-4d1c-b59d-14a324a15f6d`,`e71c6ef8-68c4-4d76-b6aa-edcb278d5644`),
  KEY `b14587ce-407c-4d03-952d-e64ec2c40c7f` (`1308c586-a669-4d1c-b59d-14a324a15f6d`),
  KEY `b5eea074-f908-4fcc-bcf7-d0d6f17e95e5` (`54e46aad-e21c-49ff-b28a-72defacde844`,`e71c6ef8-68c4-4d76-b6aa-edcb278d5644`),
  KEY `c4d86d54-091c-4307-957b-b164c9652b7f` (`c62add10-e17f-4c8f-a3e1-220d4c972b87`,`1308c586-a669-4d1c-b59d-14a324a15f6d`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

insert into `263b2d5c-986d-4458-864b-b6b2d89387e4` values ( -4747160, 2075, 722.5719203870632, 'xcxq', 1576824797
, 1);

select   /*+ agg_to_cop() stream_agg() */  bit_or( `263b2d5c-986d-4458-864b-b6b2d89387e4`.`48ad39ce-e61b-4afb-a096-d555fc6de442` ) as r0 , group_concat(   `263b2d5c-986d-4458-864b-b6b2d89387e4`.`48ad39ce-e61b-4afb-a096-d555fc6de442`
order by `263b2d5c-986d-4458-864b-b6b2d89387e4`.`48ad39ce-e61b-4afb-a096-d555fc6de442` ) as r1 from `263b2d5c-986d-4458-864b-b6b2d89387e4` where not( `263b2d5c-986d-4458-864b-b6b2d89387e4`.`c67143a0-a8c8-471f-b1e0-f418cc6321eb` between -7862876 and -3976555 ) and `263b2d5c-986d-4458-864b-b6b2d89387e4`.`e71c6ef8-68c4-4d76-b6aa-edcb278d5644` in ( select `c62add10-e17f-4c8f-a3e1-220d4c972b87` from `263b2d5c-986d-4458-864b-b6b2d89387e4` where not( `263b2d5c-986d-4458-864b-b6b2d89387e4`.`c62add10-e17f-4c8f-a3e1-220d4c972b87` <> 1 ) and not( `263b2d5c-986d-4458-864b-b6b2d89387e4`.`e71c6ef8-68c4-4d76-b6aa-edcb278d5644` in ( 9263.749352636818 ) ) ) group by `263b2d5c-986d-4458-864b-b6b2d89387e4`.`c67143a0-a8c8-471f-b1e0-f418cc6321eb`;

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

No error

3. What did you see instead (Required)

recover="runtime error: index out of range [2] with length 1"] [stack="github.com/pingcap/tidb/executor.(*tableWorker).pickAndExecTask.func1\n\t/Users/bba/pc/tidb/executor/distsql.go:1041\nruntime.gopanic\n\t/Users/bba/.gvm/gos/go1.19/src/runtime/panic.go:884\nruntime.goPanicIndex\n\t/Users/bba/.gvm/gos/go1.19/src/runtime/panic.go:113\ngithub.com/pingcap/tidb/util/chunk.Row.IsNull\n\t/Users/bba/pc/tidb/util/chunk/row.go:218\ngithub.com/pingcap/tidb/util/chunk.Row.GetDatumWithBuffer\n\t/Users/bba/pc/tidb/util/chunk/row.go:150\ngithub.com/pingcap/tidb/util/chunk.Row.GetDatum\n\t/Users/bba/pc/tidb/util/chunk/row.go:133\ngithub.com/pingcap/tidb/executor.(*IndexLookUpExecutor).getHandle\n\t/Users/bba/pc/tidb/executor/distsql.go:1086\ngithub.com/pingcap/tidb/executor.(*tableWorker).executeTask\n\t/Users/bba/pc/tidb/executor/distsql.go:1345\ngithub.com/pingcap/tidb/executor.(*tableWorker).pickAndExecTask\n\t/Users/bba/pc/tidb/executor/distsql.go:1058\ngithub.com/pingcap/tidb/executor.(*IndexLookUpExecutor).startTableWorker.func1\n\t/Users/bba/pc/tidb/executor/distsql.go:691

4. What is your TiDB version? (Required)

master

Metadata

Metadata

Assignees

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions