SET @start_global_value = @@global.xengine_parallel_read_threads;
SELECT @start_global_value;
@start_global_value
4
create table t1(id int, a char(20),  b text, primary key(id), key k1(a(8)), unique key k2(b(8))) engine=xengine;
create table t2(id int, a char(20),  b text, primary key(id), key k1(b(8)), unique key k2(a(8))) engine=xengine;
create table t3(id int, a char(20),  b text, primary key(a(8)), key k1(id), unique key k2(b(8))) engine=xengine;
create table t4(id int, a char(20),  b text, primary key(a(8)), key k1(b(8)), unique key k2(id)) engine=xengine;
create table t5(id int, a char(20),  b text, primary key(b(8)), key k1(id), unique key k2(a(8))) engine=xengine;
create table t6(id int, a char(20),  b text, primary key(b(8)), key k1(a(8)), unique key k2(id)) engine=xengine;
create table t7(id int, a char(20),  b text, primary key(id, a(8)), key k1(b(8))) engine=xengine;
create table t8(id int, a char(20),  b text, primary key(id), key k1(a(8), b(8))) engine=xengine;
create table t9(id int, a char(20),  b text, primary key(id), unique key k2(a(8), b(8))) engine=xengine;
begin;
insert into t1 values(1, '1234567890', '0987654321');
insert into t1 values(2, '0987654321', '1234567890');
check table t1;
Table	Op	Msg_type	Msg_text
test.t1	check	status	OK
set xengine_parallel_read_threads=2;
check table t1;
Table	Op	Msg_type	Msg_text
test.t1	check	status	OK
set xengine_parallel_read_threads=8;
check table t1;
Table	Op	Msg_type	Msg_text
test.t1	check	status	OK
drop table t1;
insert into t2 values(1, '1234567890', '0987654321');
insert into t2 values(2, '0987654321', '1234567890');
check table t2;
Table	Op	Msg_type	Msg_text
test.t2	check	status	OK
set xengine_parallel_read_threads=2;
check table t2;
Table	Op	Msg_type	Msg_text
test.t2	check	status	OK
set xengine_parallel_read_threads=8;
check table t2;
Table	Op	Msg_type	Msg_text
test.t2	check	status	OK
drop table t2;
insert into t3 values(1, '1234567890', '0987654321');
insert into t3 values(2, '0987654321', '1234567890');
check table t3;
Table	Op	Msg_type	Msg_text
test.t3	check	status	OK
set xengine_parallel_read_threads=2;
check table t3;
Table	Op	Msg_type	Msg_text
test.t3	check	status	OK
set xengine_parallel_read_threads=8;
check table t3;
Table	Op	Msg_type	Msg_text
test.t3	check	status	OK
drop table t3;
insert into t4 values(1, '1234567890', '0987654321');
insert into t4 values(2, '0987654321', '1234567890');
check table t4;
Table	Op	Msg_type	Msg_text
test.t4	check	status	OK
set xengine_parallel_read_threads=2;
check table t4;
Table	Op	Msg_type	Msg_text
test.t4	check	status	OK
set xengine_parallel_read_threads=8;
check table t4;
Table	Op	Msg_type	Msg_text
test.t4	check	status	OK
drop table t4;
insert into t5 values(1, '1234567890', '0987654321');
insert into t5 values(2, '0987654321', '1234567890');
check table t5;
Table	Op	Msg_type	Msg_text
test.t5	check	status	OK
set xengine_parallel_read_threads=2;
check table t5;
Table	Op	Msg_type	Msg_text
test.t5	check	status	OK
set xengine_parallel_read_threads=8;
check table t5;
Table	Op	Msg_type	Msg_text
test.t5	check	status	OK
drop table t5;
insert into t6 values(1, '1234567890', '0987654321');
insert into t6 values(2, '0987654321', '1234567890');
check table t6;
Table	Op	Msg_type	Msg_text
test.t6	check	status	OK
set xengine_parallel_read_threads=2;
check table t6;
Table	Op	Msg_type	Msg_text
test.t6	check	status	OK
set xengine_parallel_read_threads=8;
check table t6;
Table	Op	Msg_type	Msg_text
test.t6	check	status	OK
drop table t6;
insert into t7 values(1, '1234567890', '0987654321');
insert into t7 values(2, '0987654321', '1234567890');
check table t7;
Table	Op	Msg_type	Msg_text
test.t7	check	status	OK
set xengine_parallel_read_threads=2;
check table t7;
Table	Op	Msg_type	Msg_text
test.t7	check	status	OK
set xengine_parallel_read_threads=8;
check table t7;
Table	Op	Msg_type	Msg_text
test.t7	check	status	OK
drop table t7;
insert into t8 values(1, '1234567890', '0987654321');
insert into t8 values(2, '0987654321', '1234567890');
check table t8;
Table	Op	Msg_type	Msg_text
test.t8	check	status	OK
set xengine_parallel_read_threads=2;
check table t8;
Table	Op	Msg_type	Msg_text
test.t8	check	status	OK
set xengine_parallel_read_threads=8;
check table t8;
Table	Op	Msg_type	Msg_text
test.t8	check	status	OK
drop table t8;
insert into t9 values(1, '1234567890', '0987654321');
insert into t9 values(2, '0987654321', '1234567890');
check table t9;
Table	Op	Msg_type	Msg_text
test.t9	check	status	OK
set xengine_parallel_read_threads=2;
check table t9;
Table	Op	Msg_type	Msg_text
test.t9	check	status	OK
set xengine_parallel_read_threads=8;
check table t9;
Table	Op	Msg_type	Msg_text
test.t9	check	status	OK
drop table t9;
commit;
create table t10 (a int, b int, key ka(a), key kb(b)) engine=xengine;
insert into t10 values(1, 5);
insert into t10 values(2, 6);
check table t10;
Table	Op	Msg_type	Msg_text
test.t10	check	status	OK
drop table t10;
SET @@global.xengine_parallel_read_threads = @start_global_value;
SELECT @@global.xengine_parallel_read_threads;
@@global.xengine_parallel_read_threads
4