--source include/have_ndb.inc

create table t1
 (pk int 
  ,a1 BIT(1), a2 BIT(5), a3 BIT(33), a4 BIT(63), a5 BIT(64)
  ,b1 TINYINT, b2 TINYINT UNSIGNED
  ,c1 SMALLINT, c2 SMALLINT UNSIGNED
  ,d1 INT, d2 INT UNSIGNED
  ,e1 BIGINT, e2 BIGINT UNSIGNED
  ,f1 CHAR(1) BINARY, f2 CHAR(32) BINARY, f3 CHAR(255) BINARY
  ,g1 VARCHAR(32) BINARY, g2 VARCHAR(255) BINARY, g3 VARCHAR(1000) BINARY
  ,h1 BINARY(1), h2 BINARY(8), h3 BINARY(255)
  ,i1 VARBINARY(32), i2 VARBINARY(255), i3 VARBINARY(1000)
 ) engine ndb;

insert into t1 values
 (1
  ,0x1, 0x17, 0x789a, 0x789abcde, 0xfedc0001
  ,127, 255
  ,32767, 65535
  ,2147483647, 4294967295
  ,9223372036854775807, 18446744073709551615
  ,'1','12345678901234567890123456789012','123456789'
  ,'1','12345678901234567890123456789012','123456789'
  ,0x12,0x123456789abcdef0, 0x012345
  ,0x12,0x123456789abcdef0, 0x00123450
 );

insert into t1 values
 (2
  ,0, 0, 0, 0, 0
  ,-128, 0
  ,-32768, 0
  ,-2147483648, 0
  ,-9223372036854775808, 0
  ,'','',''
  ,'','',''
  ,0x0,0x0,0x0
    ,0x0,0x0,0x0
 );

insert into t1 values
 (3
  ,NULL,NULL,NULL,NULL,NULL
  ,NULL,NULL
  ,NULL,NULL
  ,NULL,NULL
  ,NULL,NULL
  ,NULL,NULL,NULL
  ,NULL,NULL,NULL
  ,NULL,NULL,NULL
  ,NULL,NULL,NULL
 );

insert into t1 (pk,a1,b1,c1,d1,e1,f1,g1,h1,i1) select rand(), a1,b1,c1,d1,e1,f1,g1,h1,i1 from t1;
insert into t1 (pk,a1,b1,c1,d1,e1,f1,g1,h1,i1) select rand(), a1,b1,c1,d1,e1,f1,g1,h1,i1 from t1;
insert into t1 (pk,a1,b1,c1,d1,e1,f1,g1,h1,i1) select rand(), a1,b1,c1,d1,e1,f1,g1,h1,i1 from t1;
insert into t1 (pk,a1,b1,c1,d1,e1,f1,g1,h1,i1) select rand(), a1,b1,c1,d1,e1,f1,g1,h1,i1 from t1;
insert into t1 (pk,a1,b1,c1,d1,e1,f1,g1,h1,i1) select rand(), a1,b1,c1,d1,e1,f1,g1,h1,i1 from t1;
insert into t1 (pk,a1,b1,c1,d1,e1,f1,g1,h1,i1) select rand(), a1,b1,c1,d1,e1,f1,g1,h1,i1 from t1;
insert into t1 (pk,a1,b1,c1,d1,e1,f1,g1,h1,i1) select rand(), a1,b1,c1,d1,e1,f1,g1,h1,i1 from t1;
insert into t1 (pk,a1,b1,c1,d1,e1,f1,g1,h1,i1) select rand(), a1,b1,c1,d1,e1,f1,g1,h1,i1 from t1;
insert into t1 (pk,a1,b1,c1,d1,e1,f1,g1,h1,i1) select rand(), a1,b1,c1,d1,e1,f1,g1,h1,i1 from t1;
insert into t1 (pk,a1,b1,c1,d1,e1,f1,g1,h1,i1) select rand(), a1,b1,c1,d1,e1,f1,g1,h1,i1 from t1;
insert into t1 (pk,a1,b1,c1,d1,e1,f1,g1,h1,i1) select rand(), a1,b1,c1,d1,e1,f1,g1,h1,i1 from t1;
insert into t1 (pk,a1,b1,c1,d1,e1,f1,g1,h1,i1) select rand(), a1,b1,c1,d1,e1,f1,g1,h1,i1 from t1;
insert into t1 (pk,a1,b1,c1,d1,e1,f1,g1,h1,i1) select rand(), a1,b1,c1,d1,e1,f1,g1,h1,i1 from t1;
insert into t1 (pk,a1,b1,c1,d1,e1,f1,g1,h1,i1) select rand(), a1,b1,c1,d1,e1,f1,g1,h1,i1 from t1;

echo Start second backup;
select now();
--exec $NDB_MGM --no-defaults -e "start backup 33 nowait"
select now();
--system $NDB_MGM --no-defaults -e "abort backup 33"

sleep 10;

select count(*) from t1;

drop table t1;