Debian Codegraph @

mysql-test/suite/ndbcluster/alter_copying.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=COPY, ADD COLUMN c INT NOT NULL DEFAULT 14;
17 SELECT * FROM t1 ORDER BY a;
18 a b c
19 1 MySQL Server with NDB 14
20 11 Barrier effect 14
21 12 The third row 14
22 37 And of course number 37 14
23 DROP TABLE t1;