1
DROP TABLE IF EXISTS t1;
2
DROP DATABASE IF EXISTS mysqltest;
3
CREATE DATABASE mysqltest;
4
**** Begin Duplicate Statement Testing ****
5
CREATE LOGFILE GROUP lg1
6
ADD UNDOFILE 'undofile.dat'
10
CREATE LOGFILE GROUP lg2
11
ADD UNDOFILE 'undofile2.dat'
15
ERROR HY000: Failed to create LOGFILE GROUP
18
Warning 1296 Got error 1514 'Currently there is a limit of one logfile group' from NDB
19
Error 1528 Failed to create LOGFILE GROUP
20
CREATE LOGFILE GROUP lg1
21
ADD UNDOFILE 'undofile.dat'
25
ERROR HY000: Failed to create LOGFILE GROUP
26
ALTER LOGFILE GROUP lg1
27
ADD UNDOFILE 'undofile02.dat'
28
INITIAL_SIZE 1M ENGINE NDB;
29
ALTER LOGFILE GROUP lg1
30
ADD UNDOFILE 'undofile02.dat'
31
INITIAL_SIZE 1M ENGINE=NDB;
32
ERROR HY000: Failed to alter: CREATE UNDOFILE
34
ADD DATAFILE 'datafile.dat'
39
ADD DATAFILE 'datafile.dat'
43
ERROR HY000: Failed to create TABLESPACE
45
ADD DATAFILE 'datafile2.dat'
49
ADD DATAFILE 'datafile2.dat'
52
ERROR HY000: Failed to alter: CREATE DATAFILE
53
CREATE TABLE mysqltest.t1
54
(pk1 INT NOT NULL PRIMARY KEY, b INT NOT NULL, c INT NOT NULL)
55
TABLESPACE ts1 STORAGE DISK
57
CREATE TABLE mysqltest.t1
58
(pk1 INT NOT NULL PRIMARY KEY, b INT NOT NULL, c INT NOT NULL)
59
TABLESPACE ts1 STORAGE DISK
61
ERROR 42S01: Table 't1' already exists
62
CREATE TABLE mysqltest.t1
63
(pk1 INT NOT NULL PRIMARY KEY, b INT NOT NULL, c INT NOT NULL)
65
ERROR 42S01: Table 't1' already exists
66
DROP TABLE mysqltest.t1;
68
DROP DATAFILE 'datafile2.dat'
71
DROP DATAFILE 'datafile2.dat'
73
ERROR HY000: Failed to alter: NO SUCH FILE
75
DROP DATAFILE 'datafile.dat'
78
DROP DATAFILE 'datafile.dat'
80
ERROR HY000: Failed to alter: NO SUCH FILE
85
ERROR HY000: Failed to drop TABLESPACE
86
DROP LOGFILE GROUP lg1
88
DROP LOGFILE GROUP lg1
90
ERROR HY000: Failed to drop LOGFILE GROUP
91
DROP DATABASE IF EXISTS mysqltest;
92
**** End Duplicate Statement Testing ****
94
**** Begin Statment CaSe Testing ****
95
creaTE LOgfilE GrOuP lg1
96
adD undoFILE 'undofile.dat'
100
altER LOgFiLE GrOUp lg1
101
AdD UnDOfILe 'uNdOfiLe02.daT'
102
INItIAl_SIzE 1M ENgINE nDB;
103
CrEAtE TABLEspaCE ts1
104
ADD DATAfilE 'datafile.dat'
105
UsE LoGFiLE GRoUP lg1
109
AdD DaTaFiLe 'dAtAfiLe2.daT'
113
(pk1 int not null primary key, b int not null, c int not null)
114
TABLEspace ts1 storAGE dISk
118
droP DATAfile 'dAtAfiLe2.daT'
121
dROp dAtAfIlE 'datafile.dat'
125
DrOp lOgFiLe GrOuP lg1
127
**** End Statment CaSe Testing ****
129
**** Begin = And No = Testing ****
130
CREATE LOGFILE GROUP lg1
131
ADD UNDOFILE 'undofile.dat'
135
ALTER LOGFILE GROUP lg1
136
ADD UNDOFILE 'undofile02.dat'
139
CREATE TABLESPACE ts1
140
ADD DATAFILE 'datafile.dat'
141
USE LOGFILE GROUP lg1
145
ADD DATAFILE 'datafile2.dat'
149
(pk1 INT NOT NULL PRIMARY KEY, b INT NOT NULL, c INT NOT NULL)
150
TABLESPACE ts1 STORAGE DISK
154
DROP DATAFILE 'datafile2.dat'
157
DROP DATAFILE 'datafile.dat'
161
DROP LOGFILE GROUP lg1
166
CREATE LOGFILE GROUP lg1
167
ADD UNDOFILE 'undofile.dat'
171
ALTER LOGFILE GROUP lg1
172
ADD UNDOFILE 'undofile02.dat'
175
CREATE TABLESPACE ts1
176
ADD DATAFILE 'datafile.dat'
177
USE LOGFILE GROUP lg1
181
ADD DATAFILE 'datafile2.dat'
185
(pk1 INT NOT NULL PRIMARY KEY, b INT NOT NULL, c INT NOT NULL)
186
TABLESPACE ts1 STORAGE MEMORY
188
ALTER TABLE t1 STORAGE DISK;
189
CREATE INDEX b_i on t1(b);
190
CREATE INDEX bc_i on t1(b, c);
192
CREATE TABLESPACE ts2
193
ADD DATAFILE 'datafile3.dat'
194
USE LOGFILE GROUP lg1
198
DROP DATAFILE 'datafile3.dat'
200
ERROR HY000: Failed to alter: NO SUCH FILE
202
DROP DATAFILE 'datafile2.dat'
204
ERROR HY000: Failed to alter: NO SUCH FILE
206
DROP DATAFILE 'datafile2.dat'
209
DROP DATAFILE 'datafile.dat'
214
DROP DATAFILE 'datafile3.dat'
218
DROP LOGFILE GROUP lg1
220
**** End = And No = ****
221
create logfile group lg1 add undofile 'MYSQLTEST_VARDIR/tmp/t1.frm' initial_size 1M undo_buffer_size = 1M engine=ndb;;
222
ERROR HY000: Failed to create UNDOFILE
223
create logfile group lg1
224
add undofile 'undofile.dat'
226
undo_buffer_size = 1M
228
create tablespace ts1 add datafile 'MYSQLTEST_VARDIR/tmp/t1.frm' use logfile group lg1 initial_size 1M engine ndb;;
229
ERROR HY000: Failed to create DATAFILE
232
ERROR HY000: Failed to drop TABLESPACE
233
drop logfile group lg1