1
CREATE TABLE t1 (A INT);
6
) ENGINE=InnoDB COLLATE = utf8_general_ci
7
ALTER TABLE t1 ADD COLUMN b UUID NOT NULL;
10
t1 CREATE TABLE `t1` (
13
) ENGINE=InnoDB COLLATE = utf8_general_ci
15
CREATE TABLE t1 (A INT);
18
t1 CREATE TABLE `t1` (
20
) ENGINE=InnoDB COLLATE = utf8_general_ci
21
INSERT INTO t1 VALUES (1), (2), (3);
22
SELECT COUNT(*) = 3 FROM t1;
25
ALTER TABLE t1 ADD COLUMN b UUID NOT NULL;
26
ERROR HY000: Either a DEFAULt value or NULL NULL description is required for a new column if table is not empty
29
t1 CREATE TABLE `t1` (
31
) ENGINE=InnoDB COLLATE = utf8_general_ci
32
ALTER TABLE t1 ADD COLUMN b UUID DEFAULT NULL;
40
t1 CREATE TABLE `t1` (
43
) ENGINE=InnoDB COLLATE = utf8_general_ci