| 1 |
CREATE LOGFILE GROUP lg1 |
| 2 |
ADD UNDOFILE 'lg1_undofile.dat' |
| 3 |
INITIAL_SIZE 1M |
| 4 |
UNDO_BUFFER_SIZE = 1M |
| 5 |
ENGINE=ndb; |
| 6 |
CREATE TABLESPACE ts1 |
| 7 |
ADD DATAFILE 'ts1_datafile.dat' |
| 8 |
USE LOGFILE GROUP lg1 |
| 9 |
INITIAL_SIZE 10M |
| 10 |
ENGINE ndb; |
| 11 |
CREATE TABLE t5 (a int PRIMARY KEY, t5b int, t5c int) |
| 12 |
ENGINE ndb TABLESPACE ts1; |
| 13 |
INSERT INTO t5 VALUES (1, 1, 1); |
| 14 |
ALTER TABLE t5 ALGORITHM=inplace, STORAGE disk; |
| 15 |
ERROR 0A000: ALGORITHM=INPLACE is not supported. Reason: Column storage media is changed due to change in table storage media. Try ALGORITHM=COPY. |
| 16 |
ALTER TABLE t5 STORAGE DISK; |
| 17 |
ALTER TABLESPACE ts1 |
| 18 |
DROP DATAFILE 'ts1_datafile.dat'; |
| 19 |
ERROR HY000: Failed to alter: DROP DATAFILE FAILED |
| 20 |
SHOW WARNINGS; |
| 21 |
Level Code Message |
| 22 |
Warning 1296 Got error 770 'Cant drop file, file is used' from NDB |
| 23 |
Warning 1296 Failed to commit NDB schema transaction |
| 24 |
Error 1533 Failed to alter: DROP DATAFILE FAILED |
| 25 |
ALTER TABLE t5 STORAGE memory; |
| 26 |
ALTER TABLESPACE ts1 |
| 27 |
DROP DATAFILE 'ts1_datafile.dat'; |
| 28 |
SELECT * FROM t5; |
| 29 |
a t5b t5c |
| 30 |
1 1 1 |
| 31 |
DROP TABLE t5; |
| 32 |
DROP TABLESPACE ts1; |
| 33 |
CREATE TABLESPACE ts1 |
| 34 |
ADD DATAFILE 'ts1_datafile.dat' |
| 35 |
USE LOGFILE GROUP lg1 |
| 36 |
INITIAL_SIZE 10M |
| 37 |
ENGINE ndb; |
| 38 |
CREATE TABLE t5 (a int PRIMARY KEY, t5b int, t5c int) |
| 39 |
ENGINE ndb; |
| 40 |
INSERT INTO t5 VALUES (1, 1, 1); |
| 41 |
ALTER TABLE t5 CHANGE t5b t5b int STORAGE disk, TABLESPACE ts1; |
| 42 |
ALTER TABLESPACE ts1 |
| 43 |
DROP DATAFILE 'ts1_datafile.dat'; |
| 44 |
ERROR HY000: Failed to alter: DROP DATAFILE FAILED |
| 45 |
SHOW WARNINGS; |
| 46 |
Level Code Message |
| 47 |
Warning 1296 Got error 770 'Cant drop file, file is used' from NDB |
| 48 |
Warning 1296 Failed to commit NDB schema transaction |
| 49 |
Error 1533 Failed to alter: DROP DATAFILE FAILED |
| 50 |
ALTER TABLE t5 CHANGE t5b t5b int STORAGE memory; |
| 51 |
ALTER TABLESPACE ts1 |
| 52 |
DROP DATAFILE 'ts1_datafile.dat'; |
| 53 |
SELECT * FROM t5; |
| 54 |
a t5b t5c |
| 55 |
1 1 1 |
| 56 |
DROP TABLE t5; |
| 57 |
DROP TABLESPACE ts1; |
| 58 |
CREATE TABLESPACE ts1 |
| 59 |
ADD DATAFILE 'ts1_datafile.dat' |
| 60 |
USE LOGFILE GROUP lg1 |
| 61 |
INITIAL_SIZE 10M |
| 62 |
ENGINE ndb; |
| 63 |
CREATE TABLE t5 (a int PRIMARY KEY, t5b tinyblob, |
| 64 |
t5c tinytext, t5d int unique key STORAGE disk) |
| 65 |
TABLESPACE ts1 ENGINE ndb; |
| 66 |
ERROR HY000: Table storage engine 'ndbcluster' does not support the create option 'index on DISK column' |
| 67 |
SHOW WARNINGS; |
| 68 |
Level Code Message |
| 69 |
Warning 1478 Cannot create index on DISK column 't5d'. Alter it in a way to use STORAGE MEMORY. |
| 70 |
Error 1478 Table storage engine 'ndbcluster' does not support the create option 'index on DISK column' |
| 71 |
CREATE TABLE t5 (a int PRIMARY KEY, t5b tinyblob, |
| 72 |
t5c tinytext, t5d int STORAGE disk) |
| 73 |
TABLESPACE ts1 ENGINE ndb; |
| 74 |
CREATE INDEX 5d_i ON t5(t5d); |
| 75 |
ERROR HY000: Table storage engine 'ndbcluster' does not support the create option 'index on DISK column' |
| 76 |
ALTER TABLE t5 ADD INDEX 5d_i (t5d); |
| 77 |
ERROR HY000: Table storage engine 'ndbcluster' does not support the create option 'index on DISK column' |
| 78 |
DROP TABLE t5; |
| 79 |
CREATE TABLE t5 (a int PRIMARY KEY, t5b tinyblob, |
| 80 |
t5c tinytext, t5d int) |
| 81 |
STORAGE disk TABLESPACE ts1 ENGINE ndb; |
| 82 |
CREATE INDEX 5d_i ON t5(t5d); |
| 83 |
DROP INDEX 5d_i on t5; |
| 84 |
ALTER TABLE t5 ADD INDEX 5d_i(t5d); |
| 85 |
DROP TABLE t5; |
| 86 |
ALTER TABLESPACE ts1 |
| 87 |
DROP DATAFILE 'ts1_datafile.dat'; |
| 88 |
DROP TABLESPACE ts1; |
| 89 |
DROP LOGFILE GROUP lg1 ENGINE=ndb; |