-- source include/have_ndb.inc

create table t1(
  a int primary key
) engine=ndbcluster;

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

--echo
--echo # expected result 0 roundtrips - read stats from share
--source suite/ndb/include/ndb_init_execute_count.inc
explain extended select * from t1 where a < 100;
--source suite/ndb/include/ndb_execute_count.inc

insert into t1 select a+100 from t1;

--echo
--echo # expected result 0 roundtrips - read stats from share
--source suite/ndb/include/ndb_init_execute_count.inc
explain extended select * from t1 where a < 100;
--source suite/ndb/include/ndb_execute_count.inc

delete from t1 where a >= 100;

--echo
--echo # expected result 0 roundtrips - read stats from share
--source suite/ndb/include/ndb_init_execute_count.inc
explain extended select * from t1 where a < 100;
--source suite/ndb/include/ndb_execute_count.inc

begin;
insert into t1 select a+100 from t1;
commit;

--echo
--echo # expected result 0 roundtrips - read stats from share
--source suite/ndb/include/ndb_init_execute_count.inc
explain extended select * from t1 where a < 100;
--source suite/ndb/include/ndb_execute_count.inc

begin;
delete from t1 where a >= 100;
commit;

--echo
--echo # expected result 0 roundtrips - read stats from share
--source suite/ndb/include/ndb_init_execute_count.inc
explain extended select * from t1 where a < 100;
--source suite/ndb/include/ndb_execute_count.inc

begin;
insert into t1 select a+100 from t1;
rollback;

--echo
--echo # expected result 0 roundtrips - read stats from share
--source suite/ndb/include/ndb_init_execute_count.inc
explain extended select * from t1 where a < 100;
--source suite/ndb/include/ndb_execute_count.inc

begin;
delete from t1 where a <= 100;
rollback;

--echo
--echo # expected result 0 roundtrips - read stats from share
--source suite/ndb/include/ndb_init_execute_count.inc
explain extended select * from t1 where a < 100;
--source suite/ndb/include/ndb_execute_count.inc

--error ER_DUP_KEY
insert into t1 select a from t1;

--echo
--echo # expected result 0 roundtrips - read stats from share
--source suite/ndb/include/ndb_init_execute_count.inc
explain extended select * from t1 where a < 100;
--source suite/ndb/include/ndb_execute_count.inc

begin;
--error ER_DUP_KEY
insert into t1 select a from t1;

--echo
--echo # expected result 0 roundtrips - read stats from share
--source suite/ndb/include/ndb_init_execute_count.inc
explain extended select * from t1 where a < 100;
--source suite/ndb/include/ndb_execute_count.inc

drop table t1;
