DROP TABLE IF EXISTS t1; DROP DATABASE IF EXISTS mysqltest; CREATE DATABASE mysqltest; **** Begin Duplicate Statement Testing **** CREATE LOGFILE GROUP lg1 ADD UNDOFILE 'undofile.dat' INITIAL_SIZE 16M UNDO_BUFFER_SIZE = 1M ENGINE=NDB; CREATE LOGFILE GROUP lg1 ADD UNDOFILE 'undofile.dat' INITIAL_SIZE 16M UNDO_BUFFER_SIZE = 1M ENGINE=NDB; ERROR HY000: Failed to create LOGFILE GROUP ALTER LOGFILE GROUP lg1 ADD UNDOFILE 'undofile02.dat' INITIAL_SIZE 4M ENGINE NDB; ALTER LOGFILE GROUP lg1 ADD UNDOFILE 'undofile02.dat' INITIAL_SIZE 4M ENGINE=NDB; ERROR HY000: Failed to alter: CREATE UNDOFILE CREATE TABLESPACE ts1 ADD DATAFILE 'datafile.dat' USE LOGFILE GROUP lg1 INITIAL_SIZE 12M ENGINE NDB; CREATE TABLESPACE ts1 ADD DATAFILE 'datafile.dat' USE LOGFILE GROUP lg1 INITIAL_SIZE 12M ENGINE NDB; ERROR HY000: Failed to create TABLESPACE ALTER TABLESPACE ts1 ADD DATAFILE 'datafile2.dat' INITIAL_SIZE 12M ENGINE=NDB; ALTER TABLESPACE ts1 ADD DATAFILE 'datafile2.dat' INITIAL_SIZE 12M ENGINE=NDB; ERROR HY000: Failed to alter: CREATE DATAFILE CREATE TABLE mysqltest.t1 (pk1 INT NOT NULL PRIMARY KEY, b INT NOT NULL, c INT NOT NULL) TABLESPACE ts1 STORAGE DISK ENGINE=NDB; CREATE TABLE mysqltest.t1 (pk1 INT NOT NULL PRIMARY KEY, b INT NOT NULL, c INT NOT NULL) TABLESPACE ts1 STORAGE DISK ENGINE=NDB; ERROR 42S01: Table 't1' already exists CREATE TABLE mysqltest.t1 (pk1 INT NOT NULL PRIMARY KEY, b INT NOT NULL, c INT NOT NULL) ENGINE=NDB; ERROR 42S01: Table 't1' already exists DROP TABLE mysqltest.t1; ALTER TABLESPACE ts1 DROP DATAFILE 'datafile2.dat' ENGINE=NDB; ALTER TABLESPACE ts1 DROP DATAFILE 'datafile2.dat' ENGINE=NDB; ERROR HY000: Failed to alter: NO SUCH FILE ALTER TABLESPACE ts1 DROP DATAFILE 'datafile.dat' ENGINE=NDB; ALTER TABLESPACE ts1 DROP DATAFILE 'datafile.dat' ENGINE=NDB; ERROR HY000: Failed to alter: NO SUCH FILE DROP TABLESPACE ts1 ENGINE=NDB; DROP TABLESPACE ts1 ENGINE=NDB; ERROR HY000: Failed to drop TABLESPACE DROP LOGFILE GROUP lg1 ENGINE=NDB; DROP LOGFILE GROUP lg1 ENGINE=NDB; ERROR HY000: Failed to drop LOGFILE GROUP DROP DATABASE IF EXISTS mysqltest; **** End Duplicate Statement Testing **** **** Begin Statment CaSe Testing **** creaTE LOgfilE GrOuP lg1 adD undoFILE 'undofile.dat' initiAL_siZE 16M UnDo_BuFfEr_SiZe = 1M ENGInE=NDb; altER LOgFiLE GrOUp lg1 AdD UnDOfILe 'uNdOfiLe02.daT' INItIAl_SIzE 4M ENgINE nDB; CrEAtE TABLEspaCE ts1 ADD DATAfilE 'datafile.dat' UsE LoGFiLE GRoUP lg1 INITiaL_SizE 12M ENGiNe NDb; AlTeR tAbLeSpAcE ts1 AdD DaTaFiLe 'dAtAfiLe2.daT' InItIaL_SiZe 12M EnGiNe=NDB; CREATE TABLE t1 (pk1 int not null primary key, b int not null, c int not null) TABLEspace ts1 storAGE dISk ENGine nDb; DROP TABLE t1; AlteR TAblespaCE ts1 droP DATAfile 'dAtAfiLe2.daT' ENGINE=NDB; ALter tablesPACE ts1 dROp dAtAfIlE 'datafile.dat' ENGine=Ndb; DrOp TaBleSpAcE ts1 engINE=ndB; DrOp lOgFiLe GrOuP lg1 EnGiNe=nDb; **** End Statment CaSe Testing **** **** Begin = And No = Testing **** CREATE LOGFILE GROUP lg1 ADD UNDOFILE 'undofile.dat' INITIAL_SIZE=16M UNDO_BUFFER_SIZE=1M ENGINE=NDB; ALTER LOGFILE GROUP lg1 ADD UNDOFILE 'undofile02.dat' INITIAL_SIZE=4M ENGINE=NDB; CREATE TABLESPACE ts1 ADD DATAFILE 'datafile.dat' USE LOGFILE GROUP lg1 INITIAL_SIZE=12M ENGINE=NDB; ALTER TABLESPACE ts1 ADD DATAFILE 'datafile2.dat' INITIAL_SIZE=12M ENGINE=NDB; CREATE TABLE t1 (pk1 INT NOT NULL PRIMARY KEY, b INT NOT NULL, c INT NOT NULL) TABLESPACE ts1 STORAGE DISK ENGINE=NDB; DROP TABLE t1; ALTER TABLESPACE ts1 DROP DATAFILE 'datafile2.dat' ENGINE=NDB; ALTER TABLESPACE ts1 DROP DATAFILE 'datafile.dat' ENGINE=NDB; DROP TABLESPACE ts1 ENGINE=NDB; DROP LOGFILE GROUP lg1 ENGINE=NDB; **** End of = **** CREATE LOGFILE GROUP lg1 ADD UNDOFILE 'undofile.dat' INITIAL_SIZE 16M UNDO_BUFFER_SIZE 1M ENGINE NDB; ALTER LOGFILE GROUP lg1 ADD UNDOFILE 'undofile02.dat' INITIAL_SIZE 4M ENGINE NDB; CREATE TABLESPACE ts1 ADD DATAFILE 'datafile.dat' USE LOGFILE GROUP lg1 INITIAL_SIZE 12M ENGINE NDB; ALTER TABLESPACE ts1 ADD DATAFILE 'datafile2.dat' INITIAL_SIZE 12M ENGINE NDB; CREATE TABLE t1 (pk1 INT NOT NULL PRIMARY KEY, b INT NOT NULL, c INT NOT NULL) TABLESPACE ts1 STORAGE DISK ENGINE NDB; CREATE INDEX b_i on t1(b); CREATE INDEX bc_i on t1(b, c); DROP TABLE t1; ALTER TABLESPACE ts1 DROP DATAFILE 'datafile2.dat' ENGINE NDB; ALTER TABLESPACE ts1 DROP DATAFILE 'datafile.dat' ENGINE NDB; DROP TABLESPACE ts1 ENGINE NDB; DROP LOGFILE GROUP lg1 ENGINE NDB; **** End = And No = ****