CALL mtr.add_suppression("Incorrect information in file");
CREATE TABLE t1(a int primary key, b varchar(255), c int) engine=ndb;
select * from t1;
a	b	c
insert into t1 values (1, "row 1", 2);
select * from t1;
a	b	c
1	row 1	2
select * from t1;
a	b	c
1	row 1	2
select * from t1;
a	b	c
1	row 1	2
select * from t1;
ERROR HY000: Got error 4009 'Cluster Failure' from NDBCLUSTER
select * from t1;
ERROR HY000: Got error 4009 'Cluster Failure' from NDBCLUSTER
select a,b,c from t1;
a	b	c
1	row 1	2
select * from t1;
a	b	c
1	row 1	2
select * from t1;
a	b	c
1	row 1	2
insert into t1 values (2, "row 1", 37);
drop table t1;
create table t1(a int, b varchar(10), c date) engine=ndb;
CREATE TRIGGER trg1 BEFORE UPDATE ON t1 FOR EACH ROW BEGIN
SET new.c = '1901-01-01 01:01:01';
End //
insert into t1 values (1, "row 1", NULL),(2, "row 2", NULL);
select * from t1 order by a;
a	b	c
1	row 1	NULL
2	row 2	NULL
create table t2(a int, b varchar(10), c date) engine=myisam;
CREATE TRIGGER trg2 BEFORE UPDATE ON t2 FOR EACH ROW BEGIN
SET new.c = '1901-01-01 01:01:01';
End //
create table t1(a int, b varchar(10), c date) engine=ndb;
CREATE TRIGGER trg1 BEFORE UPDATE ON t1 FOR EACH ROW BEGIN
SET new.c = '1902-02-02 02:02:02';
End //
insert into t1 values (1, "row 1", NULL),(2, "row 2", NULL);
select * from t1 order by a;
a	b	c
1	row 1	NULL
2	row 2	NULL
create table t2(a int, b varchar(10), c date) engine=myisam;
ERROR 42S01: Table 't2' already exists
drop table t2;
create table t2(a int, b varchar(10), c date) engine=myisam;
CREATE TRIGGER trg2 BEFORE UPDATE ON t2 FOR EACH ROW BEGIN
SET new.c = '1901-01-01 01:01:01';
End //
drop table t1, t2;