Debian Codegraph @

mysql-test/suite/storage_engine/alter_table.result

raw
1 DROP TABLE IF EXISTS t1, t2;
2 CREATE TABLE t1 (a <INT_COLUMN>, c <CHAR_COLUMN>) ENGINE=<STORAGE_ENGINE> <CUSTOM_TABLE_OPTIONS>;
3 INSERT INTO t1 (a,c) VALUES (1,'a'),(5,'z');
4 ALTER TABLE t1 ADD COLUMN b <INT_COLUMN>;
5 SHOW CREATE TABLE t1;
6 Table Create Table
7 t1 CREATE TABLE `t1` (
8 `a` int(11) DEFAULT NULL,
9 `c` char(8) DEFAULT NULL,
10 `b` int(11) DEFAULT NULL
11 ) ENGINE=<STORAGE_ENGINE> DEFAULT CHARSET=latin1
12 ALTER TABLE t1 ALTER COLUMN a SET DEFAULT '0';
13 SHOW CREATE TABLE t1;
14 Table Create Table
15 t1 CREATE TABLE `t1` (
16 `a` int(11) DEFAULT 0,
17 `c` char(8) DEFAULT NULL,
18 `b` int(11) DEFAULT NULL
19 ) ENGINE=<STORAGE_ENGINE> DEFAULT CHARSET=latin1
20 ALTER TABLE t1 ALTER a DROP DEFAULT;
21 SHOW CREATE TABLE t1;
22 Table Create Table
23 t1 CREATE TABLE `t1` (
24 `a` int(11),
25 `c` char(8) DEFAULT NULL,
26 `b` int(11) DEFAULT NULL
27 ) ENGINE=<STORAGE_ENGINE> DEFAULT CHARSET=latin1
28 ALTER TABLE t1 CHANGE COLUMN b b1 <CHAR_COLUMN> FIRST;
29 SHOW CREATE TABLE t1;
30 Table Create Table
31 t1 CREATE TABLE `t1` (
32 `b1` char(8) DEFAULT NULL,
33 `a` int(11),
34 `c` char(8) DEFAULT NULL
35 ) ENGINE=<STORAGE_ENGINE> DEFAULT CHARSET=latin1
36 ALTER TABLE t1 CHANGE b1 b <INT_COLUMN> AFTER c;
37 SHOW CREATE TABLE t1;
38 Table Create Table
39 t1 CREATE TABLE `t1` (
40 `a` int(11),
41 `c` char(8) DEFAULT NULL,
42 `b` int(11) DEFAULT NULL
43 ) ENGINE=<STORAGE_ENGINE> DEFAULT CHARSET=latin1
44 ALTER TABLE t1 CHANGE b b <CHAR_COLUMN>;
45 SHOW CREATE TABLE t1;
46 Table Create Table
47 t1 CREATE TABLE `t1` (
48 `a` int(11),
49 `c` char(8) DEFAULT NULL,
50 `b` char(8) DEFAULT NULL
51 ) ENGINE=<STORAGE_ENGINE> DEFAULT CHARSET=latin1
52 ALTER TABLE t1 MODIFY COLUMN b <INT_COLUMN>;
53 SHOW CREATE TABLE t1;
54 Table Create Table
55 t1 CREATE TABLE `t1` (
56 `a` int(11),
57 `c` char(8) DEFAULT NULL,
58 `b` int(11) DEFAULT NULL
59 ) ENGINE=<STORAGE_ENGINE> DEFAULT CHARSET=latin1
60 ALTER TABLE t1 MODIFY COLUMN b <CHAR_COLUMN> FIRST;
61 SHOW CREATE TABLE t1;
62 Table Create Table
63 t1 CREATE TABLE `t1` (
64 `b` char(8) DEFAULT NULL,
65 `a` int(11),
66 `c` char(8) DEFAULT NULL
67 ) ENGINE=<STORAGE_ENGINE> DEFAULT CHARSET=latin1
68 ALTER TABLE t1 MODIFY COLUMN b <INT_COLUMN> AFTER a;
69 SHOW CREATE TABLE t1;
70 Table Create Table
71 t1 CREATE TABLE `t1` (
72 `a` int(11),
73 `b` int(11) DEFAULT NULL,
74 `c` char(8) DEFAULT NULL
75 ) ENGINE=<STORAGE_ENGINE> DEFAULT CHARSET=latin1
76 ALTER TABLE t1 DROP COLUMN b;
77 SHOW CREATE TABLE t1;
78 Table Create Table
79 t1 CREATE TABLE `t1` (
80 `a` int(11),
81 `c` char(8) DEFAULT NULL
82 ) ENGINE=<STORAGE_ENGINE> DEFAULT CHARSET=latin1
83 ALTER TABLE t1 RENAME TO t2;
84 SHOW CREATE TABLE t1;
85 ERROR 42S02: Table 'test.t1' doesn't exist
86 SHOW CREATE TABLE t2;
87 Table Create Table
88 t2 CREATE TABLE `t2` (
89 `a` int(11),
90 `c` char(8) DEFAULT NULL
91 ) ENGINE=<STORAGE_ENGINE> DEFAULT CHARSET=latin1
92 DROP TABLE t2;
93 CREATE TABLE t1 (a <INT_COLUMN>, b <INT_COLUMN>) ENGINE=<STORAGE_ENGINE> <CUSTOM_TABLE_OPTIONS>;
94 INSERT INTO t1 (a,b) VALUES (1,5),(2,2),(4,3);
95 SHOW CREATE TABLE t1;
96 Table Create Table
97 t1 CREATE TABLE `t1` (
98 `a` int(11) DEFAULT NULL,
99 `b` int(11) DEFAULT NULL
100 ) ENGINE=<STORAGE_ENGINE> DEFAULT CHARSET=latin1
101 ALTER TABLE t1 ORDER BY b ASC, a DESC;
102 SHOW CREATE TABLE t1;
103 Table Create Table
104 t1 CREATE TABLE `t1` (
105 `a` int(11) DEFAULT NULL,
106 `b` int(11) DEFAULT NULL
107 ) ENGINE=<STORAGE_ENGINE> DEFAULT CHARSET=latin1
108 SELECT a,b FROM t1;
109 a b
110 2 2
111 4 3
112 1 5
113 DROP TABLE t1;
114 CREATE TABLE t1 (a <INT_COLUMN>, b <CHAR_COLUMN>, c <CHAR_COLUMN>) ENGINE=<STORAGE_ENGINE> <CUSTOM_TABLE_OPTIONS> CHARACTER SET latin1 COLLATE latin1_general_cs;
115 INSERT INTO t1 (a,b,c) VALUES (5,'z','t');
116 SHOW CREATE TABLE t1;
117 Table Create Table
118 t1 CREATE TABLE `t1` (
119 `a` int(11) DEFAULT NULL,
120 `b` char(8) COLLATE latin1_general_cs DEFAULT NULL,
121 `c` char(8) COLLATE latin1_general_cs DEFAULT NULL
122 ) ENGINE=<STORAGE_ENGINE> DEFAULT CHARSET=latin1 COLLATE=latin1_general_cs
123 ALTER TABLE t1 CONVERT TO CHARACTER SET utf8;
124 SHOW CREATE TABLE t1;
125 Table Create Table
126 t1 CREATE TABLE `t1` (
127 `a` int(11) DEFAULT NULL,
128 `b` char(8) DEFAULT NULL,
129 `c` char(8) DEFAULT NULL
130 ) ENGINE=<STORAGE_ENGINE> DEFAULT CHARSET=utf8
131 ALTER TABLE t1 DEFAULT CHARACTER SET = latin1 COLLATE latin1_general_ci;
132 SHOW CREATE TABLE t1;
133 Table Create Table
134 t1 CREATE TABLE `t1` (
135 `a` int(11) DEFAULT NULL,
136 `b` char(8) CHARACTER SET utf8 DEFAULT NULL,
137 `c` char(8) CHARACTER SET utf8 DEFAULT NULL
138 ) ENGINE=<STORAGE_ENGINE> DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci
139 ALTER TABLE t1 FORCE;
140 SHOW CREATE TABLE t1;
141 Table Create Table
142 t1 CREATE TABLE `t1` (
143 `a` int(11) DEFAULT NULL,
144 `b` char(8) CHARACTER SET utf8 DEFAULT NULL,
145 `c` char(8) CHARACTER SET utf8 DEFAULT NULL
146 ) ENGINE=<STORAGE_ENGINE> DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci
147 DROP TABLE t1;