Lines Matching refs:ORDER
23 # collate1-1.* - Single-field ORDER BY with an explicit COLLATE clause.
24 # collate1-2.* - Multi-field ORDER BY with an explicit COLLATE clause.
25 # collate1-3.* - ORDER BY using a default collation type. Also that an
27 # collate1-4.* - ORDER BY using a data type.
74 SELECT c2 FROM collate1t1 ORDER BY 1;
79 SELECT c2 FROM collate1t1 ORDER BY 1 COLLATE hex;
84 SELECT c2 FROM collate1t1 ORDER BY 1 COLLATE hex DESC;
89 SELECT c2 FROM collate1t1 ORDER BY 1 COLLATE hex ASC;
94 SELECT c2 COLLATE hex FROM collate1t1 ORDER BY 1
99 SELECT c2 COLLATE hex FROM collate1t1 ORDER BY 1 ASC
104 SELECT c2 COLLATE hex FROM collate1t1 ORDER BY 1 DESC
126 SELECT c1, c2 FROM collate1t1 ORDER BY 1 COLLATE numeric, 2 COLLATE hex;
131 SELECT c1, c2 FROM collate1t1 ORDER BY 1 COLLATE binary, 2 COLLATE hex;
136 SELECT c1, c2 FROM collate1t1 ORDER BY 1 COLLATE binary DESC, 2 COLLATE hex;
142 ORDER BY 1 COLLATE binary DESC, 2 COLLATE hex DESC;
148 ORDER BY 1 COLLATE binary ASC, 2 COLLATE hex ASC;
154 ORDER BY 1, 2 COLLATE hex;
160 ORDER BY 1 COLLATE numeric, 2 COLLATE hex;
166 ORDER BY 1 COLLATE numeric, 2;
173 ORDER BY 1, 2;
180 ORDER BY 1, 2;
186 FROM collate1t1 ORDER BY 1 COLLATE binary DESC, 2 COLLATE hex;
193 ORDER BY 1 DESC, 2 DESC;
200 ORDER BY 1 COLLATE binary ASC, 2 COLLATE hex ASC;
211 # by an ORDER BY clause correctly. The focus is all the different ways
221 SELECT * FROM collate1t1 ORDER BY a;
227 SELECT * FROM collate1t1 ORDER BY 1;
232 SELECT * FROM collate1t1 ORDER BY collate1t1.a;
237 SELECT * FROM collate1t1 ORDER BY main.collate1t1.a;
242 SELECT a as c1, b as c2 FROM collate1t1 ORDER BY c1;
247 SELECT a as c1, b as c2 FROM collate1t1 ORDER BY c1 COLLATE binary;
253 FROM collate1t1 ORDER BY c1;
278 SELECT c1 FROM collate1t1 ORDER BY 1;
283 SELECT c2 FROM collate1t1 ORDER BY 1;
288 SELECT c2+0 FROM collate1t1 ORDER BY 1;
293 SELECT c1||'' FROM collate1t1 ORDER BY 1;
298 SELECT (c1||'') COLLATE numeric FROM collate1t1 ORDER BY 1;
