EVOLUTION-MANAGER

Edit File: in_string_not_null.test

--disable_warnings DROP TABLE IF EXISTS t2; --enable_warnings CREATE TABLE t2(c1 CHAR(100) NOT NULL); INSERT INTO t2 (c1) VALUES(''); INSERT INTO t2 (c1) VALUES('x'); INSERT INTO t2 (c1) VALUES('123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.'); SELECT * FROM t2; SELECT COUNT(c1) AS total_rows FROM t2; SELECT COUNT(c1) AS null_rows FROM t2 WHERE c1 IS NULL; SELECT COUNT(c1) AS not_null_rows FROM t2 WHERE c1 IS NOT NULL; DROP TABLE t2; CREATE TABLE t2(c1 VARCHAR(100) NOT NULL); INSERT INTO t2 (c1) VALUES(''); INSERT INTO t2 (c1) VALUES('x'); INSERT INTO t2 (c1) VALUES('123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.'); SELECT * FROM t2; SELECT COUNT(c1) AS total_rows FROM t2; SELECT COUNT(c1) AS null_rows FROM t2 WHERE c1 IS NULL; SELECT COUNT(c1) AS not_null_rows FROM t2 WHERE c1 IS NOT NULL; DROP TABLE t2; CREATE TABLE t2(c1 BINARY(100) NOT NULL); INSERT INTO t2 (c1) VALUES(''); INSERT INTO t2 (c1) VALUES('x'); INSERT INTO t2 (c1) VALUES('123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.'); SELECT * FROM t2; SELECT COUNT(c1) AS total_rows FROM t2; SELECT COUNT(c1) AS null_rows FROM t2 WHERE c1 IS NULL; SELECT COUNT(c1) AS not_null_rows FROM t2 WHERE c1 IS NOT NULL; DROP TABLE t2; CREATE TABLE t2(c1 VARBINARY(100) NOT NULL); INSERT INTO t2 (c1) VALUES(''); INSERT INTO t2 (c1) VALUES('x'); INSERT INTO t2 (c1) VALUES('123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.'); SELECT * FROM t2; SELECT COUNT(c1) AS total_rows FROM t2; SELECT COUNT(c1) AS null_rows FROM t2 WHERE c1 IS NULL; SELECT COUNT(c1) AS not_null_rows FROM t2 WHERE c1 IS NOT NULL; DROP TABLE t2; CREATE TABLE t2(c1 BLOB(100) NOT NULL); INSERT INTO t2 (c1) VALUES(''); INSERT INTO t2 (c1) VALUES('x'); INSERT INTO t2 (c1) VALUES('123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.'); SELECT * FROM t2; SELECT COUNT(c1) AS total_rows FROM t2; SELECT COUNT(c1) AS null_rows FROM t2 WHERE c1 IS NULL; SELECT COUNT(c1) AS not_null_rows FROM t2 WHERE c1 IS NOT NULL; DROP TABLE t2; CREATE TABLE t2(c1 TEXT(100) NOT NULL); INSERT INTO t2 (c1) VALUES(''); INSERT INTO t2 (c1) VALUES('x'); INSERT INTO t2 (c1) VALUES('123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.'); SELECT * FROM t2; SELECT COUNT(c1) AS total_rows FROM t2; SELECT COUNT(c1) AS null_rows FROM t2 WHERE c1 IS NULL; SELECT COUNT(c1) AS not_null_rows FROM t2 WHERE c1 IS NOT NULL; DROP TABLE t2;