Lines Matching full:order

38   execsql {SELECT DISTINCT log FROM t1 ORDER BY log}
54     ORDER BY log;
63       ORDER BY log;
74       ORDER BY log DESC;
101     ORDER BY log;
106     SELECT DISTINCT log FROM t1 ORDER BY log
109     ORDER BY log;
112 } {1 {ORDER BY clause should come after UNION ALL not before}}
121     ORDER BY log;
129     ORDER BY log;
134     SELECT DISTINCT log FROM t1 ORDER BY log
137     ORDER BY log;
140 } {1 {ORDER BY clause should come after UNION not before}}
149     ORDER BY log;
158       ORDER BY log;
169       ORDER BY log DESC;
179     ORDER BY log;
184     SELECT DISTINCT log FROM t1 ORDER BY log
187     ORDER BY log;
190 } {1 {ORDER BY clause should come after EXCEPT not before}}
199     ORDER BY log;
207     ORDER BY log;
216       ORDER BY log;
227       ORDER BY log DESC;
237     ORDER BY log;
242     SELECT DISTINCT log FROM t1 ORDER BY log
245     ORDER BY log;
248 } {1 {ORDER BY clause should come after INTERSECT not before}}
257     ORDER BY log;
266     ORDER BY xyzzy;
275     ORDER BY 'xyzzy';
284     ORDER BY 'xyzzy';
287 } {1 {ORDER BY term number 1 does not match any result column}}
293     ORDER BY 'xyzzy';
296 } {1 {ORDER BY term number 1 does not match any result column}}
302     ORDER BY n;
311     ORDER BY log;
319     ORDER BY 1;
327     ORDER BY 2;
329 } {1 {ORDER BY position 2 should be between 1 and 1}}
335     ORDER BY 2, 1;
343     ORDER BY 1, 2 DESC;
351     ORDER BY n, 1;
359     ORDER BY log;
372     ORDER BY log;
382     ORDER BY cnt, log;
390     ORDER BY count(*), log;
401     ORDER BY x;
408     ORDER BY x;
451     SELECT * FROM t2 ORDER BY x;
457     ORDER BY n
463     ORDER BY n LIMIT 2
469     ORDER BY n LIMIT 2
488     SELECT DISTINCT b FROM t3 ORDER BY c;
493     SELECT DISTINCT c FROM t3 ORDER BY c;