Debian Codegraph @

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

raw
1 DROP TABLE IF EXISTS t1;
2 CREATE TABLE t1(c1 CHAR(100) NULL);
3 INSERT INTO t1 (c1) VALUES('NULL');
4 INSERT INTO t1 (c1) VALUES('');
5 INSERT INTO t1 (c1) VALUES('x');
6 INSERT INTO t1 (c1) VALUES('123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.');
7 SELECT * FROM t1;
8 c1
9 NULL
10
11 x
12 123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.
13 SELECT COUNT(c1) AS total_rows FROM t1;
14 total_rows
15 4
16 SELECT COUNT(c1) AS null_rows FROM t1 WHERE c1 IS NULL;
17 null_rows
18 0
19 SELECT COUNT(c1) AS not_null_rows FROM t1 WHERE c1 IS NOT NULL;
20 not_null_rows
21 4
22 DROP TABLE t1;
23 CREATE TABLE t1(c1 VARCHAR(100) NULL);
24 INSERT INTO t1 (c1) VALUES('NULL');
25 INSERT INTO t1 (c1) VALUES('');
26 INSERT INTO t1 (c1) VALUES('x');
27 INSERT INTO t1 (c1) VALUES('123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.');
28 SELECT * FROM t1;
29 c1
30 NULL
31
32 x
33 123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.
34 SELECT COUNT(c1) AS total_rows FROM t1;
35 total_rows
36 4
37 SELECT COUNT(c1) AS null_rows FROM t1 WHERE c1 IS NULL;
38 null_rows
39 0
40 SELECT COUNT(c1) AS not_null_rows FROM t1 WHERE c1 IS NOT NULL;
41 not_null_rows
42 4
43 DROP TABLE t1;
44 CREATE TABLE t1(c1 BINARY(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 c1
51 NULL
52
53 x
54 123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.
55 SELECT COUNT(c1) AS total_rows FROM t1;
56 total_rows
57 4
58 SELECT COUNT(c1) AS null_rows FROM t1 WHERE c1 IS NULL;
59 null_rows
60 0
61 SELECT COUNT(c1) AS not_null_rows FROM t1 WHERE c1 IS NOT NULL;
62 not_null_rows
63 4
64 DROP TABLE t1;
65 CREATE TABLE t1(c1 VARBINARY(100) NULL);
66 INSERT INTO t1 (c1) VALUES('NULL');
67 INSERT INTO t1 (c1) VALUES('');
68 INSERT INTO t1 (c1) VALUES('x');
69 INSERT INTO t1 (c1) VALUES('123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.');
70 SELECT * FROM t1;
71 c1
72 NULL
73
74 x
75 123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.
76 SELECT COUNT(c1) AS total_rows FROM t1;
77 total_rows
78 4
79 SELECT COUNT(c1) AS null_rows FROM t1 WHERE c1 IS NULL;
80 null_rows
81 0
82 SELECT COUNT(c1) AS not_null_rows FROM t1 WHERE c1 IS NOT NULL;
83 not_null_rows
84 4
85 DROP TABLE t1;
86 CREATE TABLE t1(c1 BLOB(100) NULL);
87 INSERT INTO t1 (c1) VALUES('NULL');
88 INSERT INTO t1 (c1) VALUES('');
89 INSERT INTO t1 (c1) VALUES('x');
90 INSERT INTO t1 (c1) VALUES('123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.');
91 SELECT * FROM t1;
92 c1
93 NULL
94
95 x
96 123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.
97 SELECT COUNT(c1) AS total_rows FROM t1;
98 total_rows
99 4
100 SELECT COUNT(c1) AS null_rows FROM t1 WHERE c1 IS NULL;
101 null_rows
102 0
103 SELECT COUNT(c1) AS not_null_rows FROM t1 WHERE c1 IS NOT NULL;
104 not_null_rows
105 4
106 DROP TABLE t1;
107 CREATE TABLE t1(c1 TEXT(100) NULL);
108 INSERT INTO t1 (c1) VALUES('NULL');
109 INSERT INTO t1 (c1) VALUES('');
110 INSERT INTO t1 (c1) VALUES('x');
111 INSERT INTO t1 (c1) VALUES('123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.');
112 SELECT * FROM t1;
113 c1
114 NULL
115
116 x
117 123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.
118 SELECT COUNT(c1) AS total_rows FROM t1;
119 total_rows
120 4
121 SELECT COUNT(c1) AS null_rows FROM t1 WHERE c1 IS NULL;
122 null_rows
123 0
124 SELECT COUNT(c1) AS not_null_rows FROM t1 WHERE c1 IS NOT NULL;
125 not_null_rows
126 4
127 DROP TABLE t1;