EVOLUTION-MANAGER
Edit File: ps_string_null.result
DROP TABLE IF EXISTS t1; CREATE TABLE t1(c1 CHAR(100) NULL); PREPARE stmt1 FROM 'INSERT INTO t1 (c1) VALUES(?)'; SET @a=NULL; EXECUTE stmt1 USING @a; SET @a=''; EXECUTE stmt1 USING @a; SET @a='x'; EXECUTE stmt1 USING @a; SET @a='123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.'; EXECUTE stmt1 USING @a; DEALLOCATE PREPARE stmt1; SELECT * FROM t1; c1 NULL x 123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789. SELECT COUNT(c1) AS total_rows FROM t1; total_rows 3 SELECT COUNT(c1) AS null_rows FROM t1 WHERE c1 IS NULL; null_rows 0 SELECT COUNT(c1) AS not_null_rows FROM t1 WHERE c1 IS NOT NULL; not_null_rows 3 PREPARE stmt1 FROM 'SELECT * FROM t1 WHERE c1 = ?'; SET @a=NULL; EXECUTE stmt1 USING @a; c1 SET @a=''; EXECUTE stmt1 USING @a; c1 SET @a='x'; EXECUTE stmt1 USING @a; c1 x DEALLOCATE PREPARE stmt1; PREPARE stmt1 FROM 'UPDATE t1 SET c1 = ? WHERE c1 = ?'; SET @a=NULL; SET @b='a'; EXECUTE stmt1 USING @a,@b; SET @a=''; SET @b='b'; EXECUTE stmt1 USING @a,@b; SET @a='x'; SET @b='c'; EXECUTE stmt1 USING @a,@c; DEALLOCATE PREPARE stmt1; SELECT * FROM t1; c1 NULL x 123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789. SELECT COUNT(c1) AS total_rows FROM t1; total_rows 3 SELECT COUNT(c1) AS null_rows FROM t1 WHERE c1 IS NULL; null_rows 0 SELECT COUNT(c1) AS not_null_rows FROM t1 WHERE c1 IS NOT NULL; not_null_rows 3 PREPARE stmt1 FROM 'DELETE FROM t1 WHERE c1 = ?'; SET @a='a'; EXECUTE stmt1 USING @a; SET @a='b'; EXECUTE stmt1 USING @a; SET @a='c'; EXECUTE stmt1 USING @a; DEALLOCATE PREPARE stmt1; SELECT * FROM t1; c1 NULL x 123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789. SELECT COUNT(c1) AS total_rows FROM t1; total_rows 3 SELECT COUNT(c1) AS null_rows FROM t1 WHERE c1 IS NULL; null_rows 0 SELECT COUNT(c1) AS not_null_rows FROM t1 WHERE c1 IS NOT NULL; not_null_rows 3 DROP TABLE t1; CREATE TABLE t1(c1 VARCHAR(100) NULL); PREPARE stmt1 FROM 'INSERT INTO t1 (c1) VALUES(?)'; SET @a=NULL; EXECUTE stmt1 USING @a; SET @a=''; EXECUTE stmt1 USING @a; SET @a='x'; EXECUTE stmt1 USING @a; SET @a='123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.'; EXECUTE stmt1 USING @a; DEALLOCATE PREPARE stmt1; SELECT * FROM t1; c1 NULL x 123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789. SELECT COUNT(c1) AS total_rows FROM t1; total_rows 3 SELECT COUNT(c1) AS null_rows FROM t1 WHERE c1 IS NULL; null_rows 0 SELECT COUNT(c1) AS not_null_rows FROM t1 WHERE c1 IS NOT NULL; not_null_rows 3 PREPARE stmt1 FROM 'SELECT * FROM t1 WHERE c1 = ?'; SET @a=NULL; EXECUTE stmt1 USING @a; c1 SET @a=''; EXECUTE stmt1 USING @a; c1 SET @a='x'; EXECUTE stmt1 USING @a; c1 x DEALLOCATE PREPARE stmt1; PREPARE stmt1 FROM 'UPDATE t1 SET c1 = ? WHERE c1 = ?'; SET @a=NULL; SET @b='a'; EXECUTE stmt1 USING @a,@b; SET @a=''; SET @b='b'; EXECUTE stmt1 USING @a,@b; SET @a='x'; SET @b='c'; EXECUTE stmt1 USING @a,@c; DEALLOCATE PREPARE stmt1; SELECT * FROM t1; c1 NULL x 123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789. SELECT COUNT(c1) AS total_rows FROM t1; total_rows 3 SELECT COUNT(c1) AS null_rows FROM t1 WHERE c1 IS NULL; null_rows 0 SELECT COUNT(c1) AS not_null_rows FROM t1 WHERE c1 IS NOT NULL; not_null_rows 3 PREPARE stmt1 FROM 'DELETE FROM t1 WHERE c1 = ?'; SET @a='a'; EXECUTE stmt1 USING @a; SET @a='b'; EXECUTE stmt1 USING @a; SET @a='c'; EXECUTE stmt1 USING @a; DEALLOCATE PREPARE stmt1; SELECT * FROM t1; c1 NULL x 123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789. SELECT COUNT(c1) AS total_rows FROM t1; total_rows 3 SELECT COUNT(c1) AS null_rows FROM t1 WHERE c1 IS NULL; null_rows 0 SELECT COUNT(c1) AS not_null_rows FROM t1 WHERE c1 IS NOT NULL; not_null_rows 3 DROP TABLE t1; CREATE TABLE t1(c1 BINARY(100) NULL); PREPARE stmt1 FROM 'INSERT INTO t1 (c1) VALUES(?)'; SET @a=NULL; EXECUTE stmt1 USING @a; SET @a=''; EXECUTE stmt1 USING @a; SET @a='x'; EXECUTE stmt1 USING @a; SET @a='123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.'; EXECUTE stmt1 USING @a; DEALLOCATE PREPARE stmt1; SELECT * FROM t1; c1 NULL x 123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789. SELECT COUNT(c1) AS total_rows FROM t1; total_rows 3 SELECT COUNT(c1) AS null_rows FROM t1 WHERE c1 IS NULL; null_rows 0 SELECT COUNT(c1) AS not_null_rows FROM t1 WHERE c1 IS NOT NULL; not_null_rows 3 PREPARE stmt1 FROM 'SELECT * FROM t1 WHERE c1 = ?'; SET @a=NULL; EXECUTE stmt1 USING @a; c1 SET @a=''; EXECUTE stmt1 USING @a; c1 SET @a='x'; EXECUTE stmt1 USING @a; c1 DEALLOCATE PREPARE stmt1; PREPARE stmt1 FROM 'UPDATE t1 SET c1 = ? WHERE c1 = ?'; SET @a=NULL; SET @b='a'; EXECUTE stmt1 USING @a,@b; SET @a=''; SET @b='b'; EXECUTE stmt1 USING @a,@b; SET @a='x'; SET @b='c'; EXECUTE stmt1 USING @a,@c; DEALLOCATE PREPARE stmt1; SELECT * FROM t1; c1 NULL x 123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789. SELECT COUNT(c1) AS total_rows FROM t1; total_rows 3 SELECT COUNT(c1) AS null_rows FROM t1 WHERE c1 IS NULL; null_rows 0 SELECT COUNT(c1) AS not_null_rows FROM t1 WHERE c1 IS NOT NULL; not_null_rows 3 PREPARE stmt1 FROM 'DELETE FROM t1 WHERE c1 = ?'; SET @a='a'; EXECUTE stmt1 USING @a; SET @a='b'; EXECUTE stmt1 USING @a; SET @a='c'; EXECUTE stmt1 USING @a; DEALLOCATE PREPARE stmt1; SELECT * FROM t1; c1 NULL x 123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789. SELECT COUNT(c1) AS total_rows FROM t1; total_rows 3 SELECT COUNT(c1) AS null_rows FROM t1 WHERE c1 IS NULL; null_rows 0 SELECT COUNT(c1) AS not_null_rows FROM t1 WHERE c1 IS NOT NULL; not_null_rows 3 DROP TABLE t1; CREATE TABLE t1(c1 VARBINARY(100) NULL); PREPARE stmt1 FROM 'INSERT INTO t1 (c1) VALUES(?)'; SET @a=NULL; EXECUTE stmt1 USING @a; SET @a=''; EXECUTE stmt1 USING @a; SET @a='x'; EXECUTE stmt1 USING @a; SET @a='123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.'; EXECUTE stmt1 USING @a; DEALLOCATE PREPARE stmt1; SELECT * FROM t1; c1 NULL x 123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789. SELECT COUNT(c1) AS total_rows FROM t1; total_rows 3 SELECT COUNT(c1) AS null_rows FROM t1 WHERE c1 IS NULL; null_rows 0 SELECT COUNT(c1) AS not_null_rows FROM t1 WHERE c1 IS NOT NULL; not_null_rows 3 PREPARE stmt1 FROM 'SELECT * FROM t1 WHERE c1 = ?'; SET @a=NULL; EXECUTE stmt1 USING @a; c1 SET @a=''; EXECUTE stmt1 USING @a; c1 SET @a='x'; EXECUTE stmt1 USING @a; c1 x DEALLOCATE PREPARE stmt1; PREPARE stmt1 FROM 'UPDATE t1 SET c1 = ? WHERE c1 = ?'; SET @a=NULL; SET @b='a'; EXECUTE stmt1 USING @a,@b; SET @a=''; SET @b='b'; EXECUTE stmt1 USING @a,@b; SET @a='x'; SET @b='c'; EXECUTE stmt1 USING @a,@c; DEALLOCATE PREPARE stmt1; SELECT * FROM t1; c1 NULL x 123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789. SELECT COUNT(c1) AS total_rows FROM t1; total_rows 3 SELECT COUNT(c1) AS null_rows FROM t1 WHERE c1 IS NULL; null_rows 0 SELECT COUNT(c1) AS not_null_rows FROM t1 WHERE c1 IS NOT NULL; not_null_rows 3 PREPARE stmt1 FROM 'DELETE FROM t1 WHERE c1 = ?'; SET @a='a'; EXECUTE stmt1 USING @a; SET @a='b'; EXECUTE stmt1 USING @a; SET @a='c'; EXECUTE stmt1 USING @a; DEALLOCATE PREPARE stmt1; SELECT * FROM t1; c1 NULL x 123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789. SELECT COUNT(c1) AS total_rows FROM t1; total_rows 3 SELECT COUNT(c1) AS null_rows FROM t1 WHERE c1 IS NULL; null_rows 0 SELECT COUNT(c1) AS not_null_rows FROM t1 WHERE c1 IS NOT NULL; not_null_rows 3 DROP TABLE t1; CREATE TABLE t1(c1 BLOB(100) NULL); PREPARE stmt1 FROM 'INSERT INTO t1 (c1) VALUES(?)'; SET @a=NULL; EXECUTE stmt1 USING @a; SET @a=''; EXECUTE stmt1 USING @a; SET @a='x'; EXECUTE stmt1 USING @a; SET @a='123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.'; EXECUTE stmt1 USING @a; DEALLOCATE PREPARE stmt1; SELECT * FROM t1; c1 NULL x 123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789. SELECT COUNT(c1) AS total_rows FROM t1; total_rows 3 SELECT COUNT(c1) AS null_rows FROM t1 WHERE c1 IS NULL; null_rows 0 SELECT COUNT(c1) AS not_null_rows FROM t1 WHERE c1 IS NOT NULL; not_null_rows 3 PREPARE stmt1 FROM 'SELECT * FROM t1 WHERE c1 = ?'; SET @a=NULL; EXECUTE stmt1 USING @a; c1 SET @a=''; EXECUTE stmt1 USING @a; c1 SET @a='x'; EXECUTE stmt1 USING @a; c1 x DEALLOCATE PREPARE stmt1; PREPARE stmt1 FROM 'UPDATE t1 SET c1 = ? WHERE c1 = ?'; SET @a=NULL; SET @b='a'; EXECUTE stmt1 USING @a,@b; SET @a=''; SET @b='b'; EXECUTE stmt1 USING @a,@b; SET @a='x'; SET @b='c'; EXECUTE stmt1 USING @a,@c; DEALLOCATE PREPARE stmt1; SELECT * FROM t1; c1 NULL x 123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789. SELECT COUNT(c1) AS total_rows FROM t1; total_rows 3 SELECT COUNT(c1) AS null_rows FROM t1 WHERE c1 IS NULL; null_rows 0 SELECT COUNT(c1) AS not_null_rows FROM t1 WHERE c1 IS NOT NULL; not_null_rows 3 PREPARE stmt1 FROM 'DELETE FROM t1 WHERE c1 = ?'; SET @a='a'; EXECUTE stmt1 USING @a; SET @a='b'; EXECUTE stmt1 USING @a; SET @a='c'; EXECUTE stmt1 USING @a; DEALLOCATE PREPARE stmt1; SELECT * FROM t1; c1 NULL x 123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789. SELECT COUNT(c1) AS total_rows FROM t1; total_rows 3 SELECT COUNT(c1) AS null_rows FROM t1 WHERE c1 IS NULL; null_rows 0 SELECT COUNT(c1) AS not_null_rows FROM t1 WHERE c1 IS NOT NULL; not_null_rows 3 DROP TABLE t1; CREATE TABLE t1(c1 TEXT(100) NULL); PREPARE stmt1 FROM 'INSERT INTO t1 (c1) VALUES(?)'; SET @a=NULL; EXECUTE stmt1 USING @a; SET @a=''; EXECUTE stmt1 USING @a; SET @a='x'; EXECUTE stmt1 USING @a; SET @a='123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.'; EXECUTE stmt1 USING @a; DEALLOCATE PREPARE stmt1; SELECT * FROM t1; c1 NULL x 123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789. SELECT COUNT(c1) AS total_rows FROM t1; total_rows 3 SELECT COUNT(c1) AS null_rows FROM t1 WHERE c1 IS NULL; null_rows 0 SELECT COUNT(c1) AS not_null_rows FROM t1 WHERE c1 IS NOT NULL; not_null_rows 3 PREPARE stmt1 FROM 'SELECT * FROM t1 WHERE c1 = ?'; SET @a=NULL; EXECUTE stmt1 USING @a; c1 SET @a=''; EXECUTE stmt1 USING @a; c1 SET @a='x'; EXECUTE stmt1 USING @a; c1 x DEALLOCATE PREPARE stmt1; PREPARE stmt1 FROM 'UPDATE t1 SET c1 = ? WHERE c1 = ?'; SET @a=NULL; SET @b='a'; EXECUTE stmt1 USING @a,@b; SET @a=''; SET @b='b'; EXECUTE stmt1 USING @a,@b; SET @a='x'; SET @b='c'; EXECUTE stmt1 USING @a,@c; DEALLOCATE PREPARE stmt1; SELECT * FROM t1; c1 NULL x 123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789. SELECT COUNT(c1) AS total_rows FROM t1; total_rows 3 SELECT COUNT(c1) AS null_rows FROM t1 WHERE c1 IS NULL; null_rows 0 SELECT COUNT(c1) AS not_null_rows FROM t1 WHERE c1 IS NOT NULL; not_null_rows 3 PREPARE stmt1 FROM 'DELETE FROM t1 WHERE c1 = ?'; SET @a='a'; EXECUTE stmt1 USING @a; SET @a='b'; EXECUTE stmt1 USING @a; SET @a='c'; EXECUTE stmt1 USING @a; DEALLOCATE PREPARE stmt1; SELECT * FROM t1; c1 NULL x 123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789. SELECT COUNT(c1) AS total_rows FROM t1; total_rows 3 SELECT COUNT(c1) AS null_rows FROM t1 WHERE c1 IS NULL; null_rows 0 SELECT COUNT(c1) AS not_null_rows FROM t1 WHERE c1 IS NOT NULL; not_null_rows 3 DROP TABLE t1;