Debian Codegraph @

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

raw
1 --disable_warnings
2 DROP TABLE IF EXISTS t6;
3 --enable_warnings
4 CREATE TABLE t6(c1 TINYINT UNSIGNED NULL);
5 INSERT INTO t6 (c1) VALUES(NULL);
6 INSERT INTO t6 (c1) VALUES(0);
7 INSERT INTO t6 (c1) VALUES(255);
8 SELECT * FROM t6;
9 SELECT COUNT(c1) AS total_rows FROM t6;
10 SELECT COUNT(c1) AS positive_rows FROM t6 WHERE c1 > 0;
11 SELECT COUNT(c1) AS null_rows FROM t6 WHERE c1 IS NULL;
12 SELECT COUNT(c1) AS not_null_rows FROM t6 WHERE c1 IS NOT NULL;
13 DROP TABLE t6;
14 CREATE TABLE t6(c1 SMALLINT UNSIGNED NULL);
15 INSERT INTO t6 (c1) VALUES(NULL);
16 INSERT INTO t6 (c1) VALUES(0);
17 INSERT INTO t6 (c1) VALUES(255);
18 SELECT * FROM t6;
19 SELECT COUNT(c1) AS total_rows FROM t6;
20 SELECT COUNT(c1) AS positive_rows FROM t6 WHERE c1 > 0;
21 SELECT COUNT(c1) AS null_rows FROM t6 WHERE c1 IS NULL;
22 SELECT COUNT(c1) AS not_null_rows FROM t6 WHERE c1 IS NOT NULL;
23 DROP TABLE t6;
24 CREATE TABLE t6(c1 MEDIUMINT UNSIGNED NULL);
25 INSERT INTO t6 (c1) VALUES(NULL);
26 INSERT INTO t6 (c1) VALUES(0);
27 INSERT INTO t6 (c1) VALUES(255);
28 SELECT * FROM t6;
29 SELECT COUNT(c1) AS total_rows FROM t6;
30 SELECT COUNT(c1) AS positive_rows FROM t6 WHERE c1 > 0;
31 SELECT COUNT(c1) AS null_rows FROM t6 WHERE c1 IS NULL;
32 SELECT COUNT(c1) AS not_null_rows FROM t6 WHERE c1 IS NOT NULL;
33 DROP TABLE t6;
34 CREATE TABLE t6(c1 INT UNSIGNED NULL);
35 INSERT INTO t6 (c1) VALUES(NULL);
36 INSERT INTO t6 (c1) VALUES(0);
37 INSERT INTO t6 (c1) VALUES(255);
38 SELECT * FROM t6;
39 SELECT COUNT(c1) AS total_rows FROM t6;
40 SELECT COUNT(c1) AS positive_rows FROM t6 WHERE c1 > 0;
41 SELECT COUNT(c1) AS null_rows FROM t6 WHERE c1 IS NULL;
42 SELECT COUNT(c1) AS not_null_rows FROM t6 WHERE c1 IS NOT NULL;
43 DROP TABLE t6;
44 CREATE TABLE t6(c1 INTEGER UNSIGNED NULL);
45 INSERT INTO t6 (c1) VALUES(NULL);
46 INSERT INTO t6 (c1) VALUES(0);
47 INSERT INTO t6 (c1) VALUES(255);
48 SELECT * FROM t6;
49 SELECT COUNT(c1) AS total_rows FROM t6;
50 SELECT COUNT(c1) AS positive_rows FROM t6 WHERE c1 > 0;
51 SELECT COUNT(c1) AS null_rows FROM t6 WHERE c1 IS NULL;
52 SELECT COUNT(c1) AS not_null_rows FROM t6 WHERE c1 IS NOT NULL;
53 DROP TABLE t6;
54 CREATE TABLE t6(c1 BIGINT UNSIGNED NULL);
55 INSERT INTO t6 (c1) VALUES(NULL);
56 INSERT INTO t6 (c1) VALUES(0);
57 INSERT INTO t6 (c1) VALUES(255);
58 SELECT * FROM t6;
59 SELECT COUNT(c1) AS total_rows FROM t6;
60 SELECT COUNT(c1) AS positive_rows FROM t6 WHERE c1 > 0;
61 SELECT COUNT(c1) AS null_rows FROM t6 WHERE c1 IS NULL;
62 SELECT COUNT(c1) AS not_null_rows FROM t6 WHERE c1 IS NOT NULL;
63 DROP TABLE t6;
64