90 lines
3.0 KiB
Plaintext
90 lines
3.0 KiB
Plaintext
CREATE LOGFILE GROUP lg1
|
|
ADD UNDOFILE 'lg1_undofile.dat'
|
|
INITIAL_SIZE 1M
|
|
UNDO_BUFFER_SIZE = 1M
|
|
ENGINE=ndb;
|
|
CREATE TABLESPACE ts1
|
|
ADD DATAFILE 'ts1_datafile.dat'
|
|
USE LOGFILE GROUP lg1
|
|
INITIAL_SIZE 10M
|
|
ENGINE ndb;
|
|
CREATE TABLE t5 (a int PRIMARY KEY, t5b int, t5c int)
|
|
ENGINE ndb;
|
|
INSERT INTO t5 VALUES (1, 1, 1);
|
|
ALTER TABLE t5 ALGORITHM=inplace, STORAGE disk TABLESPACE ts1;
|
|
ERROR 0A000: ALGORITHM=INPLACE is not supported. Reason: Column storage media is changed due to change in table storage media. Try ALGORITHM=COPY.
|
|
ALTER TABLE t5 STORAGE DISK TABLESPACE ts1;
|
|
ALTER TABLESPACE ts1
|
|
DROP DATAFILE 'ts1_datafile.dat';
|
|
ERROR HY000: Failed to alter: DROP DATAFILE FAILED
|
|
SHOW WARNINGS;
|
|
Level Code Message
|
|
Warning 1296 Got error 770 'Cant drop file, file is used' from NDB
|
|
Warning 1296 Failed to commit NDB schema transaction
|
|
Error 1533 Failed to alter: DROP DATAFILE FAILED
|
|
ALTER TABLE t5 STORAGE memory;
|
|
ALTER TABLESPACE ts1
|
|
DROP DATAFILE 'ts1_datafile.dat';
|
|
SELECT * FROM t5;
|
|
a t5b t5c
|
|
1 1 1
|
|
DROP TABLE t5;
|
|
DROP TABLESPACE ts1;
|
|
CREATE TABLESPACE ts1
|
|
ADD DATAFILE 'ts1_datafile.dat'
|
|
USE LOGFILE GROUP lg1
|
|
INITIAL_SIZE 10M
|
|
ENGINE ndb;
|
|
CREATE TABLE t5 (a int PRIMARY KEY, t5b int, t5c int)
|
|
ENGINE ndb;
|
|
INSERT INTO t5 VALUES (1, 1, 1);
|
|
ALTER TABLE t5 CHANGE t5b t5b int STORAGE disk, TABLESPACE ts1;
|
|
ALTER TABLESPACE ts1
|
|
DROP DATAFILE 'ts1_datafile.dat';
|
|
ERROR HY000: Failed to alter: DROP DATAFILE FAILED
|
|
SHOW WARNINGS;
|
|
Level Code Message
|
|
Warning 1296 Got error 770 'Cant drop file, file is used' from NDB
|
|
Warning 1296 Failed to commit NDB schema transaction
|
|
Error 1533 Failed to alter: DROP DATAFILE FAILED
|
|
ALTER TABLE t5 CHANGE t5b t5b int STORAGE memory;
|
|
ALTER TABLESPACE ts1
|
|
DROP DATAFILE 'ts1_datafile.dat';
|
|
SELECT * FROM t5;
|
|
a t5b t5c
|
|
1 1 1
|
|
DROP TABLE t5;
|
|
DROP TABLESPACE ts1;
|
|
CREATE TABLESPACE ts1
|
|
ADD DATAFILE 'ts1_datafile.dat'
|
|
USE LOGFILE GROUP lg1
|
|
INITIAL_SIZE 10M
|
|
ENGINE ndb;
|
|
CREATE TABLE t5 (a int PRIMARY KEY, t5b tinyblob,
|
|
t5c tinytext, t5d int unique key STORAGE disk)
|
|
TABLESPACE ts1 ENGINE ndb;
|
|
ERROR HY000: Table storage engine 'ndbcluster' does not support the create option 'index on DISK column'
|
|
SHOW WARNINGS;
|
|
Level Code Message
|
|
Warning 1478 Cannot create index on DISK column 't5d'. Alter it in a way to use STORAGE MEMORY.
|
|
Error 1478 Table storage engine 'ndbcluster' does not support the create option 'index on DISK column'
|
|
CREATE TABLE t5 (a int PRIMARY KEY, t5b tinyblob,
|
|
t5c tinytext, t5d int STORAGE disk)
|
|
TABLESPACE ts1 ENGINE ndb;
|
|
CREATE INDEX 5d_i ON t5(t5d);
|
|
ERROR HY000: Table storage engine 'ndbcluster' does not support the create option 'index on DISK column'
|
|
ALTER TABLE t5 ADD INDEX 5d_i (t5d);
|
|
ERROR HY000: Table storage engine 'ndbcluster' does not support the create option 'index on DISK column'
|
|
DROP TABLE t5;
|
|
CREATE TABLE t5 (a int PRIMARY KEY, t5b tinyblob,
|
|
t5c tinytext, t5d int)
|
|
STORAGE disk TABLESPACE ts1 ENGINE ndb;
|
|
CREATE INDEX 5d_i ON t5(t5d);
|
|
DROP INDEX 5d_i on t5;
|
|
ALTER TABLE t5 ADD INDEX 5d_i(t5d);
|
|
DROP TABLE t5;
|
|
ALTER TABLESPACE ts1
|
|
DROP DATAFILE 'ts1_datafile.dat';
|
|
DROP TABLESPACE ts1;
|
|
DROP LOGFILE GROUP lg1 ENGINE=ndb;
|