1
SET SQL_MODE="TRADITIONAL,ANSI";
2
DROP TABLE IF EXISTS t3;
3
CREATE TABLE t3(c1 CHAR(100) 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
INSERT INTO t3 (c1) VALUES('123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.x');
9
ERROR 22001: Data too long for column 'c1' at row 1
10
SELECT COUNT(c1) AS total_rows FROM t3;
13
SELECT COUNT(c1) AS null_rows FROM t3 WHERE c1 IS NULL;
16
SELECT COUNT(c1) AS not_null_rows FROM t3 WHERE c1 IS NOT NULL;
20
CREATE TABLE t3(c1 VARCHAR(100) NOT NULL);
21
INSERT INTO t3 (c1) VALUES(NULL);
22
ERROR 23000: Column 'c1' cannot be null
23
INSERT INTO t3 (c1) VALUES('x');
24
INSERT INTO t3 (c1) VALUES('');
25
INSERT INTO t3 (c1) VALUES('123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.x');
26
ERROR 22001: Data too long for column 'c1' at row 1
27
SELECT COUNT(c1) AS total_rows FROM t3;
30
SELECT COUNT(c1) AS null_rows FROM t3 WHERE c1 IS NULL;
33
SELECT COUNT(c1) AS not_null_rows FROM t3 WHERE c1 IS NOT NULL;
37
CREATE TABLE t3(c1 BINARY(100) NOT NULL);
38
INSERT INTO t3 (c1) VALUES(NULL);
39
ERROR 23000: Column 'c1' cannot be null
40
INSERT INTO t3 (c1) VALUES('x');
41
INSERT INTO t3 (c1) VALUES('');
42
INSERT INTO t3 (c1) VALUES('123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.x');
43
ERROR 22001: Data too long for column 'c1' at row 1
44
SELECT COUNT(c1) AS total_rows FROM t3;
47
SELECT COUNT(c1) AS null_rows FROM t3 WHERE c1 IS NULL;
50
SELECT COUNT(c1) AS not_null_rows FROM t3 WHERE c1 IS NOT NULL;
54
CREATE TABLE t3(c1 VARBINARY(100) NOT NULL);
55
INSERT INTO t3 (c1) VALUES(NULL);
56
ERROR 23000: Column 'c1' cannot be null
57
INSERT INTO t3 (c1) VALUES('x');
58
INSERT INTO t3 (c1) VALUES('');
59
INSERT INTO t3 (c1) VALUES('123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.x');
60
ERROR 22001: Data too long for column 'c1' at row 1
61
SELECT COUNT(c1) AS total_rows FROM t3;
64
SELECT COUNT(c1) AS null_rows FROM t3 WHERE c1 IS NULL;
67
SELECT COUNT(c1) AS not_null_rows FROM t3 WHERE c1 IS NOT NULL;