Home
last modified time | relevance | path

Searched refs:ORDER (Results 1 – 25 of 53) sorted by relevance

123

/titanic_50/usr/src/lib/libsqlite/test/
H A Dsort.test50 execsql {SELECT n FROM t1 ORDER BY n}
53 execsql {SELECT n FROM t1 ORDER BY n ASC}
56 execsql {SELECT ALL n FROM t1 ORDER BY n ASC}
59 execsql {SELECT n FROM t1 ORDER BY n DESC}
62 execsql {SELECT v FROM t1 ORDER BY v}
65 execsql {SELECT n FROM t1 ORDER BY v}
68 execsql {SELECT n FROM t1 ORDER BY v DESC}
71 execsql {SELECT flt FROM t1 ORDER BY flt}
74 execsql {SELECT flt FROM t1 ORDER BY flt DESC}
77 execsql {SELECT roman FROM t1 ORDER BY roman}
[all …]
H A Dupdate.test45 execsql {SELECT * FROM test1 ORDER BY f1}
69 execsql {SELECT * FROM test1 ORDER BY f1}
76 execsql {SELECT * FROM test1 ORDER BY f1}
82 execsql {SELECT * FROM test1 ORDER BY f1}
91 execsql {SELECT * FROM test1 ORDER BY F1}
98 execsql {SELECT * FROM test1 ORDER BY F1}
112 execsql {SELECT * FROM test1 ORDER BY f1,f2}
116 execsql {SELECT * FROM test1 ORDER BY f1,f2}
120 execsql {SELECT * FROM test1 ORDER BY f1,f2}
124 execsql {SELECT * FROM test1 ORDER BY f1,f2}
[all …]
H A Dselect4.test38 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;
[all …]
H A Dselect3.test37 execsql {SELECT DISTINCT log FROM t1 ORDER BY log}
58 execsql {SELECT log, count(*) FROM t1 GROUP BY log ORDER BY log}
61 execsql {SELECT log, min(n) FROM t1 GROUP BY log ORDER BY log}
64 execsql {SELECT log, avg(n) FROM t1 GROUP BY log ORDER BY log}
67 execsql {SELECT log, avg(n)+1 FROM t1 GROUP BY log ORDER BY log}
70 execsql {SELECT log, avg(n)-min(n) FROM t1 GROUP BY log ORDER BY log}
73 execsql {SELECT log*2+1, avg(n)-min(n) FROM t1 GROUP BY log ORDER BY log}
77 SELECT log*2+1 as x, count(*) FROM t1 GROUP BY x ORDER BY x
82 SELECT log*2+1 AS x, count(*) AS y FROM t1 GROUP BY x ORDER BY y
87 SELECT log*2+1 AS x, count(*) AS y FROM t1 GROUP BY x ORDER BY 10-(x+y)
[all …]
H A Dwhere.test173 count {SELECT w FROM t1 WHERE w+1<=4 ORDER BY w}
306 ORDER BY 1;
313 ORDER BY 1;
320 ORDER BY 1;
327 ORDER BY 1;
332 SELECT * FROM t1 WHERE x IN (1,7) ORDER BY 1;
337 SELECT * FROM t1 WHERE x+0 IN (1,7) ORDER BY 1;
342 SELECT * FROM t1 WHERE y IN (6400,8100) ORDER BY 1;
347 SELECT * FROM t1 WHERE x=6 AND y IN (6400,8100) ORDER BY 1;
352 SELECT * FROM t1 WHERE x IN (1,7) AND y NOT IN (6400,8100) ORDER BY 1;
[all …]
H A Dformat3.test60 execsql {SELECT n FROM t1 ORDER BY n}
63 execsql {SELECT n FROM t1 ORDER BY n ASC}
66 execsql {SELECT ALL n FROM t1 ORDER BY n ASC}
69 execsql {SELECT n FROM t1 ORDER BY n DESC}
72 execsql {SELECT v FROM t1 ORDER BY v}
75 execsql {SELECT n FROM t1 ORDER BY v}
78 execsql {SELECT n FROM t1 ORDER BY v DESC}
81 execsql {SELECT flt FROM t1 ORDER BY flt}
84 execsql {SELECT flt FROM t1 ORDER BY flt DESC}
87 execsql {SELECT roman FROM t1 ORDER BY roman}
[all …]
H A Dfunc.test29 execsql {SELECT t1 FROM tbl1 ORDER BY t1}
46 execsql {SELECT length(t1) FROM tbl1 ORDER BY t1}
49 set r [catch {execsql {SELECT length(*) FROM tbl1 ORDER BY t1}} msg]
53 set r [catch {execsql {SELECT length(t1,5) FROM tbl1 ORDER BY t1}} msg]
58 ORDER BY length(t1)}
67 execsql {SELECT substr(t1,1,2) FROM tbl1 ORDER BY t1}
70 execsql {SELECT substr(t1,2,1) FROM tbl1 ORDER BY t1}
73 execsql {SELECT substr(t1,3,3) FROM tbl1 ORDER BY t1}
76 execsql {SELECT substr(t1,-1,1) FROM tbl1 ORDER BY t1}
79 execsql {SELECT substr(t1,-1,2) FROM tbl1 ORDER BY t1}
[all …]
H A Dselect1.test269 # ORDER BY expressions
272 set v [catch {execsql {SELECT f1 FROM test1 ORDER BY f1}} msg]
276 set v [catch {execsql {SELECT f1 FROM test1 ORDER BY -f1}} msg]
280 set v [catch {execsql {SELECT f1 FROM test1 ORDER BY min(f1,f2)}} msg]
284 set v [catch {execsql {SELECT f1 FROM test1 ORDER BY min(f1)}} msg]
289 SELECT f1 FROM test1 ORDER BY 8.4;
291 } {1 {ORDER BY terms must not be non-integer constants}}
294 SELECT f1 FROM test1 ORDER BY '8.4';
296 } {1 {ORDER BY terms must not be non-integer constants}}
299 SELECT f1 FROM test1 ORDER BY 'xyz';
[all …]
H A Dsubselect.test85 execsql {SELECT x FROM t2 ORDER BY x}
92 SELECT (SELECT a FROM t1 ORDER BY a), (SELECT a FROM t1 ORDER BY a DESC)
97 SELECT 1 IN (SELECT a FROM t1 ORDER BY a);
102 SELECT 2 IN (SELECT a FROM t1 ORDER BY a DESC);
106 # Verify that the ORDER BY clause is honored in a subquery.
112 SELECT * FROM t3 ORDER BY x;
117 SELECT sum(x) FROM (SELECT x FROM t3 ORDER BY x LIMIT 2);
122 SELECT sum(x) FROM (SELECT x FROM t3 ORDER BY x DESC LIMIT 2);
127 SELECT (SELECT x FROM t3 ORDER BY x);
132 SELECT (SELECT x FROM t3 ORDER BY x DESC);
[all …]
H A Dlimit.test44 execsql {SELECT x FROM t1 ORDER BY x LIMIT 5}
47 execsql {SELECT x FROM t1 ORDER BY x LIMIT 5 OFFSET 2}
50 execsql {SELECT x FROM t1 ORDER BY x LIMIT 2, 5}
53 execsql {SELECT x FROM t1 ORDER BY x LIMIT 5 OFFSET 5}
56 execsql {SELECT x FROM t1 ORDER BY x LIMIT 50 OFFSET 30}
59 execsql {SELECT x FROM t1 ORDER BY x LIMIT 30, 50}
62 execsql {SELECT x FROM t1 ORDER BY x LIMIT 50 OFFSET 50}
65 execsql {SELECT * FROM t1 AS a, t1 AS b ORDER BY a.x, b.x LIMIT 5}
68 execsql {SELECT * FROM t1 AS a, t1 AS b ORDER BY a.x, b.x LIMIT 5 OFFSET 32}
91 SELECT z FROM (SELECT y*10+x AS z FROM t1 ORDER BY x LIMIT 10)
[all …]
H A Dview.test35 SELECT * FROM v1 ORDER BY a;
41 SELECT * FROM v1 ORDER BY a;
47 SELECT * FROM v1 ORDER BY a;
54 SELECT * FROM v1 ORDER BY a;
60 SELECT * FROM v1 ORDER BY a;
66 SELECT * FROM v1 ORDER BY a;
72 SELECT * FROM v1 ORDER BY a;
81 SELECT * FROM v1 ORDER BY a;
88 SELECT * FROM v1 ORDER BY a;
118 SELECT * FROM v2 ORDER BY x;
[all …]
H A Dtrans.test32 SELECT b FROM one ORDER BY a;
41 SELECT b FROM two ORDER BY a;
46 execsql {SELECT b FROM one ORDER BY a} altdb
49 execsql {SELECT b FROM two ORDER BY a} altdb
82 SELECT a FROM one ORDER BY a;
83 SELECT a FROM two ORDER BY a;
94 SELECT a FROM one ORDER BY a;
99 SELECT a FROM two ORDER BY a;
105 SELECT a FROM one ORDER BY a;
117 SELECT a FROM two ORDER BY a;
[all …]
H A Dselect5.test38 execsql {SELECT DISTINCT y FROM t1 ORDER BY y}
44 execsql {SELECT y, count(*) FROM t1 GROUP BY y ORDER BY y}
47 execsql {SELECT y, count(*) FROM t1 GROUP BY y ORDER BY count(*), y}
50 execsql {SELECT count(*), y FROM t1 GROUP BY y ORDER BY count(*), y}
57 SELECT y, count(*) FROM t1 GROUP BY z ORDER BY y
63 SELECT y, count(*) FROM t1 GROUP BY z(y) ORDER BY y
69 SELECT y, count(*) FROM t1 GROUP BY y HAVING count(*)<3 ORDER BY y
75 SELECT y, count(*) FROM t1 GROUP BY y HAVING z(y)<3 ORDER BY y
81 SELECT y, count(*) FROM t1 GROUP BY y HAVING count(*)<z ORDER BY y
90 SELECT x, count(*), avg(y) FROM t1 GROUP BY x HAVING x<4 ORDER BY x
H A Dselect6.test48 SELECT DISTINCT y FROM t1 ORDER BY y;
73 WHERE a.y=b.y ORDER BY a.y
81 WHERE a.y=b.y ORDER BY a.y
89 WHERE q=s ORDER BY s
97 WHERE q=s ORDER BY s
105 SELECT DISTINCT b FROM t2 ORDER BY b;
129 WHERE a.b=b.b ORDER BY a.b
137 WHERE a.b=b.b ORDER BY a.b
145 WHERE q=s ORDER BY s
153 WHERE a.q=b.s ORDER BY a.q
[all …]
H A Din.test41 execsql {SELECT a FROM t1 WHERE b BETWEEN 10 AND 50 ORDER BY a}
44 execsql {SELECT a FROM t1 WHERE b NOT BETWEEN 10 AND 50 ORDER BY a}
47 execsql {SELECT a FROM t1 WHERE b BETWEEN a AND a*5 ORDER BY a}
50 execsql {SELECT a FROM t1 WHERE b NOT BETWEEN a AND a*5 ORDER BY a}
53 execsql {SELECT a FROM t1 WHERE b BETWEEN a AND a*5 OR b=512 ORDER BY a}
56 execsql {SELECT a+ 100*(a BETWEEN 1 and 3) FROM t1 ORDER BY b}
63 execsql {SELECT a FROM t1 WHERE b IN (8,12,16,24,32) ORDER BY a}
66 execsql {SELECT a FROM t1 WHERE b NOT IN (8,12,16,24,32) ORDER BY a}
69 execsql {SELECT a FROM t1 WHERE b IN (8,12,16,24,32) OR b=512 ORDER BY a}
72 execsql {SELECT a FROM t1 WHERE b NOT IN (8,12,16,24,32) OR b=512 ORDER BY a}
[all …]
H A Dindex.test27 execsql {SELECT name FROM sqlite_master WHERE type!='meta' ORDER BY name}
42 execsql {SELECT name FROM sqlite_master WHERE type!='meta' ORDER BY name}
49 execsql {SELECT name FROM sqlite_master WHERE type!='meta' ORDER BY name}
90 ORDER BY name}
100 ORDER BY name}
117 execsql {SELECT name FROM sqlite_master WHERE type!='meta' ORDER BY name}
158 execsql {SELECT name FROM sqlite_master WHERE type!='meta' ORDER BY name}
182 execsql {SELECT name FROM sqlite_master WHERE type!='meta' ORDER BY name}
189 execsql {SELECT name FROM sqlite_master WHERE type!='meta' ORDER BY name}
194 execsql {SELECT name FROM sqlite_master WHERE type!='meta' ORDER BY name}
[all …]
H A Dunique.test56 SELECT * FROM t1 ORDER BY a;
66 SELECT * FROM t1 ORDER BY a;
76 SELECT * FROM t1 ORDER BY a;
87 SELECT * FROM t2 ORDER BY a;
97 SELECT * FROM t2 ORDER BY a
107 SELECT * FROM t2 ORDER BY a
113 SELECT * FROM t2 ORDER BY a;
123 SELECT * FROM t2 ORDER BY a, b;
154 SELECT * FROM t3 ORDER BY a,b,c,d;
160 SELECT * FROM t3 ORDER BY a,b,c,d;
[all …]
H A Drowid.test30 SELECT x FROM t1 ORDER BY y;
34 set r [execsql {SELECT rowid FROM t1 ORDER BY x}]
139 execsql {SELECT x FROM t1 ORDER BY x}
145 execsql {SELECT x FROM t1 ORDER BY x}
176 SELECT * FROM t2 ORDER BY x;
180 execsql {SELECT * FROM t2 ORDER BY rowid}
183 execsql {SELECT rowid, x, y FROM t2 ORDER BY rowid}
186 set r1 [execsql {SELECT _rowid_, rowid FROM t2 ORDER BY rowid}]
188 set r2 [execsql {SELECT _rowid_, rowid FROM t2 ORDER BY x DESC}]
193 set r1 [execsql {SELECT _rowid_, rowid FROM t2 ORDER BY rowid}]
[all …]
H A Dnotnull.test188 SELECT * FROM t1 ORDER BY a;
196 SELECT * FROM t1 ORDER BY a;
204 SELECT * FROM t1 ORDER BY a;
212 SELECT * FROM t1 ORDER BY a;
220 SELECT * FROM t1 ORDER BY a;
228 SELECT * FROM t1 ORDER BY a;
236 SELECT * FROM t1 ORDER BY a;
244 SELECT * FROM t1 ORDER BY a;
252 SELECT * FROM t1 ORDER BY a;
260 SELECT * FROM t1 ORDER BY a;
[all …]
H A Dtableapi.test54 SELECT * FROM xyz ORDER BY a
59 SELECT * FROM xyz WHERE a>49 ORDER BY a
64 SELECT * FROM xyz WHERE a>47 ORDER BY a
82 SELECT * FROM xyz WHERE a>49 ORDER BY a;
90 SELECT * FROM xyz WHERE a IN (42,50,52) ORDER BY a DESC
119 SELECT * FROM xyz ORDER BY a
124 SELECT * FROM xyz WHERE a>49 ORDER BY a
129 SELECT * FROM xyz WHERE a>47 ORDER BY a
139 SELECT * FROM xyz WHERE a>49 ORDER BY a;
147 SELECT * FROM xyz WHERE a IN (42,50,52) ORDER BY a DESC
H A Ddelete.test44 execsql {SELECT * FROM table1 ORDER BY f1}
50 execsql {SELECT * FROM table1 ORDER BY f1}
58 execsql {SELECT * FROM table1 ORDER BY f1}
64 execsql {SELECT * FROM table1 ORDER BY f1}
139 execsql {SELECT f1 FROM table1 ORDER BY f1}
145 execsql {SELECT f1 FROM table1 ORDER BY f1}
149 execsql {SELECT f1 FROM table1 ORDER BY f1}
174 execsql {SELECT f1 FROM table1 WHERE f1<10 ORDER BY f1}
177 execsql {SELECT f1 FROM table2 WHERE f1<10 ORDER BY f1}
181 execsql {SELECT f1 FROM table1 ORDER BY f1}
[all …]
H A Dmisc3.test140 SELECT * FROM t2 ORDER BY a;
145 SELECT * FROM t2 WHERE a>=-2147483648 ORDER BY a;
150 SELECT * FROM t2 WHERE a>-2147483648 ORDER BY a;
155 SELECT * FROM t2 WHERE a>-2147483649 ORDER BY a;
160 SELECT * FROM t2 WHERE a>=0 AND a<2147483649 ORDER BY a DESC;
165 SELECT * FROM t2 WHERE a>=0 AND a<=2147483648 ORDER BY a DESC;
170 SELECT * FROM t2 WHERE a>=0 AND a<2147483648 ORDER BY a DESC;
175 SELECT * FROM t2 WHERE a>=0 AND a<=2147483647 ORDER BY a DESC;
180 SELECT * FROM t2 WHERE a>=0 AND a<2147483647 ORDER BY a DESC;
209 SELECT count(a) FROM t3 WHERE b IN (SELECT b FROM t3 ORDER BY a+1);
[all …]
H A Dmemdb.test156 SELECT c FROM t1 ORDER BY c;
215 SELECT c FROM t2 ORDER BY b;
274 if {!$r0} {set r1 [execsql {SELECT a FROM t1 ORDER BY b}]}
289 SELECT name FROM sqlite_master WHERE type='table' ORDER BY 1;
295 SELECT name FROM sqlite_master WHERE type='table' ORDER BY 1;
305 SELECT a FROM t2 UNION SELECT b FROM t2 ORDER BY 1;
311 SELECT a FROM t2 ORDER BY c;
316 SELECT a FROM t2 ORDER BY c DESC;
329 SELECT name FROM sqlite_master WHERE type='table' ORDER BY 1;
335 SELECT name FROM sqlite_master WHERE type='table' ORDER BY 1;
[all …]
H A Dinsert.test71 execsql {SELECT * FROM test1 ORDER BY one}
75 execsql {SELECT * FROM test1 ORDER BY one}
81 execsql {SELECT * FROM test1 ORDER BY one}
85 execsql {SELECT * FROM test1 ORDER BY one}
89 execsql {SELECT * FROM test1 ORDER BY one}
136 execsql {SELECT * FROM test2 ORDER BY f1}
176 SELECT * FROM t3 ORDER BY a;
182 SELECT * FROM t3 ORDER BY a;
188 SELECT * FROM t3 ORDER BY a;
H A Dcopy.test74 execsql {SELECT * FROM test1 ORDER BY one}
82 execsql {SELECT * FROM test1 ORDER BY one}
90 execsql {SELECT * FROM test1 ORDER BY one}
95 execsql {SELECT * FROM test1 ORDER BY one}
100 execsql {SELECT * FROM test1 ORDER BY one}
150 SELECT * FROM t1 ORDER BY a;
161 SELECT * FROM t1 ORDER BY a;
173 SELECT * FROM t1 ORDER BY a;

123