Debian Codegraph @

mysql-test/suite/csv/csv_alter_table.result

raw
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;
5 DESC t1;
6 Field Type Null Key Default Extra
7 a int(11) NO NULL
8 b char(5) NO NULL
9 ALTER TABLE t1 DROP COLUMN b;
10 DESC t1;
11 Field Type Null Key Default Extra
12 a int(11) NO NULL
13 ALTER TABLE t1 MODIFY a BIGINT NOT NULL;
14 DESC t1;
15 Field Type Null Key Default Extra
16 a bigint(20) NO NULL
17 ALTER TABLE t1 CHANGE a a INT NOT NULL;
18 DESC t1;
19 Field Type Null Key Default Extra
20 a int(11) NO NULL
21 DROP TABLE t1;
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
27 DESC t1;
28 Field Type Null Key Default Extra
29 a int(11) NO NULL
30 ALTER TABLE t1 MODIFY a BIGINT;
31 ERROR 42000: The storage engine for the table doesn't support nullable columns
32 DESC t1;
33 Field Type Null Key Default Extra
34 a int(11) NO NULL
35 ALTER TABLE t1 CHANGE a a INT;
36 ERROR 42000: The storage engine for the table doesn't support nullable columns
37 DESC t1;
38 Field Type Null Key Default Extra
39 a int(11) NO NULL
40 DROP TABLE t1;