Debian Codegraph @

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

raw
1 CREATE DATABASE mysqltest;
2 **** Begin Duplicate Statement Testing ****
3 CREATE LOGFILE GROUP lg1
4 ADD UNDOFILE 'undofile.dat'
5 INITIAL_SIZE 1M
6 UNDO_BUFFER_SIZE = 1M
7 ENGINE=NDB;
8 CREATE LOGFILE GROUP lg2
9 ADD UNDOFILE 'undofile2.dat'
10 INITIAL_SIZE 1M
11 UNDO_BUFFER_SIZE 1M
12 ENGINE NDB;
13 ERROR HY000: Failed to create LOGFILE GROUP
14 SHOW WARNINGS;
15 Level Code Message
16 Warning 1296 Got error 1514 'Currently there is a limit of one logfile group' from NDB
17 Warning 1296 Failed to commit NDB schema transaction
18 Error 1528 Failed to create LOGFILE GROUP
19 CREATE LOGFILE GROUP lg1
20 ADD UNDOFILE 'undofile.dat'
21 INITIAL_SIZE 1M
22 UNDO_BUFFER_SIZE = 1M
23 ENGINE=NDB;
24 ERROR HY000: Failed to create LOGFILE GROUP
25 SHOW WARNINGS;
26 Level Code Message
27 Warning 1296 Got error 721 'Schema object with given name already exists' from NDB
28 Warning 1296 Failed to create logfile group 'lg1' in NDB
29 Error 1528 Failed to create LOGFILE GROUP
30 ALTER LOGFILE GROUP lg1
31 ADD UNDOFILE 'undofile02.dat'
32 INITIAL_SIZE 1M ENGINE NDB;
33 ALTER LOGFILE GROUP lg1
34 ADD UNDOFILE 'undofile02.dat'
35 INITIAL_SIZE 1M ENGINE=NDB;
36 ERROR HY000: Failed to alter: CREATE UNDOFILE FAILED
37 SHOW WARNINGS;
38 Level Code Message
39 Warning 1296 Got error 760 'File already exists' from NDB
40 Warning 1296 Failed to create undofile 'undofile02.dat' in NDB
41 Error 1533 Failed to alter: CREATE UNDOFILE FAILED
42 CREATE TABLESPACE ts1
43 ADD DATAFILE 'datafile.dat'
44 USE LOGFILE GROUP lg1
45 INITIAL_SIZE 1M
46 ENGINE NDB;
47 CREATE TABLESPACE ts1
48 ADD DATAFILE 'datafile.dat'
49 USE LOGFILE GROUP lg1
50 INITIAL_SIZE 1M
51 ENGINE NDB;
52 ERROR HY000: Tablespace 'ts1' exists.
53 ALTER TABLESPACE ts1
54 ADD DATAFILE 'datafile2.dat'
55 INITIAL_SIZE 1M;
56 ALTER TABLESPACE ts1
57 ADD DATAFILE 'datafile2.dat'
58 INITIAL_SIZE 1M;
59 ERROR HY000: Failed to alter: CREATE DATAFILE FAILED
60 SHOW WARNINGS;
61 Level Code Message
62 Warning 1296 Got error 760 'File already exists' from NDB
63 Warning 1296 Failed to create datafile 'datafile2.dat' in NDB
64 Error 1533 Failed to alter: CREATE DATAFILE FAILED
65 CREATE TABLE mysqltest.t1
66 (pk1 INT NOT NULL PRIMARY KEY, b INT NOT NULL, c INT NOT NULL)
67 TABLESPACE ts1 STORAGE DISK
68 ENGINE=NDB;
69 CREATE TABLE mysqltest.t1
70 (pk1 INT NOT NULL PRIMARY KEY, b INT NOT NULL, c INT NOT NULL)
71 TABLESPACE ts1 STORAGE DISK
72 ENGINE=NDB;
73 ERROR 42S01: Table 't1' already exists
74 CREATE TABLE mysqltest.t1
75 (pk1 INT NOT NULL PRIMARY KEY, b INT NOT NULL, c INT NOT NULL)
76 ENGINE=NDB;
77 ERROR 42S01: Table 't1' already exists
78 DROP TABLE mysqltest.t1;
79 ALTER TABLESPACE ts1
80 DROP DATAFILE 'datafile2.dat';
81 ALTER TABLESPACE ts1
82 DROP DATAFILE 'datafile2.dat';
83 ERROR HY000: Tablespace 'ts1' does not have a file named 'datafile2.dat'
84 ALTER TABLESPACE ts1
85 DROP DATAFILE 'datafile.dat';
86 ALTER TABLESPACE ts1
87 DROP DATAFILE 'datafile.dat';
88 ERROR HY000: Tablespace 'ts1' does not have a file named 'datafile.dat'
89 DROP TABLESPACE ts1;
90 DROP TABLESPACE ts1;
91 ERROR HY000: Tablespace ts1 doesn't exist.
92 DROP LOGFILE GROUP lg1
93 ENGINE=NDB;
94 DROP LOGFILE GROUP lg1
95 ENGINE=NDB;
96 ERROR HY000: Failed to drop LOGFILE GROUP
97 SHOW WARNINGS;
98 Level Code Message
99 Warning 1296 Got error 723 'No such table existed' from NDB
100 Warning 1296 Failed to get logfile group 'lg1' from NDB
101 Error 1529 Failed to drop LOGFILE GROUP
102 SET DEFAULT_STORAGE_ENGINE=NDB;
103 CREATE LOGFILE GROUP lgx
104 ADD UNDOFILE 'undofile.dat'
105 INITIAL_SIZE 1M
106 UNDO_BUFFER_SIZE = 1M;
107 ALTER LOGFILE GROUP lgx
108 ADD UNDOFILE 'undofile02.dat'
109 INITIAL_SIZE=1M;
110 CREATE TABLESPACE tsx
111 ADD DATAFILE 'datafile.dat'
112 USE LOGFILE GROUP lgx
113 INITIAL_SIZE=1M;
114 ALTER TABLESPACE tsx
115 DROP DATAFILE 'datafile.dat'
116 INITIAL_SIZE=1M;
117 DROP TABLESPACE tsx;
118 DROP LOGFILE GROUP lgx;
119 DROP DATABASE IF EXISTS mysqltest;
120 **** End Duplicate Statement Testing ****
121
122 **** Begin Statment CaSe Testing ****
123 creaTE LOgfilE GrOuP lg1
124 adD undoFILE 'undofile.dat'
125 initiAL_siZE 1M
126 UnDo_BuFfEr_SiZe = 1M
127 ENGInE=NDb;
128 altER LOgFiLE GrOUp lg1
129 AdD UnDOfILe 'uNdOfiLe02.daT'
130 INItIAl_SIzE 1M ENgINE nDB;
131 CrEAtE TABLEspaCE ts1
132 ADD DATAfilE 'datafile.dat'
133 UsE LoGFiLE GRoUP lg1
134 INITiaL_SizE 1M
135 ENGiNe NDb;
136 AlTeR tAbLeSpAcE ts1
137 AdD DaTaFiLe 'dAtAfiLe2.daT'
138 InItIaL_SiZe 1M;
139 CREATE TABLE t1
140 (pk1 int not null primary key, b int not null, c int not null)
141 TABLEspace ts1 storAGE dISk
142 ENGine nDb;
143 DROP TABLE t1;
144 AlteR TAblespaCE ts1
145 droP DATAfile 'dAtAfiLe2.daT';
146 ALter tablesPACE ts1
147 dROp dAtAfIlE 'datafile.dat';
148 DrOp TaBleSpAcE ts1;
149 DrOp lOgFiLe GrOuP lg1
150 EnGiNe=nDb;
151 **** End Statment CaSe Testing ****
152
153 **** Begin = And No = Testing ****
154 CREATE LOGFILE GROUP lg1
155 ADD UNDOFILE 'undofile.dat'
156 INITIAL_SIZE=1M
157 UNDO_BUFFER_SIZE=1M
158 ENGINE=NDB;
159 ALTER LOGFILE GROUP lg1
160 ADD UNDOFILE 'undofile02.dat'
161 INITIAL_SIZE=1M
162 ENGINE=NDB;
163 CREATE TABLESPACE ts1
164 ADD DATAFILE 'datafile.dat'
165 USE LOGFILE GROUP lg1
166 INITIAL_SIZE=1M
167 ENGINE=NDB;
168 ALTER TABLESPACE ts1
169 ADD DATAFILE 'datafile2.dat'
170 INITIAL_SIZE=1M;
171 CREATE TABLE t1
172 (pk1 INT NOT NULL PRIMARY KEY, b INT NOT NULL, c INT NOT NULL)
173 TABLESPACE ts1 STORAGE DISK
174 ENGINE=NDB;
175 DROP TABLE t1;
176 ALTER TABLESPACE ts1
177 DROP DATAFILE 'datafile2.dat';
178 ALTER TABLESPACE ts1
179 DROP DATAFILE 'datafile.dat';
180 DROP TABLESPACE ts1;
181 DROP LOGFILE GROUP lg1
182 ENGINE=NDB;
183
184 **** End of = ****
185
186 CREATE LOGFILE GROUP lg1
187 ADD UNDOFILE 'undofile.dat'
188 INITIAL_SIZE 1M
189 UNDO_BUFFER_SIZE 1M
190 ENGINE NDB;
191 ALTER LOGFILE GROUP lg1
192 ADD UNDOFILE 'undofile02.dat'
193 INITIAL_SIZE 1M
194 ENGINE NDB;
195 CREATE TABLESPACE ts1
196 ADD DATAFILE 'datafile.dat'
197 USE LOGFILE GROUP lg1
198 INITIAL_SIZE 1M
199 ENGINE NDB;
200 ALTER TABLESPACE ts1
201 ADD DATAFILE 'datafile2.dat'
202 INITIAL_SIZE 1M;
203 CREATE TABLE t1
204 (pk1 INT NOT NULL PRIMARY KEY, b INT NOT NULL, c INT NOT NULL)
205 TABLESPACE ts1 STORAGE MEMORY
206 ENGINE NDB;
207 ALTER TABLE t1 STORAGE DISK;
208 CREATE INDEX b_i on t1(b);
209 CREATE INDEX bc_i on t1(b, c);
210 DROP TABLE t1;
211 CREATE TABLESPACE ts2
212 ADD DATAFILE 'datafile3.dat'
213 USE LOGFILE GROUP lg1
214 INITIAL_SIZE 1M
215 ENGINE NDB;
216 ALTER TABLESPACE ts1
217 DROP DATAFILE 'datafile3.dat';
218 ERROR HY000: Tablespace 'ts1' does not have a file named 'datafile3.dat'
219 ALTER TABLESPACE ts2
220 DROP DATAFILE 'datafile2.dat';
221 ERROR HY000: Tablespace 'ts2' does not have a file named 'datafile2.dat'
222 ALTER TABLESPACE ts1
223 DROP DATAFILE 'datafile2.dat';
224 ALTER TABLESPACE ts1
225 DROP DATAFILE 'datafile.dat';
226 DROP TABLESPACE ts1;
227 ALTER TABLESPACE ts2
228 DROP DATAFILE 'datafile3.dat';
229 DROP TABLESPACE ts2;
230 DROP LOGFILE GROUP lg1
231 ENGINE NDB;
232 **** End = And No = ****
233 create logfile group lg1 add undofile 'MYSQLTEST_VARDIR/tmp/t1.dat' initial_size 1M undo_buffer_size = 1M engine=ndb;;
234 ERROR HY000: Failed to create LOGFILE GROUP
235 create logfile group lg1
236 add undofile 'undofile.dat'
237 initial_size 1M
238 undo_buffer_size = 1M
239 engine=ndb;
240 create tablespace ts1 add datafile 'MYSQLTEST_VARDIR/tmp/t1.dat' use logfile group lg1 initial_size 1M engine ndb;;
241 ERROR HY000: Failed to create TABLESPACE
242 drop tablespace ts1
243 engine ndb;
244 ERROR HY000: Tablespace ts1 doesn't exist.
245 drop logfile group lg1
246 engine ndb;