1
drop table if exists t1,t2;
2
create table t1 (a int key, b int unique, c int) engine ndb;
3
ERROR HY000: Can't create table 'test.t1' (errno: 299)
4
CREATE LOGFILE GROUP lg1
5
ADD UNDOFILE 'undofile.dat'
9
ERROR HY000: Failed to create LOGFILE GROUP
12
Error 1296 Got error 299 'Operation not allowed or aborted due to single user mode' from NDB
13
Error 1528 Failed to create LOGFILE GROUP
14
create table t1 (a int key, b int unique, c int) engine ndb;
15
CREATE LOGFILE GROUP lg1
16
ADD UNDOFILE 'undofile.dat'
21
ADD DATAFILE 'datafile.dat'
25
ERROR HY000: Failed to create TABLESPACE
28
Error 1296 Got error 299 'Operation not allowed or aborted due to single user mode' from NDB
29
Error 1528 Failed to create TABLESPACE
30
DROP LOGFILE GROUP lg1
32
ERROR HY000: Failed to drop LOGFILE GROUP
35
Error 1296 Got error 299 'Operation not allowed or aborted due to single user mode' from NDB
36
Error 1529 Failed to drop LOGFILE GROUP
38
ADD DATAFILE 'datafile.dat'
43
DROP DATAFILE 'datafile.dat'
45
ERROR HY000: Failed to alter: DROP DATAFILE
48
Error 1296 Got error 299 'Operation not allowed or aborted due to single user mode' from NDB
49
Error 1533 Failed to alter: DROP DATAFILE
51
DROP DATAFILE 'datafile.dat'
55
ERROR HY000: Failed to drop TABLESPACE
58
Error 1296 Got error 299 'Operation not allowed or aborted due to single user mode' from NDB
59
Error 1529 Failed to drop TABLESPACE
62
DROP LOGFILE GROUP lg1
64
insert into t1 values (1,1,0),(2,2,0),(3,3,0),(4,4,0),(5,5,0),(6,6,0),(7,7,0),(8,8,0),(9,9,0),(10,10,0);
65
create table t2 as select * from t1;
66
select * from t1 where a = 1;
69
select * from t1 where b = 4;
72
select * from t1 where a > 4 order by a;
80
update t1 set b=102 where a = 2;
81
update t1 set b=103 where b = 3;
82
update t1 set b=b+100;
83
update t1 set b=b+100 where a > 7;
85
insert into t1 select * from t2;
86
create unique index new_index on t1 (b,c);
89
ERROR 42S02: Unknown table 't1'
90
create index new_index_fail on t1 (c);
91
ERROR HY000: Got error 299 'Operation not allowed or aborted due to single user mode' from NDBCLUSTER
92
insert into t1 values (21,21,0),(22,22,0),(23,23,0),(24,24,0),(25,25,0),(26,26,0),(27,27,0),(28,28,0),(29,29,0),(210,210,0);
93
ERROR HY000: Got error 299 'Operation not allowed or aborted due to single user mode' from NDBCLUSTER
94
select * from t1 where a = 1;
95
ERROR HY000: Got error 299 'Operation not allowed or aborted due to single user mode' from NDBCLUSTER
96
select * from t1 where b = 4;
97
ERROR HY000: Got error 299 'Operation not allowed or aborted due to single user mode' from NDBCLUSTER
98
update t1 set b=102 where a = 2;
99
ERROR HY000: Got error 299 'Operation not allowed or aborted due to single user mode' from NDBCLUSTER
100
update t1 set b=103 where b = 3;
101
ERROR HY000: Got error 299 'Operation not allowed or aborted due to single user mode' from NDBCLUSTER
102
update t1 set b=b+100;
103
ERROR HY000: Got error 299 'Operation not allowed or aborted due to single user mode' from NDBCLUSTER
104
update t1 set b=b+100 where a > 7;
105
ERROR HY000: Got error 299 'Operation not allowed or aborted due to single user mode' from NDBCLUSTER
107
update t1 set b=b+100 where a=1;
109
update t1 set b=b+100 where a=2;
110
update t1 set b=b+100 where a=3;
112
update t1 set b=b+100 where a=4;
113
ERROR HY000: Got error 299 'Operation not allowed or aborted due to single user mode' from NDBCLUSTER
115
ERROR HY000: Got error 4350 'Transaction already aborted' from NDBCLUSTER
116
create table t2 (a int) engine myisam;
117
alter table t2 add column (b int);