34 lines
540 B
Plaintext
34 lines
540 B
Plaintext
#
|
|
# 18075170 - sql node restart required to avoid deadlock after
|
|
# restore
|
|
#
|
|
CREATE TABLE t1 (id INT) ENGINE=NDBCluster;
|
|
CREATE TABLE t2 (id INT) ENGINE=NDBCluster;
|
|
INSERT INTO t1 VALUES (1);
|
|
INSERT INTO t2 VALUES (1);
|
|
DROP TABLE t1;
|
|
DROP TABLE t2;
|
|
SET autocommit = 0;
|
|
SELECT * FROM t1;
|
|
id
|
|
1
|
|
SELECT * FROM t2;
|
|
id
|
|
1
|
|
ROLLBACK;
|
|
SET autocommit = 1;
|
|
drop table t1;
|
|
drop table t2;
|
|
SET autocommit = 0;
|
|
SELECT * FROM t1;
|
|
id
|
|
1
|
|
SELECT * FROM t2;
|
|
id
|
|
1
|
|
ALTER TABLE t1 ADD val INT;
|
|
ROLLBACK;
|
|
SET autocommit = 1;
|
|
drop table t1;
|
|
drop table t2;
|