Debian Codegraph @

mysql-test/suite/ndb_ddl/alter_inplace_tablespace.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 16M
10 ENGINE NDB;
11 CREATE TABLESPACE ts2
12 ADD DATAFILE 'ts2_datafile.dat'
13 USE LOGFILE GROUP lg1
14 INITIAL_SIZE 16M
15 ENGINE NDB;
16 CREATE TABLE t1 (
17 a int PRIMARY KEY,
18 b int
19 ) ENGINE = NDB;
20 ALTER TABLE t1 ALGORITHM=inplace, TABLESPACE ts1;
21 ERROR 0A000: ALGORITHM=INPLACE is not supported. Reason: Adding or changing TABLESPACE. Try ALGORITHM=COPY.
22 ALTER TABLE t1 TABLESPACE ts1;
23 ALTER TABLE t1 ALGORITHM=inplace, TABLESPACE=ts2;
24 ERROR 0A000: ALGORITHM=INPLACE is not supported. Reason: Adding or changing TABLESPACE. Try ALGORITHM=COPY.
25 ALTER TABLE t1 ALGORITHM=inplace, TABLESPACE=ts1;
26 ERROR 0A000: ALGORITHM=INPLACE is not supported. Reason: Adding or changing TABLESPACE. Try ALGORITHM=COPY.
27 ALTER TABLE t1 TABLESPACE ts2;
28 DROP TABLE t1;
29 ALTER TABLESPACE ts1
30 DROP DATAFILE 'ts1_datafile.dat';
31 DROP TABLESPACE ts1;
32 ALTER TABLESPACE ts2
33 DROP DATAFILE 'ts2_datafile.dat';
34 DROP TABLESPACE ts2;
35 DROP LOGFILE GROUP lg1
36 ENGINE NDB;