|
722.2.23
by Monty Taylor
Enabled csv_not_null and csv_alter_table. |
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 NO NULL |
|
8 |
b varchar(5) NO NULL |
|
9 |
ALTER TABLE t1 DROP COLUMN b; |
|
10 |
DESC t1; |
|
11 |
Field Type Null Key Default Extra |
|
12 |
a int NO NULL |
|
13 |
ALTER TABLE t1 MODIFY a BIGINT NOT NULL; |
|
14 |
DESC t1; |
|
15 |
Field Type Null Key Default Extra |
|
16 |
a bigint 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 NO NULL |
|
21 |
DROP TABLE t1; |
|
22 |
# ===== csv_alter_table.2 =====
|
|
23 |
DROP TABLE IF EXISTS t1; |
|
24 |
Warnings: |
|
25 |
Note 1051 Unknown table 't1' |
|
26 |
CREATE TABLE t1 (a int NOT NULL) ENGINE = CSV; |
|
27 |
ALTER TABLE t1 ADD COLUMN b CHAR(5); |
|
28 |
ERROR 42000: The storage engine for the table doesn't support nullable columns |
|
29 |
DESC t1; |
|
30 |
Field Type Null Key Default Extra |
|
31 |
a int NO NULL |
|
32 |
ALTER TABLE t1 MODIFY a BIGINT; |
|
33 |
ERROR 42000: The storage engine for the table doesn't support nullable columns |
|
34 |
DESC t1; |
|
35 |
Field Type Null Key Default Extra |
|
36 |
a int NO NULL |
|
37 |
ALTER TABLE t1 CHANGE a a INT; |
|
38 |
ERROR 42000: The storage engine for the table doesn't support nullable columns |
|
39 |
DESC t1; |
|
40 |
Field Type Null Key Default Extra |
|
41 |
a int NO NULL |
|
42 |
DROP TABLE t1; |