Debian Codegraph @

mysql-test/suite/ndbcluster/alter_inplace_add_pk.test

raw
1 --source include/have_ndb.inc
2
3 --echo #
4 --echo # Test adding index on table without primary key
5 --echo # using inplace alter table.
6 --echo #
7 CREATE TABLE t1 (
8 a int not null,
9 b int
10 ) ENGINE = NDB;
11
12 --echo # Case A) on a NOT NULL column
13 --echo # NOTE! When adding a UNIQUE index it becomes ADD PRIMARY KEY
14 --error ER_ALTER_OPERATION_NOT_SUPPORTED_REASON
15 ALTER TABLE t1 ALGORITHM=INPLACE, ADD UNIQUE INDEX a_idx(a);
16 SHOW WARNINGS;
17
18 --error ER_ALTER_OPERATION_NOT_SUPPORTED_REASON
19 ALTER TABLE t1 ALGORITHM=INPLACE, ADD PRIMARY KEY (a);
20 SHOW WARNINGS;
21
22 ALTER TABLE t1 ALGORITHM=INPLACE, ADD INDEX a_idx2(a);
23
24 --echo # Case B) on a nullable column
25 ALTER TABLE t1 ALGORITHM=INPLACE, ADD UNIQUE INDEX b_idx(b);
26
27 ALTER TABLE t1 ALGORITHM=INPLACE, ADD INDEX b_idx2(b);
28
29 DROP TABLE t1;
30
31