Debian Codegraph @

mysql-test/suite/engines/funcs/t/in_lob_boundary_error.test

raw
1 SET SQL_MODE="TRADITIONAL,ANSI";
2 --disable_warnings
3 DROP TABLE IF EXISTS t3;
4 --enable_warnings
5 CREATE TABLE t3(c1 TINYBLOB NOT NULL);
6 --error 1048
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;
13 DROP TABLE t3;
14 CREATE TABLE t3(c1 BLOB NOT NULL);
15 --error 1048
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;
22 DROP TABLE t3;
23 CREATE TABLE t3(c1 MEDIUMBLOB NOT NULL);
24 --error 1048
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;
31 DROP TABLE t3;
32 CREATE TABLE t3(c1 LONGBLOB NOT NULL);
33 --error 1048
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;
40 DROP TABLE t3;
41 CREATE TABLE t3(c1 TINYTEXT NOT NULL);
42 --error 1048
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;
49 DROP TABLE t3;
50 CREATE TABLE t3(c1 TEXT NOT NULL);
51 --error 1048
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;
58 DROP TABLE t3;
59 CREATE TABLE t3(c1 MEDIUMTEXT NOT NULL);
60 --error 1048
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;
67 DROP TABLE t3;
68 CREATE TABLE t3(c1 LONGTEXT NOT NULL);
69 --error 1048
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;
76 DROP TABLE t3;
77