Debian Codegraph @

mysql-test/suite/engines/funcs/t/ps_string_not_null.test

raw
1 --disable_warnings
2 DROP TABLE IF EXISTS t1;
3 --enable_warnings
4 CREATE TABLE t1(c1 CHAR(100) NOT NULL);
5 PREPARE stmt1 FROM 'INSERT INTO t1 (c1) VALUES(?)';
6 SET @a='';
7 EXECUTE stmt1 USING @a;
8 SET @a='x';
9 EXECUTE stmt1 USING @a;
10 SET @a='123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.';
11 EXECUTE stmt1 USING @a;
12 DEALLOCATE PREPARE stmt1;
13 SELECT * FROM t1;
14 SELECT COUNT(c1) AS total_rows FROM t1;
15 SELECT COUNT(c1) AS null_rows FROM t1 WHERE c1 IS NULL;
16 SELECT COUNT(c1) AS not_null_rows FROM t1 WHERE c1 IS NOT NULL;
17 PREPARE stmt1 FROM 'SELECT * FROM t1 WHERE c1 = ?';
18 SET @a='';
19 EXECUTE stmt1 USING @a;
20 SET @a='x';
21 EXECUTE stmt1 USING @a;
22 DEALLOCATE PREPARE stmt1;
23 PREPARE stmt1 FROM 'UPDATE t1 SET c1 = ? WHERE c1 = ?';
24 SET @a='';
25 SET @b='b';
26 EXECUTE stmt1 USING @a,@b;
27 SET @a='x';
28 SET @b='c';
29 EXECUTE stmt1 USING @a,@c;
30 DEALLOCATE PREPARE stmt1;
31 SELECT * FROM t1;
32 SELECT COUNT(c1) AS total_rows FROM t1;
33 SELECT COUNT(c1) AS null_rows FROM t1 WHERE c1 IS NULL;
34 SELECT COUNT(c1) AS not_null_rows FROM t1 WHERE c1 IS NOT NULL;
35 PREPARE stmt1 FROM 'DELETE FROM t1 WHERE c1 = ?';
36 SET @a='a';
37 EXECUTE stmt1 USING @a;
38 SET @a='b';
39 EXECUTE stmt1 USING @a;
40 SET @a='c';
41 EXECUTE stmt1 USING @a;
42 DEALLOCATE PREPARE stmt1;
43 SELECT * FROM t1;
44 SELECT COUNT(c1) AS total_rows FROM t1;
45 SELECT COUNT(c1) AS null_rows FROM t1 WHERE c1 IS NULL;
46 SELECT COUNT(c1) AS not_null_rows FROM t1 WHERE c1 IS NOT NULL;
47 DROP TABLE t1;
48 CREATE TABLE t1(c1 VARCHAR(100) NOT NULL);
49 PREPARE stmt1 FROM 'INSERT INTO t1 (c1) VALUES(?)';
50 SET @a='';
51 EXECUTE stmt1 USING @a;
52 SET @a='x';
53 EXECUTE stmt1 USING @a;
54 SET @a='123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.';
55 EXECUTE stmt1 USING @a;
56 DEALLOCATE PREPARE stmt1;
57 SELECT * FROM t1;
58 SELECT COUNT(c1) AS total_rows FROM t1;
59 SELECT COUNT(c1) AS null_rows FROM t1 WHERE c1 IS NULL;
60 SELECT COUNT(c1) AS not_null_rows FROM t1 WHERE c1 IS NOT NULL;
61 PREPARE stmt1 FROM 'SELECT * FROM t1 WHERE c1 = ?';
62 SET @a='';
63 EXECUTE stmt1 USING @a;
64 SET @a='x';
65 EXECUTE stmt1 USING @a;
66 DEALLOCATE PREPARE stmt1;
67 PREPARE stmt1 FROM 'UPDATE t1 SET c1 = ? WHERE c1 = ?';
68 SET @a='';
69 SET @b='b';
70 EXECUTE stmt1 USING @a,@b;
71 SET @a='x';
72 SET @b='c';
73 EXECUTE stmt1 USING @a,@c;
74 DEALLOCATE PREPARE stmt1;
75 SELECT * FROM t1;
76 SELECT COUNT(c1) AS total_rows FROM t1;
77 SELECT COUNT(c1) AS null_rows FROM t1 WHERE c1 IS NULL;
78 SELECT COUNT(c1) AS not_null_rows FROM t1 WHERE c1 IS NOT NULL;
79 PREPARE stmt1 FROM 'DELETE FROM t1 WHERE c1 = ?';
80 SET @a='a';
81 EXECUTE stmt1 USING @a;
82 SET @a='b';
83 EXECUTE stmt1 USING @a;
84 SET @a='c';
85 EXECUTE stmt1 USING @a;
86 DEALLOCATE PREPARE stmt1;
87 SELECT * FROM t1;
88 SELECT COUNT(c1) AS total_rows FROM t1;
89 SELECT COUNT(c1) AS null_rows FROM t1 WHERE c1 IS NULL;
90 SELECT COUNT(c1) AS not_null_rows FROM t1 WHERE c1 IS NOT NULL;
91 DROP TABLE t1;
92 CREATE TABLE t1(c1 BINARY(100) NOT NULL);
93 PREPARE stmt1 FROM 'INSERT INTO t1 (c1) VALUES(?)';
94 SET @a='';
95 EXECUTE stmt1 USING @a;
96 SET @a='x';
97 EXECUTE stmt1 USING @a;
98 SET @a='123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.';
99 EXECUTE stmt1 USING @a;
100 DEALLOCATE PREPARE stmt1;
101 SELECT * FROM t1;
102 SELECT COUNT(c1) AS total_rows FROM t1;
103 SELECT COUNT(c1) AS null_rows FROM t1 WHERE c1 IS NULL;
104 SELECT COUNT(c1) AS not_null_rows FROM t1 WHERE c1 IS NOT NULL;
105 PREPARE stmt1 FROM 'SELECT * FROM t1 WHERE c1 = ?';
106 SET @a='';
107 EXECUTE stmt1 USING @a;
108 SET @a='x';
109 EXECUTE stmt1 USING @a;
110 DEALLOCATE PREPARE stmt1;
111 PREPARE stmt1 FROM 'UPDATE t1 SET c1 = ? WHERE c1 = ?';
112 SET @a='';
113 SET @b='b';
114 EXECUTE stmt1 USING @a,@b;
115 SET @a='x';
116 SET @b='c';
117 EXECUTE stmt1 USING @a,@c;
118 DEALLOCATE PREPARE stmt1;
119 SELECT * FROM t1;
120 SELECT COUNT(c1) AS total_rows FROM t1;
121 SELECT COUNT(c1) AS null_rows FROM t1 WHERE c1 IS NULL;
122 SELECT COUNT(c1) AS not_null_rows FROM t1 WHERE c1 IS NOT NULL;
123 PREPARE stmt1 FROM 'DELETE FROM t1 WHERE c1 = ?';
124 SET @a='a';
125 EXECUTE stmt1 USING @a;
126 SET @a='b';
127 EXECUTE stmt1 USING @a;
128 SET @a='c';
129 EXECUTE stmt1 USING @a;
130 DEALLOCATE PREPARE stmt1;
131 SELECT * FROM t1;
132 SELECT COUNT(c1) AS total_rows FROM t1;
133 SELECT COUNT(c1) AS null_rows FROM t1 WHERE c1 IS NULL;
134 SELECT COUNT(c1) AS not_null_rows FROM t1 WHERE c1 IS NOT NULL;
135 DROP TABLE t1;
136 CREATE TABLE t1(c1 VARBINARY(100) NOT NULL);
137 PREPARE stmt1 FROM 'INSERT INTO t1 (c1) VALUES(?)';
138 SET @a='';
139 EXECUTE stmt1 USING @a;
140 SET @a='x';
141 EXECUTE stmt1 USING @a;
142 SET @a='123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.';
143 EXECUTE stmt1 USING @a;
144 DEALLOCATE PREPARE stmt1;
145 SELECT * FROM t1;
146 SELECT COUNT(c1) AS total_rows FROM t1;
147 SELECT COUNT(c1) AS null_rows FROM t1 WHERE c1 IS NULL;
148 SELECT COUNT(c1) AS not_null_rows FROM t1 WHERE c1 IS NOT NULL;
149 PREPARE stmt1 FROM 'SELECT * FROM t1 WHERE c1 = ?';
150 SET @a='';
151 EXECUTE stmt1 USING @a;
152 SET @a='x';
153 EXECUTE stmt1 USING @a;
154 DEALLOCATE PREPARE stmt1;
155 PREPARE stmt1 FROM 'UPDATE t1 SET c1 = ? WHERE c1 = ?';
156 SET @a='';
157 SET @b='b';
158 EXECUTE stmt1 USING @a,@b;
159 SET @a='x';
160 SET @b='c';
161 EXECUTE stmt1 USING @a,@c;
162 DEALLOCATE PREPARE stmt1;
163 SELECT * FROM t1;
164 SELECT COUNT(c1) AS total_rows FROM t1;
165 SELECT COUNT(c1) AS null_rows FROM t1 WHERE c1 IS NULL;
166 SELECT COUNT(c1) AS not_null_rows FROM t1 WHERE c1 IS NOT NULL;
167 PREPARE stmt1 FROM 'DELETE FROM t1 WHERE c1 = ?';
168 SET @a='a';
169 EXECUTE stmt1 USING @a;
170 SET @a='b';
171 EXECUTE stmt1 USING @a;
172 SET @a='c';
173 EXECUTE stmt1 USING @a;
174 DEALLOCATE PREPARE stmt1;
175 SELECT * FROM t1;
176 SELECT COUNT(c1) AS total_rows FROM t1;
177 SELECT COUNT(c1) AS null_rows FROM t1 WHERE c1 IS NULL;
178 SELECT COUNT(c1) AS not_null_rows FROM t1 WHERE c1 IS NOT NULL;
179 DROP TABLE t1;
180 CREATE TABLE t1(c1 BLOB(100) NOT NULL);
181 PREPARE stmt1 FROM 'INSERT INTO t1 (c1) VALUES(?)';
182 SET @a='';
183 EXECUTE stmt1 USING @a;
184 SET @a='x';
185 EXECUTE stmt1 USING @a;
186 SET @a='123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.';
187 EXECUTE stmt1 USING @a;
188 DEALLOCATE PREPARE stmt1;
189 SELECT * FROM t1;
190 SELECT COUNT(c1) AS total_rows FROM t1;
191 SELECT COUNT(c1) AS null_rows FROM t1 WHERE c1 IS NULL;
192 SELECT COUNT(c1) AS not_null_rows FROM t1 WHERE c1 IS NOT NULL;
193 PREPARE stmt1 FROM 'SELECT * FROM t1 WHERE c1 = ?';
194 SET @a='';
195 EXECUTE stmt1 USING @a;
196 SET @a='x';
197 EXECUTE stmt1 USING @a;
198 DEALLOCATE PREPARE stmt1;
199 PREPARE stmt1 FROM 'UPDATE t1 SET c1 = ? WHERE c1 = ?';
200 SET @a='';
201 SET @b='b';
202 EXECUTE stmt1 USING @a,@b;
203 SET @a='x';
204 SET @b='c';
205 EXECUTE stmt1 USING @a,@c;
206 DEALLOCATE PREPARE stmt1;
207 SELECT * FROM t1;
208 SELECT COUNT(c1) AS total_rows FROM t1;
209 SELECT COUNT(c1) AS null_rows FROM t1 WHERE c1 IS NULL;
210 SELECT COUNT(c1) AS not_null_rows FROM t1 WHERE c1 IS NOT NULL;
211 PREPARE stmt1 FROM 'DELETE FROM t1 WHERE c1 = ?';
212 SET @a='a';
213 EXECUTE stmt1 USING @a;
214 SET @a='b';
215 EXECUTE stmt1 USING @a;
216 SET @a='c';
217 EXECUTE stmt1 USING @a;
218 DEALLOCATE PREPARE stmt1;
219 SELECT * FROM t1;
220 SELECT COUNT(c1) AS total_rows FROM t1;
221 SELECT COUNT(c1) AS null_rows FROM t1 WHERE c1 IS NULL;
222 SELECT COUNT(c1) AS not_null_rows FROM t1 WHERE c1 IS NOT NULL;
223 DROP TABLE t1;
224 CREATE TABLE t1(c1 TEXT(100) NOT NULL);
225 PREPARE stmt1 FROM 'INSERT INTO t1 (c1) VALUES(?)';
226 SET @a='';
227 EXECUTE stmt1 USING @a;
228 SET @a='x';
229 EXECUTE stmt1 USING @a;
230 SET @a='123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.';
231 EXECUTE stmt1 USING @a;
232 DEALLOCATE PREPARE stmt1;
233 SELECT * FROM t1;
234 SELECT COUNT(c1) AS total_rows FROM t1;
235 SELECT COUNT(c1) AS null_rows FROM t1 WHERE c1 IS NULL;
236 SELECT COUNT(c1) AS not_null_rows FROM t1 WHERE c1 IS NOT NULL;
237 PREPARE stmt1 FROM 'SELECT * FROM t1 WHERE c1 = ?';
238 SET @a='';
239 EXECUTE stmt1 USING @a;
240 SET @a='x';
241 EXECUTE stmt1 USING @a;
242 DEALLOCATE PREPARE stmt1;
243 PREPARE stmt1 FROM 'UPDATE t1 SET c1 = ? WHERE c1 = ?';
244 SET @a='';
245 SET @b='b';
246 EXECUTE stmt1 USING @a,@b;
247 SET @a='x';
248 SET @b='c';
249 EXECUTE stmt1 USING @a,@c;
250 DEALLOCATE PREPARE stmt1;
251 SELECT * FROM t1;
252 SELECT COUNT(c1) AS total_rows FROM t1;
253 SELECT COUNT(c1) AS null_rows FROM t1 WHERE c1 IS NULL;
254 SELECT COUNT(c1) AS not_null_rows FROM t1 WHERE c1 IS NOT NULL;
255 PREPARE stmt1 FROM 'DELETE FROM t1 WHERE c1 = ?';
256 SET @a='a';
257 EXECUTE stmt1 USING @a;
258 SET @a='b';
259 EXECUTE stmt1 USING @a;
260 SET @a='c';
261 EXECUTE stmt1 USING @a;
262 DEALLOCATE PREPARE stmt1;
263 SELECT * FROM t1;
264 SELECT COUNT(c1) AS total_rows FROM t1;
265 SELECT COUNT(c1) AS null_rows FROM t1 WHERE c1 IS NULL;
266 SELECT COUNT(c1) AS not_null_rows FROM t1 WHERE c1 IS NOT NULL;
267 DROP TABLE t1;
268