Debian Codegraph @

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

raw
1 --disable_warnings
2 DROP TABLE IF EXISTS t4,t5;
3 --enable_warnings
4 CREATE TABLE t4(c1 DECIMAL(1,0) NOT NULL);
5 INSERT INTO t4 (c1) VALUES(0);
6 INSERT INTO t4 (c1) VALUES(1.0);
7 INSERT INTO t4 (c1) VALUES(-9.0);
8 SELECT * FROM t4;
9 SELECT COUNT(c1) AS total_rows FROM t4;
10 SELECT COUNT(c1) AS positive_rows FROM t4 WHERE c1 > 0.0;
11 SELECT COUNT(c1) AS negative_rows FROM t4 WHERE c1 < 0.0;
12 SELECT COUNT(c1) AS zero_rows FROM t4 WHERE c1 = 0.0;
13 DROP TABLE t4;
14 CREATE TABLE t5(c1 DECIMAL(5,4) NOT NULL);
15 INSERT INTO t5 (c1) VALUES(0);
16 INSERT INTO t5 (c1) VALUES(1.0);
17 INSERT INTO t5 (c1) VALUES(1.2345);
18 INSERT INTO t5 (c1) VALUES(-9.0);
19 INSERT INTO t5 (c1) VALUES(-9.12345);
20 SELECT * FROM t5;
21 SELECT COUNT(c1) AS positive_rows FROM t5 WHERE c1 > 0.0;
22 SELECT COUNT(c1) AS negative_rows FROM t5 WHERE c1 < 0.0;
23 SELECT COUNT(c1) AS zero_rows FROM t5 WHERE c1 = 0.0;
24 DROP TABLE t5;
25 CREATE TABLE t4(c1 DEC(1,0) NOT NULL);
26 INSERT INTO t4 (c1) VALUES(0);
27 INSERT INTO t4 (c1) VALUES(1.0);
28 INSERT INTO t4 (c1) VALUES(-9.0);
29 SELECT * FROM t4;
30 SELECT COUNT(c1) AS total_rows FROM t4;
31 SELECT COUNT(c1) AS positive_rows FROM t4 WHERE c1 > 0.0;
32 SELECT COUNT(c1) AS negative_rows FROM t4 WHERE c1 < 0.0;
33 SELECT COUNT(c1) AS zero_rows FROM t4 WHERE c1 = 0.0;
34 DROP TABLE t4;
35 CREATE TABLE t5(c1 DEC(5,4) NOT NULL);
36 INSERT INTO t5 (c1) VALUES(0);
37 INSERT INTO t5 (c1) VALUES(1.0);
38 INSERT INTO t5 (c1) VALUES(1.2345);
39 INSERT INTO t5 (c1) VALUES(-9.0);
40 INSERT INTO t5 (c1) VALUES(-9.12345);
41 SELECT * FROM t5;
42 SELECT COUNT(c1) AS positive_rows FROM t5 WHERE c1 > 0.0;
43 SELECT COUNT(c1) AS negative_rows FROM t5 WHERE c1 < 0.0;
44 SELECT COUNT(c1) AS zero_rows FROM t5 WHERE c1 = 0.0;
45 DROP TABLE t5;
46 CREATE TABLE t4(c1 FIXED(1,0) NOT NULL);
47 INSERT INTO t4 (c1) VALUES(0);
48 INSERT INTO t4 (c1) VALUES(1.0);
49 INSERT INTO t4 (c1) VALUES(-9.0);
50 SELECT * FROM t4;
51 SELECT COUNT(c1) AS total_rows FROM t4;
52 SELECT COUNT(c1) AS positive_rows FROM t4 WHERE c1 > 0.0;
53 SELECT COUNT(c1) AS negative_rows FROM t4 WHERE c1 < 0.0;
54 SELECT COUNT(c1) AS zero_rows FROM t4 WHERE c1 = 0.0;
55 DROP TABLE t4;
56 CREATE TABLE t5(c1 FIXED(5,4) NOT NULL);
57 INSERT INTO t5 (c1) VALUES(0);
58 INSERT INTO t5 (c1) VALUES(1.0);
59 INSERT INTO t5 (c1) VALUES(1.2345);
60 INSERT INTO t5 (c1) VALUES(-9.0);
61 INSERT INTO t5 (c1) VALUES(-9.12345);
62 SELECT * FROM t5;
63 SELECT COUNT(c1) AS positive_rows FROM t5 WHERE c1 > 0.0;
64 SELECT COUNT(c1) AS negative_rows FROM t5 WHERE c1 < 0.0;
65 SELECT COUNT(c1) AS zero_rows FROM t5 WHERE c1 = 0.0;
66 DROP TABLE t5;
67 CREATE TABLE t4(c1 NUMERIC(1,0) NOT NULL);
68 INSERT INTO t4 (c1) VALUES(0);
69 INSERT INTO t4 (c1) VALUES(1.0);
70 INSERT INTO t4 (c1) VALUES(-9.0);
71 SELECT * FROM t4;
72 SELECT COUNT(c1) AS total_rows FROM t4;
73 SELECT COUNT(c1) AS positive_rows FROM t4 WHERE c1 > 0.0;
74 SELECT COUNT(c1) AS negative_rows FROM t4 WHERE c1 < 0.0;
75 SELECT COUNT(c1) AS zero_rows FROM t4 WHERE c1 = 0.0;
76 DROP TABLE t4;
77 CREATE TABLE t5(c1 NUMERIC(5,4) NOT NULL);
78 INSERT INTO t5 (c1) VALUES(0);
79 INSERT INTO t5 (c1) VALUES(1.0);
80 INSERT INTO t5 (c1) VALUES(1.2345);
81 INSERT INTO t5 (c1) VALUES(-9.0);
82 INSERT INTO t5 (c1) VALUES(-9.12345);
83 SELECT * FROM t5;
84 SELECT COUNT(c1) AS positive_rows FROM t5 WHERE c1 > 0.0;
85 SELECT COUNT(c1) AS negative_rows FROM t5 WHERE c1 < 0.0;
86 SELECT COUNT(c1) AS zero_rows FROM t5 WHERE c1 = 0.0;
87 DROP TABLE t5;
88 CREATE TABLE t4(c1 DOUBLE(1,0) NOT NULL);
89 INSERT INTO t4 (c1) VALUES(0);
90 INSERT INTO t4 (c1) VALUES(1.0);
91 INSERT INTO t4 (c1) VALUES(-9.0);
92 SELECT * FROM t4;
93 SELECT COUNT(c1) AS total_rows FROM t4;
94 SELECT COUNT(c1) AS positive_rows FROM t4 WHERE c1 > 0.0;
95 SELECT COUNT(c1) AS negative_rows FROM t4 WHERE c1 < 0.0;
96 SELECT COUNT(c1) AS zero_rows FROM t4 WHERE c1 = 0.0;
97 DROP TABLE t4;
98 CREATE TABLE t5(c1 DOUBLE(5,4) NOT NULL);
99 INSERT INTO t5 (c1) VALUES(0);
100 INSERT INTO t5 (c1) VALUES(1.0);
101 INSERT INTO t5 (c1) VALUES(1.2345);
102 INSERT INTO t5 (c1) VALUES(-9.0);
103 INSERT INTO t5 (c1) VALUES(-9.12345);
104 SELECT * FROM t5;
105 SELECT COUNT(c1) AS positive_rows FROM t5 WHERE c1 > 0.0;
106 SELECT COUNT(c1) AS negative_rows FROM t5 WHERE c1 < 0.0;
107 SELECT COUNT(c1) AS zero_rows FROM t5 WHERE c1 = 0.0;
108 DROP TABLE t5;
109 CREATE TABLE t4(c1 REAL(1,0) NOT NULL);
110 INSERT INTO t4 (c1) VALUES(0);
111 INSERT INTO t4 (c1) VALUES(1.0);
112 INSERT INTO t4 (c1) VALUES(-9.0);
113 SELECT * FROM t4;
114 SELECT COUNT(c1) AS total_rows FROM t4;
115 SELECT COUNT(c1) AS positive_rows FROM t4 WHERE c1 > 0.0;
116 SELECT COUNT(c1) AS negative_rows FROM t4 WHERE c1 < 0.0;
117 SELECT COUNT(c1) AS zero_rows FROM t4 WHERE c1 = 0.0;
118 DROP TABLE t4;
119 CREATE TABLE t5(c1 REAL(5,4) NOT NULL);
120 INSERT INTO t5 (c1) VALUES(0);
121 INSERT INTO t5 (c1) VALUES(1.0);
122 INSERT INTO t5 (c1) VALUES(1.2345);
123 INSERT INTO t5 (c1) VALUES(-9.0);
124 INSERT INTO t5 (c1) VALUES(-9.12345);
125 SELECT * FROM t5;
126 SELECT COUNT(c1) AS positive_rows FROM t5 WHERE c1 > 0.0;
127 SELECT COUNT(c1) AS negative_rows FROM t5 WHERE c1 < 0.0;
128 SELECT COUNT(c1) AS zero_rows FROM t5 WHERE c1 = 0.0;
129 DROP TABLE t5;
130 CREATE TABLE t4(c1 DOUBLE PRECISION(1,0) NOT NULL);
131 INSERT INTO t4 (c1) VALUES(0);
132 INSERT INTO t4 (c1) VALUES(1.0);
133 INSERT INTO t4 (c1) VALUES(-9.0);
134 SELECT * FROM t4;
135 SELECT COUNT(c1) AS total_rows FROM t4;
136 SELECT COUNT(c1) AS positive_rows FROM t4 WHERE c1 > 0.0;
137 SELECT COUNT(c1) AS negative_rows FROM t4 WHERE c1 < 0.0;
138 SELECT COUNT(c1) AS zero_rows FROM t4 WHERE c1 = 0.0;
139 DROP TABLE t4;
140 CREATE TABLE t5(c1 DOUBLE PRECISION(5,4) NOT NULL);
141 INSERT INTO t5 (c1) VALUES(0);
142 INSERT INTO t5 (c1) VALUES(1.0);
143 INSERT INTO t5 (c1) VALUES(1.2345);
144 INSERT INTO t5 (c1) VALUES(-9.0);
145 INSERT INTO t5 (c1) VALUES(-9.12345);
146 SELECT * FROM t5;
147 SELECT COUNT(c1) AS positive_rows FROM t5 WHERE c1 > 0.0;
148 SELECT COUNT(c1) AS negative_rows FROM t5 WHERE c1 < 0.0;
149 SELECT COUNT(c1) AS zero_rows FROM t5 WHERE c1 = 0.0;
150 DROP TABLE t5;
151 CREATE TABLE t4(c1 FLOAT(1,0) NOT NULL);
152 INSERT INTO t4 (c1) VALUES(0);
153 INSERT INTO t4 (c1) VALUES(1.0);
154 INSERT INTO t4 (c1) VALUES(-9.0);
155 SELECT * FROM t4;
156 SELECT COUNT(c1) AS total_rows FROM t4;
157 SELECT COUNT(c1) AS positive_rows FROM t4 WHERE c1 > 0.0;
158 SELECT COUNT(c1) AS negative_rows FROM t4 WHERE c1 < 0.0;
159 SELECT COUNT(c1) AS zero_rows FROM t4 WHERE c1 = 0.0;
160 DROP TABLE t4;
161 CREATE TABLE t5(c1 FLOAT(5,4) NOT NULL);
162 INSERT INTO t5 (c1) VALUES(0);
163 INSERT INTO t5 (c1) VALUES(1.0);
164 INSERT INTO t5 (c1) VALUES(1.2345);
165 INSERT INTO t5 (c1) VALUES(-9.0);
166 INSERT INTO t5 (c1) VALUES(-9.12345);
167 SELECT * FROM t5;
168 SELECT COUNT(c1) AS positive_rows FROM t5 WHERE c1 > 0.0;
169 SELECT COUNT(c1) AS negative_rows FROM t5 WHERE c1 < 0.0;
170 SELECT COUNT(c1) AS zero_rows FROM t5 WHERE c1 = 0.0;
171 DROP TABLE t5;
172