1 SET SQL_MODE="TRADITIONAL,ANSI";
3 DROP TABLE IF EXISTS t3;
5 CREATE TABLE t3(c1 CHAR(100) NOT NULL);
7 INSERT INTO t3 (c1) VALUES(NULL);
8 INSERT INTO t3 (c1) VALUES('x');
9 INSERT INTO t3 (c1) VALUES('');
11 INSERT INTO t3 (c1) VALUES('123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.x');
12 SELECT COUNT(c1) AS total_rows FROM t3;
13 SELECT COUNT(c1) AS null_rows FROM t3 WHERE c1 IS NULL;
14 SELECT COUNT(c1) AS not_null_rows FROM t3 WHERE c1 IS NOT NULL;
16 CREATE TABLE t3(c1 VARCHAR(100) NOT NULL);
18 INSERT INTO t3 (c1) VALUES(NULL);
19 INSERT INTO t3 (c1) VALUES('x');
20 INSERT INTO t3 (c1) VALUES('');
22 INSERT INTO t3 (c1) VALUES('123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.x');
23 SELECT COUNT(c1) AS total_rows FROM t3;
24 SELECT COUNT(c1) AS null_rows FROM t3 WHERE c1 IS NULL;
25 SELECT COUNT(c1) AS not_null_rows FROM t3 WHERE c1 IS NOT NULL;
27 CREATE TABLE t3(c1 BINARY(100) NOT NULL);
29 INSERT INTO t3 (c1) VALUES(NULL);
30 INSERT INTO t3 (c1) VALUES('x');
31 INSERT INTO t3 (c1) VALUES('');
33 INSERT INTO t3 (c1) VALUES('123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.x');
34 SELECT COUNT(c1) AS total_rows FROM t3;
35 SELECT COUNT(c1) AS null_rows FROM t3 WHERE c1 IS NULL;
36 SELECT COUNT(c1) AS not_null_rows FROM t3 WHERE c1 IS NOT NULL;
38 CREATE TABLE t3(c1 VARBINARY(100) NOT NULL);
40 INSERT INTO t3 (c1) VALUES(NULL);
41 INSERT INTO t3 (c1) VALUES('x');
42 INSERT INTO t3 (c1) VALUES('');
44 INSERT INTO t3 (c1) VALUES('123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.x');
45 SELECT COUNT(c1) AS total_rows FROM t3;
46 SELECT COUNT(c1) AS null_rows FROM t3 WHERE c1 IS NULL;
47 SELECT COUNT(c1) AS not_null_rows FROM t3 WHERE c1 IS NOT NULL;