Debian Codegraph @

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

raw
1 DROP TABLE IF EXISTS t11;
2 CREATE TABLE t11(c1 TINYINT(5) NULL DEFAULT 1);
3 Warnings:
4 Warning 1681 Integer display width is deprecated and will be removed in a future release.
5 SHOW TABLES;
6 Tables_in_test
7 t11
8 SHOW CREATE TABLE t11;
9 Table Create Table
10 t11 CREATE TABLE `t11` (
11 `c1` tinyint DEFAULT '1'
12 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
13 DROP TABLE t11;
14 SHOW TABLES;
15 Tables_in_test
16 CREATE TABLE t11(c1 SMALLINT(5) NULL DEFAULT 1);
17 Warnings:
18 Warning 1681 Integer display width is deprecated and will be removed in a future release.
19 SHOW TABLES;
20 Tables_in_test
21 t11
22 SHOW CREATE TABLE t11;
23 Table Create Table
24 t11 CREATE TABLE `t11` (
25 `c1` smallint DEFAULT '1'
26 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
27 DROP TABLE t11;
28 SHOW TABLES;
29 Tables_in_test
30 CREATE TABLE t11(c1 MEDIUMINT(5) NULL DEFAULT 1);
31 Warnings:
32 Warning 1681 Integer display width is deprecated and will be removed in a future release.
33 SHOW TABLES;
34 Tables_in_test
35 t11
36 SHOW CREATE TABLE t11;
37 Table Create Table
38 t11 CREATE TABLE `t11` (
39 `c1` mediumint DEFAULT '1'
40 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
41 DROP TABLE t11;
42 SHOW TABLES;
43 Tables_in_test
44 CREATE TABLE t11(c1 INT(5) NULL DEFAULT 1);
45 Warnings:
46 Warning 1681 Integer display width is deprecated and will be removed in a future release.
47 SHOW TABLES;
48 Tables_in_test
49 t11
50 SHOW CREATE TABLE t11;
51 Table Create Table
52 t11 CREATE TABLE `t11` (
53 `c1` int DEFAULT '1'
54 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
55 DROP TABLE t11;
56 SHOW TABLES;
57 Tables_in_test
58 CREATE TABLE t11(c1 INTEGER(5) NULL DEFAULT 1);
59 Warnings:
60 Warning 1681 Integer display width is deprecated and will be removed in a future release.
61 SHOW TABLES;
62 Tables_in_test
63 t11
64 SHOW CREATE TABLE t11;
65 Table Create Table
66 t11 CREATE TABLE `t11` (
67 `c1` int DEFAULT '1'
68 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
69 DROP TABLE t11;
70 SHOW TABLES;
71 Tables_in_test
72 CREATE TABLE t11(c1 BIGINT(5) NULL DEFAULT 1);
73 Warnings:
74 Warning 1681 Integer display width is deprecated and will be removed in a future release.
75 SHOW TABLES;
76 Tables_in_test
77 t11
78 SHOW CREATE TABLE t11;
79 Table Create Table
80 t11 CREATE TABLE `t11` (
81 `c1` bigint DEFAULT '1'
82 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
83 DROP TABLE t11;
84 SHOW TABLES;
85 Tables_in_test
86 CREATE TABLE t11(c1 TINYINT(5) NOT NULL DEFAULT 1);
87 Warnings:
88 Warning 1681 Integer display width is deprecated and will be removed in a future release.
89 SHOW TABLES;
90 Tables_in_test
91 t11
92 SHOW CREATE TABLE t11;
93 Table Create Table
94 t11 CREATE TABLE `t11` (
95 `c1` tinyint NOT NULL DEFAULT '1'
96 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
97 DROP TABLE t11;
98 SHOW TABLES;
99 Tables_in_test
100 CREATE TABLE t11(c1 SMALLINT(5) NOT NULL DEFAULT 1);
101 Warnings:
102 Warning 1681 Integer display width is deprecated and will be removed in a future release.
103 SHOW TABLES;
104 Tables_in_test
105 t11
106 SHOW CREATE TABLE t11;
107 Table Create Table
108 t11 CREATE TABLE `t11` (
109 `c1` smallint NOT NULL DEFAULT '1'
110 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
111 DROP TABLE t11;
112 SHOW TABLES;
113 Tables_in_test
114 CREATE TABLE t11(c1 MEDIUMINT(5) NOT NULL DEFAULT 1);
115 Warnings:
116 Warning 1681 Integer display width is deprecated and will be removed in a future release.
117 SHOW TABLES;
118 Tables_in_test
119 t11
120 SHOW CREATE TABLE t11;
121 Table Create Table
122 t11 CREATE TABLE `t11` (
123 `c1` mediumint NOT NULL DEFAULT '1'
124 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
125 DROP TABLE t11;
126 SHOW TABLES;
127 Tables_in_test
128 CREATE TABLE t11(c1 INT(5) NOT NULL DEFAULT 1);
129 Warnings:
130 Warning 1681 Integer display width is deprecated and will be removed in a future release.
131 SHOW TABLES;
132 Tables_in_test
133 t11
134 SHOW CREATE TABLE t11;
135 Table Create Table
136 t11 CREATE TABLE `t11` (
137 `c1` int NOT NULL DEFAULT '1'
138 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
139 DROP TABLE t11;
140 SHOW TABLES;
141 Tables_in_test
142 CREATE TABLE t11(c1 INTEGER(5) NOT NULL DEFAULT 1);
143 Warnings:
144 Warning 1681 Integer display width is deprecated and will be removed in a future release.
145 SHOW TABLES;
146 Tables_in_test
147 t11
148 SHOW CREATE TABLE t11;
149 Table Create Table
150 t11 CREATE TABLE `t11` (
151 `c1` int NOT NULL DEFAULT '1'
152 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
153 DROP TABLE t11;
154 SHOW TABLES;
155 Tables_in_test
156 CREATE TABLE t11(c1 BIGINT(5) NOT NULL DEFAULT 1);
157 Warnings:
158 Warning 1681 Integer display width is deprecated and will be removed in a future release.
159 SHOW TABLES;
160 Tables_in_test
161 t11
162 SHOW CREATE TABLE t11;
163 Table Create Table
164 t11 CREATE TABLE `t11` (
165 `c1` bigint NOT NULL DEFAULT '1'
166 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
167 DROP TABLE t11;
168 SHOW TABLES;
169 Tables_in_test