Lines Matching refs:sort

24 db collate "reverse sort" reverse_sort
27 # opcode was executed.  If an OP_Sort did occur, then "sort" is appended
36   if {$::sqlite_sort_count} {set x sort} {set x nosort}
51     CREATE TABLE xy(x COLLATE "reverse sort", y COLLATE binary);
71 } {two three one sort}
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");
123 } {one three two sort}
126     SELECT y FROM xy ORDER BY y COLLATE "reverse sort"
133 } {one three two sort}
136     SELECT y COLLATE "reverse sort" AS aaa FROM xy ORDER BY aaa
143       REINDEX "reverse sort"
147   # Modify the "reverse sort" collation so that it now sorts in the same
154   # "reverse sort" are no longer in sync with the collation sequence
162       REINDEX "reverse sort"
173       SELECT x FROM xy ORDER BY x COLLATE "reverse sort"