1
# ===== csv_alter_table.1 =====
2
DROP TABLE IF EXISTS t1;
3
CREATE TABLE t1 (a int NOT NULL) ENGINE = CSV;
4
ALTER TABLE t1 ADD COLUMN b CHAR(5) NOT NULL;
6
Field Type Null Key Default Extra
9
ALTER TABLE t1 DROP COLUMN b;
11
Field Type Null Key Default Extra
13
ALTER TABLE t1 MODIFY a BIGINT NOT NULL;
15
Field Type Null Key Default Extra
17
ALTER TABLE t1 CHANGE a a INT NOT NULL;
19
Field Type Null Key Default Extra
22
# ===== csv_alter_table.2 =====
23
DROP TABLE IF EXISTS t1;
24
CREATE TABLE t1 (a int NOT NULL) ENGINE = CSV;
25
ALTER TABLE t1 ADD COLUMN b CHAR(5);
26
ERROR 42000: The storage engine for the table doesn't support nullable columns
28
Field Type Null Key Default Extra
30
ALTER TABLE t1 MODIFY a BIGINT;
31
ERROR 42000: The storage engine for the table doesn't support nullable columns
33
Field Type Null Key Default Extra
35
ALTER TABLE t1 CHANGE a a INT;
36
ERROR 42000: The storage engine for the table doesn't support nullable columns
38
Field Type Null Key Default Extra