Debian Codegraph @

mysql-test/suite/csv/csv_alter_table.test

raw
1 #-----------------------------------------------------------------------------
2 # csv_alter_table.test - .test file for MySQL regression suite
3 # Purpose: To test the behavior of the CSV engine
4 # Bug#31473 resulted in strict enforcement of non-nullable
5 # columns in CSV engine.
6 # Tests code for Bug#33696 - CSV engine allows NULLable
7 # Columns via ALTER TABLE statements
8 #
9 # Author pcrews
10 # Last modified: 2008-01-06
11 #-----------------------------------------------------------------------------
12
13 --source include/have_csv.inc
14
15 #############################################################################
16 # Testcase csv_alter_table.1: Positive test for ALTER table
17 #
18 #############################################################################
19 -- echo # ===== csv_alter_table.1 =====
20 -- disable_warnings
21 DROP TABLE IF EXISTS t1;
22 -- enable_warnings
23
24 CREATE TABLE t1 (a int NOT NULL) ENGINE = CSV;
25 ALTER TABLE t1 ADD COLUMN b CHAR(5) NOT NULL;
26 DESC t1;
27 ALTER TABLE t1 DROP COLUMN b;
28 DESC t1;
29 ALTER TABLE t1 MODIFY a BIGINT NOT NULL;
30 DESC t1;
31 ALTER TABLE t1 CHANGE a a INT NOT NULL;
32 DESC t1;
33
34 DROP TABLE t1;
35
36 #############################################################################
37 # Testcase csv_alter_table.2: Negative test for ALTER table
38 # These queries should not succeed / should throw errors
39 #############################################################################
40 -- echo # ===== csv_alter_table.2 =====
41 -- disable_warnings
42 DROP TABLE IF EXISTS t1;
43 -- enable_warnings
44
45 CREATE TABLE t1 (a int NOT NULL) ENGINE = CSV;
46 --error ER_CHECK_NOT_IMPLEMENTED
47 ALTER TABLE t1 ADD COLUMN b CHAR(5);
48 DESC t1;
49 --error ER_CHECK_NOT_IMPLEMENTED
50 ALTER TABLE t1 MODIFY a BIGINT;
51 DESC t1;
52 --error ER_CHECK_NOT_IMPLEMENTED
53 ALTER TABLE t1 CHANGE a a INT;
54 DESC t1;
55
56 DROP TABLE t1;