Debian Codegraph @

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

raw
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;