Debian Codegraph @

mysql-test/suite/storage_engine/col_opt_not_null.test

raw
1 #
2 # NOT NULL column attribute
3 #
4
5 let $extra_col_opts = NOT NULL;
6
7 --source have_engine.inc
8
9 --echo #
10 --echo # BINARY columns
11 --echo #
12
13 --source type_binary.inc
14 --let $col_definition = BINARY $default_col_opts
15 --let $col_default = 0
16 --source col_not_null.inc
17
18 --echo #
19 --echo # VARBINARY columns
20 --echo #
21
22 --source type_varbinary.inc
23 --let $col_definition = VARBINARY(64) $default_col_opts
24 --let $col_default = 'test'
25 --source col_not_null.inc
26
27 --echo #
28 --echo # BIT columns
29 --echo #
30
31 --source type_bit.inc
32 --let $col_definition = BIT $default_col_opts
33 --let $col_default = 1
34 --source col_not_null.inc
35
36 --echo #
37 --echo # BLOB columns
38 --echo #
39
40 --source type_blob.inc
41
42 --let $col_definition = BLOB $default_col_opts
43 --source col_not_null.inc
44
45 --let $col_definition = TINYBLOB $default_col_opts
46 --source col_not_null.inc
47
48 --let $col_definition = MEDIUMBLOB $default_col_opts
49 --source col_not_null.inc
50
51 --let $col_definition = LONGBLOB $default_col_opts
52 --source col_not_null.inc
53
54 --echo #
55 --echo # BOOL columns
56 --echo #
57
58 --source type_bool.inc
59 --let $col_definition = BOOL $default_col_opts
60 --let $col_default = '0'
61 --source col_not_null.inc
62
63 --echo #
64 --echo # CHAR columns
65 --echo #
66
67 --source type_char.inc
68 --let $col_definition = CHAR $default_col_opts
69 --let $col_default = '_'
70 --source col_not_null.inc
71
72 --echo #
73 --echo # VARCHAR columns
74 --echo #
75
76 --source type_varchar.inc
77 --let $col_definition = VARCHAR(64) $default_col_opts
78 --let $col_default = 'test default'
79 --source col_not_null.inc
80
81 --echo #
82 --echo # date and time columns
83 --echo #
84
85 --source type_date_time.inc
86
87 --let $col_definition = DATE $default_col_opts
88 --let $col_default = '2012-12-21'
89 --source col_not_null.inc
90
91 --let $col_definition = DATETIME $default_col_opts
92 --let $col_default = '2012-12-21 12:21:12'
93 --source col_not_null.inc
94
95 # For TIMESTAMP the behavior is non-standard
96
97 # $col_opts already contains NOT NULL part (it's set in have_engine.inc)
98
99 let $create_definition =
100 c TIMESTAMP $col_opts,
101 c2 TIMESTAMP $col_opts DEFAULT '2012-02-21 12:21:12'
102 ;
103 --source create_table.inc
104 if ($mysql_errname)
105 {
106 --let $functionality = TIMESTAMP type or NOT NULL columns or DEFAULT
107 --source unexpected_result.inc
108 }
109 if (!$mysql_errname)
110 {
111 --let $error_codes = ER_INVALID_DEFAULT
112 --let $alter_definition = ADD COLUMN err TIMESTAMP $col_opts DEFAULT NULL
113 --source alter_table.inc
114 if ($mysql_errname!=ER_INVALID_DEFAULT)
115 {
116 --let $functionality = ALTER or DEFAULT
117 --source unexpected_result.inc
118 }
119
120 INSERT INTO t1 (c) VALUES (NULL);
121 INSERT INTO t1 (c2) VALUES (NULL);
122 --replace_regex /2012-02-21 12:21:12/<DEFAULT_TIMESTAMP>/ /[[:digit:]]{4}-[[:digit:]]{2}-[[:digit:]]{2} [[:digit:]]{2}:[[:digit:]]{2}:[[:digit:]]{2}/<TIMESTAMP>/
123 SELECT c, c2 FROM t1;
124
125 DROP TABLE t1;
126 }
127
128 --let $create_definition = c TIMESTAMP $col_opts
129 --source create_table.inc
130 if ($mysql_errname)
131 {
132 --let $functionality = TIMESTAMP type
133 --source unexpected_result.inc
134 }
135 if (!$mysql_errname)
136 {
137 SHOW COLUMNS IN t1;
138
139 INSERT INTO t1 (c) VALUES (NULL);
140 if ($mysql_errname)
141 {
142 --let $functionality = TIMESTAMP
143 --source unexpected_result.inc
144 }
145
146 --replace_regex /[[:digit:]]{4}-[[:digit:]]{2}-[[:digit:]]{2} [[:digit:]]{2}:[[:digit:]]{2}:[[:digit:]]{2}/<TIMESTAMP>/
147 SELECT c FROM t1;
148 DROP TABLE t1;
149 }
150
151 # End of TIMESTAMP exception
152
153
154 --let $col_definition = TIME $default_col_opts
155 --let $col_default = '12:21:12'
156 --source col_not_null.inc
157
158 --let $col_definition = YEAR $default_col_opts
159 --let $col_default = '2012'
160 --source col_not_null.inc
161
162 --let $col_definition = YEAR(2) $default_col_opts
163 --let $col_default = '12'
164 --source col_not_null.inc
165
166
167 --echo #
168 --echo # ENUM columns
169 --echo #
170
171 --source type_enum.inc
172
173 --let $col_definition = ENUM('test1','test2','test3') $default_col_opts
174 --let $col_default = 'test2'
175 --source col_not_null.inc
176
177
178 --echo #
179 --echo # Fixed point columns (NUMERIC, DECIMAL)
180 --echo #
181
182 --source type_fixed.inc
183
184 --let $col_definition = DECIMAL $default_col_opts
185 --let $col_default = 1.1
186 --source col_not_null.inc
187
188 --let $col_definition = NUMERIC $default_col_opts
189 --let $col_default = 0
190 --source col_not_null.inc
191
192 --echo #
193 --echo # Floating point columns (FLOAT, DOUBLE)
194 --echo #
195
196 --source type_float.inc
197
198 --let $col_definition = FLOAT $default_col_opts
199 --let $col_default = 1.1
200 --source col_not_null.inc
201
202 --let $col_definition = DOUBLE $default_col_opts
203 --let $col_default = 0
204 --source col_not_null.inc
205
206 --echo #
207 --echo # INT columns
208 --echo #
209
210 --source type_int.inc
211
212 --let $col_definition = INT $default_col_opts
213 --let $col_default = 2147483647
214 --source col_not_null.inc
215
216 --let $col_definition = TINYINT $default_col_opts
217 --let $col_default = 127
218 --source col_not_null.inc
219
220 --let $col_definition = SMALLINT $default_col_opts
221 --let $col_default = 0
222 --source col_not_null.inc
223
224 --let $col_definition = MEDIUMINT $default_col_opts
225 --let $col_default = 1
226 --source col_not_null.inc
227
228 --let $col_definition = BIGINT $default_col_opts
229 --let $col_default = 9223372036854775807
230 --source col_not_null.inc
231
232 --echo #
233 --echo # SET columns
234 --echo #
235
236 --source type_set.inc
237 --let $col_definition = SET('test1','test2','test3') $default_col_opts
238 --let $col_default = 'test2,test3'
239 --source col_not_null.inc
240
241 --echo #
242 --echo # TEXT columns
243 --echo #
244
245 --source type_text.inc
246
247 --let $col_definition = TEXT $default_col_opts
248 --source col_not_null.inc
249
250 --let $col_definition = TINYTEXT $default_col_opts
251 --source col_not_null.inc
252
253 --let $col_definition = MEDIUMTEXT $default_col_opts
254 --source col_not_null.inc
255
256 --let $col_definition = LONGTEXT $default_col_opts
257 --source col_not_null.inc
258
259 --source cleanup_engine.inc
260