Debian Codegraph @

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

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