BUG #13511949 "NDB_RESTORE --PRINT-LOG DOES NOT PRODUCE VALID SQL" create table t1 (id1 int unsigned not null, id2 int unsigned not null, id3 char(10), id4 varchar(10), id5 binary(10), id6 varbinary(10), id7 datetime, id8 date, id9 time, primary key(id1,id2) )engine=ndbcluster; create table t2 (id1 int primary key )engine=ndbcluster; "Logged queries:" insert into t1 values(1,1,'abc','def','ghi','jkl','2016-05-25 12:42:45','2016-05-25','12:42:45'); update t1 set id5='def' where id1<2 and id2=1; update t1 set id3='mno' where id1=1 and id2>0; delete from t1 where id1 is not null and id4 like 'd%'; drop table t2; "Restore with --print-sql-log option" INSERT INTO test.t1 VALUES(1,1,'abc','def','ghi','jkl','2016-05-25/12:42:45','2016-05-25','12:42:45'); UPDATE test.t1 SET id5='def' WHERE id1=1 AND id2=1; UPDATE test.t1 SET id3='mno' WHERE id1=1 AND id2=1; DELETE FROM test.t1 WHERE id1=1 AND id2=1; drop table t1; drop table if exists t2; "No primary key declared" create table t3 (id1 int, id2 int )engine=ndbcluster; create table t4 (id1 int primary key )engine=ndbcluster; "Logged queries:" insert into t3 values(1,2); insert into t3 values(2,3); update t3 set id2=5 where id1=1; delete from t3; drop table t4; "Restore with --print-sql-log option" XXXX-XX-XX XX:XX:XX Found hidden primary key with print-sql-log option set. Exiting... drop table t3; drop table if exists t4; create table t5 (id1 int primary key, id2 int )engine=ndbcluster; create table t6 (id1 int primary key )engine=ndbcluster; "Logged queries:" insert into t5 values(1000,2000); update t5 set id2=5000 where id1=1000; delete from t5; drop table t6; "Restore with --print-sql-log and --print-log options" XXXX-XX-XX XX:XX:XX Both print-sql-log and print-log options passed. Exiting... drop table t5; drop table if exists t6; "Table contains column of type blob" create table t7 (id1 int primary key, id2 blob )engine=ndbcluster; create table t8 (id1 int primary key )engine=ndbcluster; "Logged queries:" insert into t7 values(1,'a'); drop table t8; "Restore with --print-sql-log option" XXXX-XX-XX XX:XX:XX Found column of type blob with print-sql-log option set. Exiting... drop table t7; drop table if exists t8;