Debian Codegraph @

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

raw
1 #
2 # 18075170 - sql node restart required to avoid deadlock after
3 # restore
4 #
5 CREATE TABLE t1 (id INT) ENGINE=NDBCluster;
6 CREATE TABLE t2 (id INT) ENGINE=NDBCluster;
7 INSERT INTO t1 VALUES (1);
8 INSERT INTO t2 VALUES (1);
9 DROP TABLE t1;
10 DROP TABLE t2;
11 SET autocommit = 0;
12 SELECT * FROM t1;
13 id
14 1
15 SELECT * FROM t2;
16 ERROR HY000: Table definition has changed, please retry transaction
17 ROLLBACK;
18 SET autocommit = 1;
19 drop table t1;
20 drop table t2;
21 SET autocommit = 0;
22 SELECT * FROM t1;
23 id
24 1
25 SELECT * FROM t2;
26 ERROR HY000: Table definition has changed, please retry transaction
27 ALTER TABLE t1 ADD val INT;
28 ROLLBACK;
29 SET autocommit = 1;
30 drop table t1;
31 drop table t2;