-- source include/have_ndb.inc
-- source include/have_log_bin.inc

connect (server1,127.0.0.1,root,,test,$MYSQLD1_PORT,);
connect (server2,127.0.0.1,root,,test,$MYSQLD2_PORT,);

--echo Check that server2 is not writing binlog
connection server2;
-- source include/not_log_bin.inc
# Since this server is intentionally running without log-bin, supress warning
-- disable_query_log ONCE
call mtr.add_suppression("You need to use --log-bin to make --binlog-format work");

connection server1;

#
#  Bug #14845851 MYSQL CLUSTER - AUTO INCREMENT NOT RESET WHEN TRUNCATE NON-BINLOGGING SQL NODES
#
CREATE TABLE t1 (
  a bigint unsigned NOT NULL AUTO_INCREMENT PRIMARY KEY,
  b int unsigned not null,
  c int unsigned
) engine=ndbcluster;


--echo insert records into table on server1
let $1=500;
disable_query_log;
while ($1>250)
{
  eval insert into t1 values
    (NULL, $1+9, 5*$1),
    (NULL, $1+10, 7),
    (NULL, $1+10, 7*$1),
    (NULL, $1+10, 10+$1),
    (NULL, $1+10, 70*$1),
    (NULL, $1+10, 7),
    (NULL, $1+10, 9),
    (NULL, $1+299, 899),
    (NULL, $1+10, 12),
    (NULL, $1+10, 14*$1);
  dec $1;
}
enable_query_log;

--echo insert records into table on server2 to get cached auto_increment values
connection server2;
let $1=250;
disable_query_log;
while ($1)
{
  eval insert into t1 values
    (NULL, $1+9, 5*$1),
    (NULL, $1+10, 7),
    (NULL, $1+10, 7*$1),
    (NULL, $1+10, 10+$1),
    (NULL, $1+10, 70*$1),
    (NULL, $1+10, 7),
    (NULL, $1+10, 9),
    (NULL, $1+299, 899),
    (NULL, $1+10, 12),
    (NULL, $1+10, 14*$1);
  dec $1;
}
enable_query_log;

--echo Check that auto_increment values are correctly generated
connection server1;

select count(*) from t1;

select * from t1 order by a limit 2;

truncate table t1;

--echo Check that server2 has properly reset the cached auto_increment values
connection server2;

select count(*) from t1;

insert into t1 values(NULL,1,1),(NULL,2,2);

select * from t1 order by a;

drop table t1;