- Hardware parameters:
- OS type:
- Others:
CREATE TABLE `case4` (
`id` bigint NOT NULL,
`col1` tinyint DEFAULT NULL,
`col2` smallint DEFAULT NULL,
`col3` int DEFAULT NULL,
`col4` bigint DEFAULT NULL,
`col5` tinyint unsigned DEFAULT NULL,
`col6` smallint unsigned DEFAULT NULL,
`col7` int unsigned DEFAULT NULL,
`col8` bigint unsigned DEFAULT NULL,
`col9` float DEFAULT NULL,
`col10` double DEFAULT NULL,
`col11` varchar(255) DEFAULT NULL,
`col12` date DEFAULT NULL,
`col13` datetime DEFAULT NULL,
`col14` timestamp NULL DEFAULT NULL,
`col15` bool DEFAULT NULL,
`col16` decimal(16,6) DEFAULT NULL,
`col17` text DEFAULT NULL,
`col18` json DEFAULT NULL,
`col19` blob DEFAULT NULL,
`col20` binary(255) DEFAULT NULL,
`col21` varbinary(255) DEFAULT NULL,
`col22` vecf32(3) DEFAULT NULL,
`col23` vecf32(3) DEFAULT NULL,
`col24` vecf64(3) DEFAULT NULL,
`col25` vecf64(3) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `col4` (`col4`),
KEY `col3` (`col3`)
);
create table t1 like case4;
insert into case4 select result,1,2,result,result,5,6,7,8,9.1,10.1,"11 a STU as, MN?, "||result||" pqrst, time, only for test",'2024-11-12','2024-11-12 13:13:13','2024-11-12 14:14:14', false, 16.666666,"17 a GHI as, test, "||result||" a22, time, only for test","{\"k\":18}", 19, 20, 21,"[1,2,3]","[4,5,6]","[7,8,9]","[10,11,12]" from generate_series(1,200000) g;
insert into t1 select * from case4 limit 100000;
Is there an existing issue for the same bug?
Branch Name
main
Commit ID
60ce16d
Other Environment Information
Actual Behavior
insert select may hung
Expected Behavior
No response
Steps to Reproduce
Additional information
No response