Debian Codegraph @

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

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