create database if not exists SPDB;
use SPDB;
drop table if exists T1;
create table T1(a int not null,
             b int not null,
             primary key(a, b)) ENGINE=NDB partition by key (a);



insert into T1 values (0, 0+1);
insert into T1 values (1, 1+1);
insert into T1 values (2, 2+1);
insert into T1 values (3, 3+1);
insert into T1 values (4, 4+1);
insert into T1 values (5, 5+1);
insert into T1 values (6, 6+1);
insert into T1 values (7, 7+1);
insert into T1 values (8, 8+1);
insert into T1 values (9, 9+1);
insert into T1 values (10, 10+1);
insert into T1 values (11, 11+1);
insert into T1 values (12, 12+1);
insert into T1 values (13, 13+1);
insert into T1 values (14, 14+1);
insert into T1 values (15, 15+1);
insert into T1 values (16, 16+1);
insert into T1 values (17, 17+1);
insert into T1 values (18, 18+1);
insert into T1 values (19, 19+1);
insert into T1 values (20, 20+1);
insert into T1 values (21, 21+1);
insert into T1 values (22, 22+1);
insert into T1 values (23, 23+1);
insert into T1 values (24, 24+1);
insert into T1 values (25, 25+1);
insert into T1 values (26, 26+1);
insert into T1 values (27, 27+1);
insert into T1 values (28, 28+1);
insert into T1 values (29, 29+1);
insert into T1 values (30, 30+1);
insert into T1 values (31, 31+1);
insert into T1 values (32, 32+1);
insert into T1 values (33, 33+1);
insert into T1 values (34, 34+1);
insert into T1 values (35, 35+1);
insert into T1 values (36, 36+1);
insert into T1 values (37, 37+1);
insert into T1 values (38, 38+1);
insert into T1 values (39, 39+1);
insert into T1 values (40, 40+1);
insert into T1 values (41, 41+1);
insert into T1 values (42, 42+1);
insert into T1 values (43, 43+1);
insert into T1 values (44, 44+1);
insert into T1 values (45, 45+1);
insert into T1 values (46, 46+1);
insert into T1 values (47, 47+1);
insert into T1 values (48, 48+1);
insert into T1 values (49, 49+1);
insert into T1 values (50, 50+1);
insert into T1 values (51, 51+1);
insert into T1 values (52, 52+1);
insert into T1 values (53, 53+1);
insert into T1 values (54, 54+1);
insert into T1 values (55, 55+1);
insert into T1 values (56, 56+1);
insert into T1 values (57, 57+1);
insert into T1 values (58, 58+1);
insert into T1 values (59, 59+1);
insert into T1 values (60, 60+1);
insert into T1 values (61, 61+1);
insert into T1 values (62, 62+1);
insert into T1 values (63, 63+1);
insert into T1 values (64, 64+1);
insert into T1 values (65, 65+1);
insert into T1 values (66, 66+1);
insert into T1 values (67, 67+1);
insert into T1 values (68, 68+1);
insert into T1 values (69, 69+1);
insert into T1 values (70, 70+1);
insert into T1 values (71, 71+1);
insert into T1 values (72, 72+1);
insert into T1 values (73, 73+1);
insert into T1 values (74, 74+1);
insert into T1 values (75, 75+1);
insert into T1 values (76, 76+1);
insert into T1 values (77, 77+1);
insert into T1 values (78, 78+1);
insert into T1 values (79, 79+1);
insert into T1 values (80, 80+1);
insert into T1 values (81, 81+1);
insert into T1 values (82, 82+1);
insert into T1 values (83, 83+1);
insert into T1 values (84, 84+1);
insert into T1 values (85, 85+1);
insert into T1 values (86, 86+1);
insert into T1 values (87, 87+1);
insert into T1 values (88, 88+1);
insert into T1 values (89, 89+1);
insert into T1 values (90, 90+1);
insert into T1 values (91, 91+1);
insert into T1 values (92, 92+1);
insert into T1 values (93, 93+1);
insert into T1 values (94, 94+1);
insert into T1 values (95, 95+1);
insert into T1 values (96, 96+1);
insert into T1 values (97, 97+1);
insert into T1 values (98, 98+1);
insert into T1 values (99, 99+1);
insert into T1 values (100, 100+1);


select count(*) from T1 t1, T1 t2, T1 t3, T1 t4
where t1.b = t2.a and t3.b = t4.a;