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