--source include/have_ndb.inc
##############
# Bug#19390895  CRASH: DBSPJ (LINE: 1299); SIMULATEDBLOCK.CPP
#   
#  SCAN_FRAGREQ signal larger than MAX_SEND_MESSAGE_BYTESIZE (32k)
#  SPJ failed to use fragmented send of large signals.

create table t1 (
  a int,
  b int not null,
  c1 char(255) CHARSET latin1,
  c2 char(255) CHARSET latin1,
  key k1(b, c1, c2)
)
engine = ndb
comment="NDB_TABLE=PARTITION_BALANCE=FOR_RP_BY_LDM";

insert into t1(a,b,c1,c2) values
(0, 0, 0, 0),
(1, 1, 1, 1),
(2, 2, 2, 1),
(3, 3, 3, 3),
(4, 4, 4, 4),
(5, 5, 5, 5),
(6, 6, 6, 6),
(7, 7, 7, 7),
(8, 8, 8, 8),
(9, 9, 9, 9);

insert into t1 select a + 10,  b, c1, c2 from t1;
insert into t1 select a + 20,  b, c1, c2 from t1;
insert into t1 select a + 40,  b, c1, c2 from t1;
insert into t1 select a + 80,  b, c1, c2 from t1;
insert into t1 select a + 160, b, c1, c2 from t1;
insert into t1 select a + 320, b, c1, c2 from t1;
insert into t1 select a + 640, b, c1, c2 from t1;
insert into t1 select a + 1280, b, c1, c2 from t1;

explain
select * from t1 as x, t1 as y
 where y.b = x.a and y.c1 = x.c1 and y.c2 = x.c1;

select count(*) from t1 as x, t1 as y
 where y.b = x.a and y.c1 = x.c1 and y.c2 = x.c1;

drop table t1;