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;