[MDEV-20977] spider would crash when using lock table write Created: 2019-11-05  Updated: 2020-07-06  Resolved: 2020-07-06

Status: Closed
Project: MariaDB Server
Component/s: Storage Engine - Spider
Affects Version/s: 10.4.3
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: willhan Assignee: Kentoku Shiba (Inactive)
Resolution: Cannot Reproduce Votes: 0
Labels: need_feedback


 Description   

test suite:

create table t1 (id int NOT NULL,id2 int NOT NULL,id3 int NOT NULL,dummy1 char(30),primary key (id,id2),index index_id3 (id3)) engine=innodb;
 
insert into t1 values (0,0,0,'ABCDEFGHIJ'),(2,2,2,'BCDEFGHIJK'),(1,1,1,'CDEFGHIJKL');
 
LOCK TABLES t1 WRITE;
 
insert into t1 values (99,1,2,'D'),(1,1,2,'D');
 
select id from t1;



 Comments   
Comment by Kentoku Shiba (Inactive) [ 2019-11-12 ]

willhan I didn't reproduce this issue.
Please see the following test of the commit.
0f64ee1

Generated at Thu Feb 08 09:03:40 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.