-
Notifications
You must be signed in to change notification settings - Fork 6.1k
Closed
Labels
affects-6.1This bug affects the 6.1.x(LTS) versions.This bug affects the 6.1.x(LTS) versions.affects-6.5This bug affects the 6.5.x(LTS) versions.This bug affects the 6.5.x(LTS) versions.affects-6.6fuzz/schrddlseverity/majorsig/sql-infraSIG: SQL InfraSIG: SQL Infratype/bugThe issue is confirmed as a bug.The issue is confirmed as a bug.
Description
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:6914. What is your TiDB version? (Required)
master
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
affects-6.1This bug affects the 6.1.x(LTS) versions.This bug affects the 6.1.x(LTS) versions.affects-6.5This bug affects the 6.5.x(LTS) versions.This bug affects the 6.5.x(LTS) versions.affects-6.6fuzz/schrddlseverity/majorsig/sql-infraSIG: SQL InfraSIG: SQL Infratype/bugThe issue is confirmed as a bug.The issue is confirmed as a bug.