Debian Codegraph @

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

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