Debian Codegraph @

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

raw
1 DROP TABLE IF EXISTS t6;
2 DROP TABLE IF EXISTS t7;
3 CREATE TABLE t6(c1 DECIMAL(1,0) NULL);
4 SHOW TABLES;
5 Tables_in_test
6 t6
7 SHOW CREATE TABLE t6;
8 Table Create Table
9 t6 CREATE TABLE `t6` (
10 `c1` decimal(1,0) DEFAULT NULL
11 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
12 DROP TABLE t6;
13 SHOW TABLES;
14 Tables_in_test
15 CREATE TABLE t7(c1 DECIMAL(5,4) NULL);
16 SHOW TABLES;
17 Tables_in_test
18 t7
19 SHOW CREATE TABLE t7;
20 Table Create Table
21 t7 CREATE TABLE `t7` (
22 `c1` decimal(5,4) DEFAULT NULL
23 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
24 DROP TABLE t7;
25 SHOW TABLES;
26 Tables_in_test
27 CREATE TABLE t6(c1 DEC(1,0) NULL);
28 SHOW TABLES;
29 Tables_in_test
30 t6
31 SHOW CREATE TABLE t6;
32 Table Create Table
33 t6 CREATE TABLE `t6` (
34 `c1` decimal(1,0) DEFAULT NULL
35 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
36 DROP TABLE t6;
37 SHOW TABLES;
38 Tables_in_test
39 CREATE TABLE t7(c1 DEC(5,4) NULL);
40 SHOW TABLES;
41 Tables_in_test
42 t7
43 SHOW CREATE TABLE t7;
44 Table Create Table
45 t7 CREATE TABLE `t7` (
46 `c1` decimal(5,4) DEFAULT NULL
47 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
48 DROP TABLE t7;
49 SHOW TABLES;
50 Tables_in_test
51 CREATE TABLE t6(c1 FIXED(1,0) NULL);
52 SHOW TABLES;
53 Tables_in_test
54 t6
55 SHOW CREATE TABLE t6;
56 Table Create Table
57 t6 CREATE TABLE `t6` (
58 `c1` decimal(1,0) DEFAULT NULL
59 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
60 DROP TABLE t6;
61 SHOW TABLES;
62 Tables_in_test
63 CREATE TABLE t7(c1 FIXED(5,4) NULL);
64 SHOW TABLES;
65 Tables_in_test
66 t7
67 SHOW CREATE TABLE t7;
68 Table Create Table
69 t7 CREATE TABLE `t7` (
70 `c1` decimal(5,4) DEFAULT NULL
71 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
72 DROP TABLE t7;
73 SHOW TABLES;
74 Tables_in_test
75 CREATE TABLE t6(c1 NUMERIC(1,0) NULL);
76 SHOW TABLES;
77 Tables_in_test
78 t6
79 SHOW CREATE TABLE t6;
80 Table Create Table
81 t6 CREATE TABLE `t6` (
82 `c1` decimal(1,0) DEFAULT NULL
83 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
84 DROP TABLE t6;
85 SHOW TABLES;
86 Tables_in_test
87 CREATE TABLE t7(c1 NUMERIC(5,4) NULL);
88 SHOW TABLES;
89 Tables_in_test
90 t7
91 SHOW CREATE TABLE t7;
92 Table Create Table
93 t7 CREATE TABLE `t7` (
94 `c1` decimal(5,4) DEFAULT NULL
95 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
96 DROP TABLE t7;
97 SHOW TABLES;
98 Tables_in_test
99 CREATE TABLE t6(c1 DECIMAL(1,0) NOT NULL);
100 SHOW TABLES;
101 Tables_in_test
102 t6
103 SHOW CREATE TABLE t6;
104 Table Create Table
105 t6 CREATE TABLE `t6` (
106 `c1` decimal(1,0) NOT NULL
107 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
108 DROP TABLE t6;
109 SHOW TABLES;
110 Tables_in_test
111 CREATE TABLE t7(c1 DECIMAL(5,4) NOT NULL);
112 SHOW TABLES;
113 Tables_in_test
114 t7
115 SHOW CREATE TABLE t7;
116 Table Create Table
117 t7 CREATE TABLE `t7` (
118 `c1` decimal(5,4) NOT NULL
119 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
120 DROP TABLE t7;
121 SHOW TABLES;
122 Tables_in_test
123 CREATE TABLE t6(c1 DEC(1,0) NOT NULL);
124 SHOW TABLES;
125 Tables_in_test
126 t6
127 SHOW CREATE TABLE t6;
128 Table Create Table
129 t6 CREATE TABLE `t6` (
130 `c1` decimal(1,0) NOT NULL
131 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
132 DROP TABLE t6;
133 SHOW TABLES;
134 Tables_in_test
135 CREATE TABLE t7(c1 DEC(5,4) NOT NULL);
136 SHOW TABLES;
137 Tables_in_test
138 t7
139 SHOW CREATE TABLE t7;
140 Table Create Table
141 t7 CREATE TABLE `t7` (
142 `c1` decimal(5,4) NOT NULL
143 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
144 DROP TABLE t7;
145 SHOW TABLES;
146 Tables_in_test
147 CREATE TABLE t6(c1 FIXED(1,0) NOT NULL);
148 SHOW TABLES;
149 Tables_in_test
150 t6
151 SHOW CREATE TABLE t6;
152 Table Create Table
153 t6 CREATE TABLE `t6` (
154 `c1` decimal(1,0) NOT NULL
155 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
156 DROP TABLE t6;
157 SHOW TABLES;
158 Tables_in_test
159 CREATE TABLE t7(c1 FIXED(5,4) NOT NULL);
160 SHOW TABLES;
161 Tables_in_test
162 t7
163 SHOW CREATE TABLE t7;
164 Table Create Table
165 t7 CREATE TABLE `t7` (
166 `c1` decimal(5,4) NOT NULL
167 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
168 DROP TABLE t7;
169 SHOW TABLES;
170 Tables_in_test
171 CREATE TABLE t6(c1 NUMERIC(1,0) NOT NULL);
172 SHOW TABLES;
173 Tables_in_test
174 t6
175 SHOW CREATE TABLE t6;
176 Table Create Table
177 t6 CREATE TABLE `t6` (
178 `c1` decimal(1,0) NOT NULL
179 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
180 DROP TABLE t6;
181 SHOW TABLES;
182 Tables_in_test
183 CREATE TABLE t7(c1 NUMERIC(5,4) NOT NULL);
184 SHOW TABLES;
185 Tables_in_test
186 t7
187 SHOW CREATE TABLE t7;
188 Table Create Table
189 t7 CREATE TABLE `t7` (
190 `c1` decimal(5,4) NOT NULL
191 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
192 DROP TABLE t7;
193 SHOW TABLES;
194 Tables_in_test