Home
last modified time | relevance | path

Searched refs:reverse (Results 1 – 18 of 18) sorted by relevance

/sqlite-3.40.0/test/
H A Dcollate9.test24 db collate "reverse sort" reverse_sort
51 CREATE TABLE xy(x COLLATE "reverse sort", y COLLATE binary);
95 SELECT y, y COLLATE "reverse sort" < 'seven' FROM xy ORDER BY x
105 SELECT y FROM xy ORDER BY y COLLATE "reverse sort"
110 SELECT y COLLATE "reverse sort" AS aaa FROM xy ORDER BY aaa
116 CREATE INDEX xy_i2 ON xy(y COLLATE "reverse sort");
126 SELECT y FROM xy ORDER BY y COLLATE "reverse sort"
136 SELECT y COLLATE "reverse sort" AS aaa FROM xy ORDER BY aaa
143 REINDEX "reverse sort"
162 REINDEX "reverse sort"
[all …]
H A Dboundary4.tcl97 proc reverse {inlist} { procedure
156 foreach r [reverse [sort $all_rowid]] {
171 foreach a [reverse [sort $all_a]] {
187 foreach x [reverse [sort $all_x]] {
204 foreach r [reverse [sort $all_rowid]] {
219 foreach a [reverse [sort $all_a]] {
235 foreach x [reverse [sort $all_x]] {
268 foreach a [reverse [sort $all_a]] {
284 foreach x [reverse [sort $all_x]] {
317 foreach a [reverse [sort $all_a]] {
[all …]
H A Dtkt3997.test19 proc reverse {lhs rhs} {
26 db collate reverse reverse
41 ORDER BY name COLLATE reverse
48 ORDER BY name COLLATE reverse
54 CREATE TABLE mytext2(name COLLATE reverse);
H A Dboundary2.tcl98 proc reverse {inlist} { procedure
203 foreach rx [reverse [sort $rset]] {
248 foreach rx [reverse [sort $rset]] {
277 foreach rx [reverse [sort $rset]] {
359 foreach rx [reverse [sort $rset]] {
404 foreach rx [reverse [sort $rset]] {
433 foreach rx [reverse [sort $rset]] {
H A Dboundary1.tcl98 proc reverse {inlist} { procedure
202 foreach rx [reverse [sort $rset]] {
247 foreach rx [reverse [sort $rset]] {
276 foreach rx [reverse [sort $rset]] {
H A Dboundary3.tcl97 proc reverse {inlist} { procedure
223 foreach rx [reverse [sort $rset]] {
274 foreach rx [reverse [sort $rset]] {
H A Dselect9.test266 proc reverse {lhs rhs} {
269 db collate reverse reverse
303 ORDER BY 2 COLLATE reverse, 1
316 ORDER BY 2 COLLATE reverse, 1
H A De_expr.test363 db collate reverse reverse_collate
372 do_execsql_test e_expr-9.1 { SELECT 'abcd' < 'bbbb' COLLATE reverse } 0
373 do_execsql_test e_expr-9.2 { SELECT ('abcd' < 'bbbb') COLLATE reverse } 1
374 do_execsql_test e_expr-9.3 { SELECT 'abcd' <= 'bbbb' COLLATE reverse } 0
375 do_execsql_test e_expr-9.4 { SELECT ('abcd' <= 'bbbb') COLLATE reverse } 1
377 do_execsql_test e_expr-9.5 { SELECT 'abcd' > 'bbbb' COLLATE reverse } 1
378 do_execsql_test e_expr-9.6 { SELECT ('abcd' > 'bbbb') COLLATE reverse } 0
379 do_execsql_test e_expr-9.7 { SELECT 'abcd' >= 'bbbb' COLLATE reverse } 1
380 do_execsql_test e_expr-9.8 { SELECT ('abcd' >= 'bbbb') COLLATE reverse } 0
1303 proc reverse {lhs rhs} {
[all …]
H A Ddescidx3.test101 # the rows in reverse order because this the natural order of the
H A Dmisc2.test266 # in reverse order so that we exercise the sqlite3BtreePrev() routine
H A Dshared_err.test224 # are doing a reverse-order scan of the table when the cursor is
H A Dwhere2.test163 # Efficient handling of forward and reverse table scans.
H A Dpragma.test1915 # EVIDENCE-OF: R-11847-09179 1 if the index-column is sorted in reverse
H A Dwhere.test739 # Tests for reverse-order sorting.
H A Dfts1porter.test17194 reverse revers
/sqlite-3.40.0/ext/wasm/common/
H A Dtesting.css60 #test-output.reverse {
61 flex-direction: column-reverse;
/sqlite-3.40.0/
H A DREADME.md186 the **opcodes.c** source file, which contains a reverse mapping from
/sqlite-3.40.0/ext/fts5/test/
H A Dfts5porter.test8605 reverse revers reversion revers