Lines Matching full:order

29   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}
82 execsql {SELECT substr(t1,-2,1) FROM tbl1 ORDER BY t1}
85 execsql {SELECT substr(t1,-2,2) FROM tbl1 ORDER BY t1}
88 execsql {SELECT substr(t1,-4,2) FROM tbl1 ORDER BY t1}
91 execsql {SELECT t1 FROM tbl1 ORDER BY substr(t1,2,20)}
112 execsql {SELECT t1 FROM tbl1 ORDER BY t1}
115 execsql {SELECT length(t1) FROM tbl1 ORDER BY t1}
118 execsql {SELECT substr(t1,1,2) FROM tbl1 ORDER BY t1}
121 execsql {SELECT substr(t1,1,3) FROM tbl1 ORDER BY t1}
124 execsql {SELECT substr(t1,2,2) FROM tbl1 ORDER BY t1}
127 execsql {SELECT substr(t1,2,3) FROM tbl1 ORDER BY t1}
130 execsql {SELECT substr(t1,3,2) FROM tbl1 ORDER BY t1}
133 execsql {SELECT substr(t1,4,2) FROM tbl1 ORDER BY t1}
136 execsql {SELECT substr(t1,-1,1) FROM tbl1 ORDER BY t1}
139 execsql {SELECT substr(t1,-3,2) FROM tbl1 ORDER BY t1}
142 execsql {SELECT substr(t1,-4,3) FROM tbl1 ORDER BY t1}
169 catchsql {SELECT abs(b) FROM t1 ORDER BY a}
172 catchsql {SELECT abs(c) FROM t1 ORDER BY a}
185 catchsql {SELECT round(b,2) FROM t1 ORDER BY b}
188 catchsql {SELECT round(b,0) FROM t1 ORDER BY a}
191 catchsql {SELECT round(c) FROM t1 ORDER BY a}
194 catchsql {SELECT round(c,a) FROM t1 ORDER BY a}
197 catchsql {SELECT 'x' || round(c,a) || 'y' FROM t1 ORDER BY a}
200 catchsql {SELECT round() FROM t1 ORDER BY a}
266 CREATE TEMP TABLE t3 AS SELECT a FROM t2 ORDER BY a DESC;
285 # the text fixture in order to verify correct operation of some of