1 DROP TABLE IF EXISTS t1;
2 CREATE TABLE t1(c1 CHAR(100) NULL);
3 INSERT INTO t1 (c1) VALUES('NULL');
4 INSERT INTO t1 (c1) VALUES('');
5 INSERT INTO t1 (c1) VALUES('x');
6 INSERT INTO t1 (c1) VALUES('123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.');
12 123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.
13 SELECT COUNT(c1) AS total_rows FROM t1;
16 SELECT COUNT(c1) AS null_rows FROM t1 WHERE c1 IS NULL;
19 SELECT COUNT(c1) AS not_null_rows FROM t1 WHERE c1 IS NOT NULL;
23 CREATE TABLE t1(c1 VARCHAR(100) NULL);
24 INSERT INTO t1 (c1) VALUES('NULL');
25 INSERT INTO t1 (c1) VALUES('');
26 INSERT INTO t1 (c1) VALUES('x');
27 INSERT INTO t1 (c1) VALUES('123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.');
33 123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.
34 SELECT COUNT(c1) AS total_rows FROM t1;
37 SELECT COUNT(c1) AS null_rows FROM t1 WHERE c1 IS NULL;
40 SELECT COUNT(c1) AS not_null_rows FROM t1 WHERE c1 IS NOT NULL;
44 CREATE TABLE t1(c1 BINARY(100) NULL);
45 INSERT INTO t1 (c1) VALUES('NULL');
46 INSERT INTO t1 (c1) VALUES('');
47 INSERT INTO t1 (c1) VALUES('x');
48 INSERT INTO t1 (c1) VALUES('123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.');
51 NULL
\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0
52 \0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0
53 x
\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0
54 123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.
55 SELECT COUNT(c1) AS total_rows FROM t1;
58 SELECT COUNT(c1) AS null_rows FROM t1 WHERE c1 IS NULL;
61 SELECT COUNT(c1) AS not_null_rows FROM t1 WHERE c1 IS NOT NULL;
65 CREATE TABLE t1(c1 VARBINARY(100) NULL);
66 INSERT INTO t1 (c1) VALUES('NULL');
67 INSERT INTO t1 (c1) VALUES('');
68 INSERT INTO t1 (c1) VALUES('x');
69 INSERT INTO t1 (c1) VALUES('123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.');
75 123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.
76 SELECT COUNT(c1) AS total_rows FROM t1;
79 SELECT COUNT(c1) AS null_rows FROM t1 WHERE c1 IS NULL;
82 SELECT COUNT(c1) AS not_null_rows FROM t1 WHERE c1 IS NOT NULL;
86 CREATE TABLE t1(c1 BLOB(100) NULL);
87 INSERT INTO t1 (c1) VALUES('NULL');
88 INSERT INTO t1 (c1) VALUES('');
89 INSERT INTO t1 (c1) VALUES('x');
90 INSERT INTO t1 (c1) VALUES('123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.');
96 123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.
97 SELECT COUNT(c1) AS total_rows FROM t1;
100 SELECT COUNT(c1) AS null_rows FROM t1 WHERE c1 IS NULL;
103 SELECT COUNT(c1) AS not_null_rows FROM t1 WHERE c1 IS NOT NULL;
107 CREATE TABLE t1(c1 TEXT(100) NULL);
108 INSERT INTO t1 (c1) VALUES('NULL');
109 INSERT INTO t1 (c1) VALUES('');
110 INSERT INTO t1 (c1) VALUES('x');
111 INSERT INTO t1 (c1) VALUES('123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.');
117 123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.
118 SELECT COUNT(c1) AS total_rows FROM t1;
121 SELECT COUNT(c1) AS null_rows FROM t1 WHERE c1 IS NULL;
124 SELECT COUNT(c1) AS not_null_rows FROM t1 WHERE c1 IS NOT NULL;