Debian Codegraph @

mysql-test/suite/engines/funcs/r/ta_string_to_null.result

raw
1 DROP TABLE IF EXISTS t2;
2 CREATE TABLE t2(c1 CHAR(200) NOT NULL);
3 SHOW TABLES;
4 Tables_in_test
5 t2
6 SHOW CREATE TABLE t2;
7 Table Create Table
8 t2 CREATE TABLE `t2` (
9 `c1` char(200) NOT NULL
10 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
11 ALTER TABLE t2 MODIFY c1 CHAR(200) NULL;
12 SHOW TABLES;
13 Tables_in_test
14 t2
15 SHOW CREATE TABLE t2;
16 Table Create Table
17 t2 CREATE TABLE `t2` (
18 `c1` char(200) DEFAULT NULL
19 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
20 DROP TABLE t2;
21 SHOW TABLES;
22 Tables_in_test
23 CREATE TABLE t2(c1 VARCHAR(200) NOT NULL);
24 SHOW TABLES;
25 Tables_in_test
26 t2
27 SHOW CREATE TABLE t2;
28 Table Create Table
29 t2 CREATE TABLE `t2` (
30 `c1` varchar(200) NOT NULL
31 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
32 ALTER TABLE t2 MODIFY c1 VARCHAR(200) NULL;
33 SHOW TABLES;
34 Tables_in_test
35 t2
36 SHOW CREATE TABLE t2;
37 Table Create Table
38 t2 CREATE TABLE `t2` (
39 `c1` varchar(200) DEFAULT NULL
40 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
41 DROP TABLE t2;
42 SHOW TABLES;
43 Tables_in_test
44 CREATE TABLE t2(c1 BINARY(200) NOT NULL);
45 SHOW TABLES;
46 Tables_in_test
47 t2
48 SHOW CREATE TABLE t2;
49 Table Create Table
50 t2 CREATE TABLE `t2` (
51 `c1` binary(200) NOT NULL
52 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
53 ALTER TABLE t2 MODIFY c1 BINARY(200) NULL;
54 SHOW TABLES;
55 Tables_in_test
56 t2
57 SHOW CREATE TABLE t2;
58 Table Create Table
59 t2 CREATE TABLE `t2` (
60 `c1` binary(200) DEFAULT NULL
61 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
62 DROP TABLE t2;
63 SHOW TABLES;
64 Tables_in_test
65 CREATE TABLE t2(c1 VARBINARY(200) NOT NULL);
66 SHOW TABLES;
67 Tables_in_test
68 t2
69 SHOW CREATE TABLE t2;
70 Table Create Table
71 t2 CREATE TABLE `t2` (
72 `c1` varbinary(200) NOT NULL
73 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
74 ALTER TABLE t2 MODIFY c1 VARBINARY(200) NULL;
75 SHOW TABLES;
76 Tables_in_test
77 t2
78 SHOW CREATE TABLE t2;
79 Table Create Table
80 t2 CREATE TABLE `t2` (
81 `c1` varbinary(200) DEFAULT NULL
82 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
83 DROP TABLE t2;
84 SHOW TABLES;
85 Tables_in_test
86 CREATE TABLE t2(c1 CHAR(200) NOT NULL);
87 SHOW TABLES;
88 Tables_in_test
89 t2
90 SHOW CREATE TABLE t2;
91 Table Create Table
92 t2 CREATE TABLE `t2` (
93 `c1` char(200) NOT NULL
94 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
95 ALTER TABLE t2 CHANGE c1 c1 CHAR(200) NULL;
96 SHOW TABLES;
97 Tables_in_test
98 t2
99 SHOW CREATE TABLE t2;
100 Table Create Table
101 t2 CREATE TABLE `t2` (
102 `c1` char(200) DEFAULT NULL
103 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
104 DROP TABLE t2;
105 SHOW TABLES;
106 Tables_in_test
107 CREATE TABLE t2(c1 VARCHAR(200) NOT NULL);
108 SHOW TABLES;
109 Tables_in_test
110 t2
111 SHOW CREATE TABLE t2;
112 Table Create Table
113 t2 CREATE TABLE `t2` (
114 `c1` varchar(200) NOT NULL
115 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
116 ALTER TABLE t2 CHANGE c1 c1 VARCHAR(200) NULL;
117 SHOW TABLES;
118 Tables_in_test
119 t2
120 SHOW CREATE TABLE t2;
121 Table Create Table
122 t2 CREATE TABLE `t2` (
123 `c1` varchar(200) DEFAULT NULL
124 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
125 DROP TABLE t2;
126 SHOW TABLES;
127 Tables_in_test
128 CREATE TABLE t2(c1 BINARY(200) NOT NULL);
129 SHOW TABLES;
130 Tables_in_test
131 t2
132 SHOW CREATE TABLE t2;
133 Table Create Table
134 t2 CREATE TABLE `t2` (
135 `c1` binary(200) NOT NULL
136 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
137 ALTER TABLE t2 CHANGE c1 c1 BINARY(200) NULL;
138 SHOW TABLES;
139 Tables_in_test
140 t2
141 SHOW CREATE TABLE t2;
142 Table Create Table
143 t2 CREATE TABLE `t2` (
144 `c1` binary(200) DEFAULT NULL
145 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
146 DROP TABLE t2;
147 SHOW TABLES;
148 Tables_in_test
149 CREATE TABLE t2(c1 VARBINARY(200) NOT NULL);
150 SHOW TABLES;
151 Tables_in_test
152 t2
153 SHOW CREATE TABLE t2;
154 Table Create Table
155 t2 CREATE TABLE `t2` (
156 `c1` varbinary(200) NOT NULL
157 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
158 ALTER TABLE t2 CHANGE c1 c1 VARBINARY(200) NULL;
159 SHOW TABLES;
160 Tables_in_test
161 t2
162 SHOW CREATE TABLE t2;
163 Table Create Table
164 t2 CREATE TABLE `t2` (
165 `c1` varbinary(200) DEFAULT NULL
166 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
167 DROP TABLE t2;
168 SHOW TABLES;
169 Tables_in_test