funcs/r/ta_string_to_null.result

1 DROP TABLE IF EXISTS t2;
2 CREATE TABLE t2(c1 CHAR(200) NOT NULL);
5 t2
6 SHOW CREATE TABLE t2;
8 t2	CREATE TABLE `t2` (
11 ALTER TABLE t2 MODIFY c1 CHAR(200) NULL;
14 t2
15 SHOW CREATE TABLE t2;
17 t2	CREATE TABLE `t2` (
20 DROP TABLE t2;
23 CREATE TABLE t2(c1 VARCHAR(200) NOT NULL);
26 t2
27 SHOW CREATE TABLE t2;
29 t2	CREATE TABLE `t2` (
32 ALTER TABLE t2 MODIFY c1 VARCHAR(200) NULL;
35 t2
36 SHOW CREATE TABLE t2;
38 t2	CREATE TABLE `t2` (
41 DROP TABLE t2;
44 CREATE TABLE t2(c1 BINARY(200) NOT NULL);
47 t2
48 SHOW CREATE TABLE t2;
50 t2	CREATE TABLE `t2` (
53 ALTER TABLE t2 MODIFY c1 BINARY(200) NULL;
56 t2
57 SHOW CREATE TABLE t2;
59 t2	CREATE TABLE `t2` (
62 DROP TABLE t2;
65 CREATE TABLE t2(c1 VARBINARY(200) NOT NULL);
68 t2
69 SHOW CREATE TABLE t2;
71 t2	CREATE TABLE `t2` (
74 ALTER TABLE t2 MODIFY c1 VARBINARY(200) NULL;
77 t2
78 SHOW CREATE TABLE t2;
80 t2	CREATE TABLE `t2` (
83 DROP TABLE t2;
86 CREATE TABLE t2(c1 CHAR(200) NOT NULL);
89 t2
90 SHOW CREATE TABLE t2;
92 t2	CREATE TABLE `t2` (
95 ALTER TABLE t2 CHANGE c1 c1 CHAR(200) NULL;
98 t2
99 SHOW CREATE TABLE t2;
101 t2	CREATE TABLE `t2` (
104 DROP TABLE t2;
107 CREATE TABLE t2(c1 VARCHAR(200) NOT NULL);
110 t2
111 SHOW CREATE TABLE t2;
113 t2	CREATE TABLE `t2` (
116 ALTER TABLE t2 CHANGE c1 c1 VARCHAR(200) NULL;
119 t2
120 SHOW CREATE TABLE t2;
122 t2	CREATE TABLE `t2` (
125 DROP TABLE t2;
128 CREATE TABLE t2(c1 BINARY(200) NOT NULL);
131 t2
132 SHOW CREATE TABLE t2;
134 t2	CREATE TABLE `t2` (
137 ALTER TABLE t2 CHANGE c1 c1 BINARY(200) NULL;
140 t2
141 SHOW CREATE TABLE t2;
143 t2	CREATE TABLE `t2` (
146 DROP TABLE t2;
149 CREATE TABLE t2(c1 VARBINARY(200) NOT NULL);
152 t2
153 SHOW CREATE TABLE t2;
155 t2	CREATE TABLE `t2` (
158 ALTER TABLE t2 CHANGE c1 c1 VARBINARY(200) NULL;
161 t2
162 SHOW CREATE TABLE t2;
164 t2	CREATE TABLE `t2` (
167 DROP TABLE t2;