1
SET SQL_MODE="TRADITIONAL,ANSI";
3
DROP TABLE IF EXISTS t3;
5
CREATE TABLE t3(c1 TINYBLOB NOT NULL);
7
INSERT INTO t3 (c1) VALUES(NULL);
8
INSERT INTO t3 (c1) VALUES('x');
9
INSERT INTO t3 (c1) VALUES('');
10
SELECT COUNT(c1) AS total_rows FROM t3;
11
SELECT COUNT(c1) AS null_rows FROM t3 WHERE c1 IS NULL;
12
SELECT COUNT(c1) AS not_null_rows FROM t3 WHERE c1 IS NOT NULL;
14
CREATE TABLE t3(c1 BLOB NOT NULL);
16
INSERT INTO t3 (c1) VALUES(NULL);
17
INSERT INTO t3 (c1) VALUES('x');
18
INSERT INTO t3 (c1) VALUES('');
19
SELECT COUNT(c1) AS total_rows FROM t3;
20
SELECT COUNT(c1) AS null_rows FROM t3 WHERE c1 IS NULL;
21
SELECT COUNT(c1) AS not_null_rows FROM t3 WHERE c1 IS NOT NULL;
23
CREATE TABLE t3(c1 MEDIUMBLOB NOT NULL);
25
INSERT INTO t3 (c1) VALUES(NULL);
26
INSERT INTO t3 (c1) VALUES('x');
27
INSERT INTO t3 (c1) VALUES('');
28
SELECT COUNT(c1) AS total_rows FROM t3;
29
SELECT COUNT(c1) AS null_rows FROM t3 WHERE c1 IS NULL;
30
SELECT COUNT(c1) AS not_null_rows FROM t3 WHERE c1 IS NOT NULL;
32
CREATE TABLE t3(c1 LONGBLOB NOT NULL);
34
INSERT INTO t3 (c1) VALUES(NULL);
35
INSERT INTO t3 (c1) VALUES('x');
36
INSERT INTO t3 (c1) VALUES('');
37
SELECT COUNT(c1) AS total_rows FROM t3;
38
SELECT COUNT(c1) AS null_rows FROM t3 WHERE c1 IS NULL;
39
SELECT COUNT(c1) AS not_null_rows FROM t3 WHERE c1 IS NOT NULL;
41
CREATE TABLE t3(c1 TINYTEXT NOT NULL);
43
INSERT INTO t3 (c1) VALUES(NULL);
44
INSERT INTO t3 (c1) VALUES('x');
45
INSERT INTO t3 (c1) VALUES('');
46
SELECT COUNT(c1) AS total_rows FROM t3;
47
SELECT COUNT(c1) AS null_rows FROM t3 WHERE c1 IS NULL;
48
SELECT COUNT(c1) AS not_null_rows FROM t3 WHERE c1 IS NOT NULL;
50
CREATE TABLE t3(c1 TEXT NOT NULL);
52
INSERT INTO t3 (c1) VALUES(NULL);
53
INSERT INTO t3 (c1) VALUES('x');
54
INSERT INTO t3 (c1) VALUES('');
55
SELECT COUNT(c1) AS total_rows FROM t3;
56
SELECT COUNT(c1) AS null_rows FROM t3 WHERE c1 IS NULL;
57
SELECT COUNT(c1) AS not_null_rows FROM t3 WHERE c1 IS NOT NULL;
59
CREATE TABLE t3(c1 MEDIUMTEXT NOT NULL);
61
INSERT INTO t3 (c1) VALUES(NULL);
62
INSERT INTO t3 (c1) VALUES('x');
63
INSERT INTO t3 (c1) VALUES('');
64
SELECT COUNT(c1) AS total_rows FROM t3;
65
SELECT COUNT(c1) AS null_rows FROM t3 WHERE c1 IS NULL;
66
SELECT COUNT(c1) AS not_null_rows FROM t3 WHERE c1 IS NOT NULL;
68
CREATE TABLE t3(c1 LONGTEXT NOT NULL);
70
INSERT INTO t3 (c1) VALUES(NULL);
71
INSERT INTO t3 (c1) VALUES('x');
72
INSERT INTO t3 (c1) VALUES('');
73
SELECT COUNT(c1) AS total_rows FROM t3;
74
SELECT COUNT(c1) AS null_rows FROM t3 WHERE c1 IS NULL;
75
SELECT COUNT(c1) AS not_null_rows FROM t3 WHERE c1 IS NOT NULL;