Debian Codegraph @

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

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