Edit File: in_string_null.result
DROP TABLE IF EXISTS t1; CREATE TABLE t1(c1 CHAR(100) NULL); INSERT INTO t1 (c1) VALUES('NULL'); INSERT INTO t1 (c1) VALUES(''); INSERT INTO t1 (c1) VALUES('x'); INSERT INTO t1 (c1) VALUES('123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.'); 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 4 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 4 DROP TABLE t1; CREATE TABLE t1(c1 VARCHAR(100) NULL); INSERT INTO t1 (c1) VALUES('NULL'); INSERT INTO t1 (c1) VALUES(''); INSERT INTO t1 (c1) VALUES('x'); INSERT INTO t1 (c1) VALUES('123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.'); 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 4 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 4 DROP TABLE t1; CREATE TABLE t1(c1 BINARY(100) NULL); INSERT INTO t1 (c1) VALUES('NULL'); INSERT INTO t1 (c1) VALUES(''); INSERT INTO t1 (c1) VALUES('x'); INSERT INTO t1 (c1) VALUES('123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.'); 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 4 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 4 DROP TABLE t1; CREATE TABLE t1(c1 VARBINARY(100) NULL); INSERT INTO t1 (c1) VALUES('NULL'); INSERT INTO t1 (c1) VALUES(''); INSERT INTO t1 (c1) VALUES('x'); INSERT INTO t1 (c1) VALUES('123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.'); 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 4 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 4 DROP TABLE t1; CREATE TABLE t1(c1 BLOB(100) NULL); INSERT INTO t1 (c1) VALUES('NULL'); INSERT INTO t1 (c1) VALUES(''); INSERT INTO t1 (c1) VALUES('x'); INSERT INTO t1 (c1) VALUES('123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.'); 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 4 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 4 DROP TABLE t1; CREATE TABLE t1(c1 TEXT(100) NULL); INSERT INTO t1 (c1) VALUES('NULL'); INSERT INTO t1 (c1) VALUES(''); INSERT INTO t1 (c1) VALUES('x'); INSERT INTO t1 (c1) VALUES('123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.'); 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 4 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 4 DROP TABLE t1;