Debian Codegraph @

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

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