Debian Codegraph @

mysql-test/suite/ndbcluster/alter_inplace_add_pk.result

raw
1 #
2 # Test adding index on table without primary key
3 # using inplace alter table.
4 #
5 CREATE TABLE t1 (
6 a int not null,
7 b int
8 ) ENGINE = NDB;
9 # Case A) on a NOT NULL column
10 # NOTE! When adding a UNIQUE index it becomes ADD PRIMARY KEY
11 ALTER TABLE t1 ALGORITHM=INPLACE, ADD UNIQUE INDEX a_idx(a);
12 ERROR 0A000: ALGORITHM=INPLACE is not supported. Reason: Adding primary key. Try ALGORITHM=COPY.
13 SHOW WARNINGS;
14 Level Code Message
15 Error 1846 ALGORITHM=INPLACE is not supported. Reason: Adding primary key. Try ALGORITHM=COPY.
16 ALTER TABLE t1 ALGORITHM=INPLACE, ADD PRIMARY KEY (a);
17 ERROR 0A000: ALGORITHM=INPLACE is not supported. Reason: Adding primary key. Try ALGORITHM=COPY.
18 SHOW WARNINGS;
19 Level Code Message
20 Error 1846 ALGORITHM=INPLACE is not supported. Reason: Adding primary key. Try ALGORITHM=COPY.
21 ALTER TABLE t1 ALGORITHM=INPLACE, ADD INDEX a_idx2(a);
22 # Case B) on a nullable column
23 ALTER TABLE t1 ALGORITHM=INPLACE, ADD UNIQUE INDEX b_idx(b);
24 ALTER TABLE t1 ALGORITHM=INPLACE, ADD INDEX b_idx2(b);
25 DROP TABLE t1;