Debian Codegraph @

mysql-test/suite/engines/funcs/r/in_lob_boundary_error.result

raw
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;
9 total_rows
10 2
11 SELECT COUNT(c1) AS null_rows FROM t3 WHERE c1 IS NULL;
12 null_rows
13 0
14 SELECT COUNT(c1) AS not_null_rows FROM t3 WHERE c1 IS NOT NULL;
15 not_null_rows
16 2
17 DROP TABLE t3;
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;
24 total_rows
25 2
26 SELECT COUNT(c1) AS null_rows FROM t3 WHERE c1 IS NULL;
27 null_rows
28 0
29 SELECT COUNT(c1) AS not_null_rows FROM t3 WHERE c1 IS NOT NULL;
30 not_null_rows
31 2
32 DROP TABLE t3;
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;
39 total_rows
40 2
41 SELECT COUNT(c1) AS null_rows FROM t3 WHERE c1 IS NULL;
42 null_rows
43 0
44 SELECT COUNT(c1) AS not_null_rows FROM t3 WHERE c1 IS NOT NULL;
45 not_null_rows
46 2
47 DROP TABLE t3;
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;
54 total_rows
55 2
56 SELECT COUNT(c1) AS null_rows FROM t3 WHERE c1 IS NULL;
57 null_rows
58 0
59 SELECT COUNT(c1) AS not_null_rows FROM t3 WHERE c1 IS NOT NULL;
60 not_null_rows
61 2
62 DROP TABLE t3;
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;
69 total_rows
70 2
71 SELECT COUNT(c1) AS null_rows FROM t3 WHERE c1 IS NULL;
72 null_rows
73 0
74 SELECT COUNT(c1) AS not_null_rows FROM t3 WHERE c1 IS NOT NULL;
75 not_null_rows
76 2
77 DROP TABLE t3;
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;
84 total_rows
85 2
86 SELECT COUNT(c1) AS null_rows FROM t3 WHERE c1 IS NULL;
87 null_rows
88 0
89 SELECT COUNT(c1) AS not_null_rows FROM t3 WHERE c1 IS NOT NULL;
90 not_null_rows
91 2
92 DROP TABLE t3;
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;
99 total_rows
100 2
101 SELECT COUNT(c1) AS null_rows FROM t3 WHERE c1 IS NULL;
102 null_rows
103 0
104 SELECT COUNT(c1) AS not_null_rows FROM t3 WHERE c1 IS NOT NULL;
105 not_null_rows
106 2
107 DROP TABLE t3;
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;
114 total_rows
115 2
116 SELECT COUNT(c1) AS null_rows FROM t3 WHERE c1 IS NULL;
117 null_rows
118 0
119 SELECT COUNT(c1) AS not_null_rows FROM t3 WHERE c1 IS NOT NULL;
120 not_null_rows
121 2
122 DROP TABLE t3;