Debian Codegraph @

mysql-test/suite/ndbcluster/alter_inplace.result

raw
1 CREATE TABLE t1 (
2 a int PRIMARY KEY,
3 b varchar(255)
4 ) ENGINE = NDB;
5 INSERT INTO t1 VALUES (1, "MySQL Server with NDB");
6 INSERT INTO t1 (a, b) VALUES (11, "Barrier effect");
7 INSERT INTO t1 (a, b) VALUES
8 (12, "The third row"),
9 (37, "And of course number 37");
10 SELECT * FROM t1 ORDER BY a;
11 a b
12 1 MySQL Server with NDB
13 11 Barrier effect
14 12 The third row
15 37 And of course number 37
16 ALTER TABLE t1 ALGORITHM=INPLACE, ADD COLUMN c INT DEFAULT NULL;
17 Warnings:
18 Warning 1478 Converted FIXED field 'c' to DYNAMIC to enable online ADD COLUMN
19 SELECT * FROM t1 ORDER BY a;
20 a b c
21 1 MySQL Server with NDB NULL
22 11 Barrier effect NULL
23 12 The third row NULL
24 37 And of course number 37 NULL
25 DROP TABLE t1;