Lines Matching refs:reverse
24 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"
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"