60 lines
1.6 KiB
Plaintext
60 lines
1.6 KiB
Plaintext
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;
|