Debian Codegraph @

mysql-test/suite/ndb/r/ndb_reconnect.result

raw
1 CALL mtr.add_suppression("Incorrect information in file");
2 CREATE TABLE t1(a int primary key, b varchar(255), c int) engine=ndb;
3 select * from t1;
4 a b c
5 insert into t1 values (1, "row 1", 2);
6 select * from t1;
7 a b c
8 1 row 1 2
9 select * from t1;
10 a b c
11 1 row 1 2
12 select * from t1;
13 a b c
14 1 row 1 2
15 Node 1: NOT_STARTED
16 Node 2: NOT_STARTED
17 select * from t1;
18 ERROR HY000: Got error 4009 'Cluster Failure' from NDBCLUSTER
19 select * from t1;
20 ERROR HY000: Got error 4009 'Cluster Failure' from NDBCLUSTER
21 Node 1: STARTED
22 Node 2: STARTED
23 select a,b,c from t1;
24 a b c
25 1 row 1 2
26 select * from t1;
27 a b c
28 1 row 1 2
29 select * from t1;
30 a b c
31 1 row 1 2
32 insert into t1 values (2, "row 1", 37);
33 drop table t1;
34 create table t1(a int, b varchar(10), c date) engine=ndb;
35 CREATE TRIGGER trg1 BEFORE UPDATE ON t1 FOR EACH ROW BEGIN
36 SET new.c = '1901-01-01 01:01:01';
37 End //
38 insert into t1 values (1, "row 1", NULL),(2, "row 2", NULL);
39 select * from t1 order by a;
40 a b c
41 1 row 1 NULL
42 2 row 2 NULL
43 create table t2(a int, b varchar(10), c date) engine=myisam;
44 CREATE TRIGGER trg2 BEFORE UPDATE ON t2 FOR EACH ROW BEGIN
45 SET new.c = '1901-01-01 01:01:01';
46 End //
47 Node 1: STARTED
48 Node 2: STARTED
49 create table t1(a int, b varchar(10), c date) engine=ndb;
50 CREATE TRIGGER trg1 BEFORE UPDATE ON t1 FOR EACH ROW BEGIN
51 SET new.c = '1902-02-02 02:02:02';
52 End //
53 insert into t1 values (1, "row 1", NULL),(2, "row 2", NULL);
54 select * from t1 order by a;
55 a b c
56 1 row 1 NULL
57 2 row 2 NULL
58 create table t2(a int, b varchar(10), c date) engine=myisam;
59 ERROR 42S01: Table 't2' already exists
60 drop table t2;
61 create table t2(a int, b varchar(10), c date) engine=myisam;
62 CREATE TRIGGER trg2 BEFORE UPDATE ON t2 FOR EACH ROW BEGIN
63 SET new.c = '1901-01-01 01:01:01';
64 End //
65 drop table t1, t2;