Debian Codegraph @

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

raw
1 --disable_warnings
2 DROP TABLE IF EXISTS t1;
3 --enable_warnings
4 CREATE TABLE t1(c1 CHAR(100) NULL);
5 INSERT INTO t1 (c1) VALUES('NULL');
6 INSERT INTO t1 (c1) VALUES('');
7 INSERT INTO t1 (c1) VALUES('x');
8 INSERT INTO t1 (c1) VALUES('123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.');
9 SELECT * FROM t1;
10 SELECT COUNT(c1) AS total_rows FROM t1;
11 SELECT COUNT(c1) AS null_rows FROM t1 WHERE c1 IS NULL;
12 SELECT COUNT(c1) AS not_null_rows FROM t1 WHERE c1 IS NOT NULL;
13 DROP TABLE t1;
14 CREATE TABLE t1(c1 VARCHAR(100) NULL);
15 INSERT INTO t1 (c1) VALUES('NULL');
16 INSERT INTO t1 (c1) VALUES('');
17 INSERT INTO t1 (c1) VALUES('x');
18 INSERT INTO t1 (c1) VALUES('123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.');
19 SELECT * FROM t1;
20 SELECT COUNT(c1) AS total_rows FROM t1;
21 SELECT COUNT(c1) AS null_rows FROM t1 WHERE c1 IS NULL;
22 SELECT COUNT(c1) AS not_null_rows FROM t1 WHERE c1 IS NOT NULL;
23 DROP TABLE t1;
24 CREATE TABLE t1(c1 BINARY(100) NULL);
25 INSERT INTO t1 (c1) VALUES('NULL');
26 INSERT INTO t1 (c1) VALUES('');
27 INSERT INTO t1 (c1) VALUES('x');
28 INSERT INTO t1 (c1) VALUES('123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.');
29 SELECT * FROM t1;
30 SELECT COUNT(c1) AS total_rows FROM t1;
31 SELECT COUNT(c1) AS null_rows FROM t1 WHERE c1 IS NULL;
32 SELECT COUNT(c1) AS not_null_rows FROM t1 WHERE c1 IS NOT NULL;
33 DROP TABLE t1;
34 CREATE TABLE t1(c1 VARBINARY(100) NULL);
35 INSERT INTO t1 (c1) VALUES('NULL');
36 INSERT INTO t1 (c1) VALUES('');
37 INSERT INTO t1 (c1) VALUES('x');
38 INSERT INTO t1 (c1) VALUES('123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.');
39 SELECT * FROM t1;
40 SELECT COUNT(c1) AS total_rows FROM t1;
41 SELECT COUNT(c1) AS null_rows FROM t1 WHERE c1 IS NULL;
42 SELECT COUNT(c1) AS not_null_rows FROM t1 WHERE c1 IS NOT NULL;
43 DROP TABLE t1;
44 CREATE TABLE t1(c1 BLOB(100) NULL);
45 INSERT INTO t1 (c1) VALUES('NULL');
46 INSERT INTO t1 (c1) VALUES('');
47 INSERT INTO t1 (c1) VALUES('x');
48 INSERT INTO t1 (c1) VALUES('123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.');
49 SELECT * FROM t1;
50 SELECT COUNT(c1) AS total_rows FROM t1;
51 SELECT COUNT(c1) AS null_rows FROM t1 WHERE c1 IS NULL;
52 SELECT COUNT(c1) AS not_null_rows FROM t1 WHERE c1 IS NOT NULL;
53 DROP TABLE t1;
54 CREATE TABLE t1(c1 TEXT(100) NULL);
55 INSERT INTO t1 (c1) VALUES('NULL');
56 INSERT INTO t1 (c1) VALUES('');
57 INSERT INTO t1 (c1) VALUES('x');
58 INSERT INTO t1 (c1) VALUES('123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.');
59 SELECT * FROM t1;
60 SELECT COUNT(c1) AS total_rows FROM t1;
61 SELECT COUNT(c1) AS null_rows FROM t1 WHERE c1 IS NULL;
62 SELECT COUNT(c1) AS not_null_rows FROM t1 WHERE c1 IS NOT NULL;
63 DROP TABLE t1;
64