1
SET SQL_MODE="TRADITIONAL,ANSI";
2
DROP TABLE IF EXISTS t3;
3
CREATE TABLE t3(c1 TINYBLOB NOT NULL);
4
INSERT INTO t3 (c1) VALUES(NULL);
5
ERROR 23000: Column 'c1' cannot be null
6
INSERT INTO t3 (c1) VALUES('x');
7
INSERT INTO t3 (c1) VALUES('');
8
SELECT COUNT(c1) AS total_rows FROM t3;
11
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;
18
CREATE TABLE t3(c1 BLOB NOT NULL);
19
INSERT INTO t3 (c1) VALUES(NULL);
20
ERROR 23000: Column 'c1' cannot be null
21
INSERT INTO t3 (c1) VALUES('x');
22
INSERT INTO t3 (c1) VALUES('');
23
SELECT COUNT(c1) AS total_rows FROM t3;
26
SELECT COUNT(c1) AS null_rows FROM t3 WHERE c1 IS NULL;
29
SELECT COUNT(c1) AS not_null_rows FROM t3 WHERE c1 IS NOT NULL;
33
CREATE TABLE t3(c1 MEDIUMBLOB NOT NULL);
34
INSERT INTO t3 (c1) VALUES(NULL);
35
ERROR 23000: Column 'c1' cannot be null
36
INSERT INTO t3 (c1) VALUES('x');
37
INSERT INTO t3 (c1) VALUES('');
38
SELECT COUNT(c1) AS total_rows FROM t3;
41
SELECT COUNT(c1) AS null_rows FROM t3 WHERE c1 IS NULL;
44
SELECT COUNT(c1) AS not_null_rows FROM t3 WHERE c1 IS NOT NULL;
48
CREATE TABLE t3(c1 LONGBLOB NOT NULL);
49
INSERT INTO t3 (c1) VALUES(NULL);
50
ERROR 23000: Column 'c1' cannot be null
51
INSERT INTO t3 (c1) VALUES('x');
52
INSERT INTO t3 (c1) VALUES('');
53
SELECT COUNT(c1) AS total_rows FROM t3;
56
SELECT COUNT(c1) AS null_rows FROM t3 WHERE c1 IS NULL;
59
SELECT COUNT(c1) AS not_null_rows FROM t3 WHERE c1 IS NOT NULL;
63
CREATE TABLE t3(c1 TINYTEXT NOT NULL);
64
INSERT INTO t3 (c1) VALUES(NULL);
65
ERROR 23000: Column 'c1' cannot be null
66
INSERT INTO t3 (c1) VALUES('x');
67
INSERT INTO t3 (c1) VALUES('');
68
SELECT COUNT(c1) AS total_rows FROM t3;
71
SELECT COUNT(c1) AS null_rows FROM t3 WHERE c1 IS NULL;
74
SELECT COUNT(c1) AS not_null_rows FROM t3 WHERE c1 IS NOT NULL;
78
CREATE TABLE t3(c1 TEXT NOT NULL);
79
INSERT INTO t3 (c1) VALUES(NULL);
80
ERROR 23000: Column 'c1' cannot be null
81
INSERT INTO t3 (c1) VALUES('x');
82
INSERT INTO t3 (c1) VALUES('');
83
SELECT COUNT(c1) AS total_rows FROM t3;
86
SELECT COUNT(c1) AS null_rows FROM t3 WHERE c1 IS NULL;
89
SELECT COUNT(c1) AS not_null_rows FROM t3 WHERE c1 IS NOT NULL;
93
CREATE TABLE t3(c1 MEDIUMTEXT NOT NULL);
94
INSERT INTO t3 (c1) VALUES(NULL);
95
ERROR 23000: Column 'c1' cannot be null
96
INSERT INTO t3 (c1) VALUES('x');
97
INSERT INTO t3 (c1) VALUES('');
98
SELECT COUNT(c1) AS total_rows FROM t3;
101
SELECT COUNT(c1) AS null_rows FROM t3 WHERE c1 IS NULL;
104
SELECT COUNT(c1) AS not_null_rows FROM t3 WHERE c1 IS NOT NULL;
108
CREATE TABLE t3(c1 LONGTEXT NOT NULL);
109
INSERT INTO t3 (c1) VALUES(NULL);
110
ERROR 23000: Column 'c1' cannot be null
111
INSERT INTO t3 (c1) VALUES('x');
112
INSERT INTO t3 (c1) VALUES('');
113
SELECT COUNT(c1) AS total_rows FROM t3;
116
SELECT COUNT(c1) AS null_rows FROM t3 WHERE c1 IS NULL;
119
SELECT COUNT(c1) AS not_null_rows FROM t3 WHERE c1 IS NOT NULL;