Lines Matching refs:b
29 db eval "CREATE TABLE t1(a,b,c,PRIMARY KEY(b,c)) $rowidclause;"
42 SELECT b,a,c FROM t1 ORDER BY b,a,c;
43 } [db eval {SELECT b,a,c FROM t1 ORDER BY +b,+a,+c}]
45 SELECT b,a,c FROM t1 ORDER BY b,c DESC,a;
46 } [db eval {SELECT b,a,c FROM t1 ORDER BY +b,+c DESC,+a}]
48 SELECT b,a,c FROM t1 ORDER BY b DESC,c,a;
49 } [db eval {SELECT b,a,c FROM t1 ORDER BY +b DESC,+c,+a}]
51 SELECT b,a,c FROM t1 ORDER BY b DESC,a,c;
52 } [db eval {SELECT b,a,c FROM t1 ORDER BY +b DESC,+a,+c}]
57 SELECT a FROM t1 ORDER BY b, a LIMIT 10 OFFSET 20;
60 SELECT a FROM t1 ORDER BY +b, a LIMIT 10 OFFSET 20;
64 SELECT a FROM t1 ORDER BY b DESC, a LIMIT 10 OFFSET 20;
67 SELECT a FROM t1 ORDER BY +b DESC, a LIMIT 10 OFFSET 20;
71 SELECT a FROM t1 ORDER BY b, a DESC LIMIT 10 OFFSET 45;
74 SELECT a FROM t1 ORDER BY +b, a DESC LIMIT 10 OFFSET 45;
78 SELECT a FROM t1 ORDER BY b DESC, a LIMIT 10 OFFSET 45;
81 SELECT a FROM t1 ORDER BY +b DESC, a LIMIT 10 OFFSET 45;
88 1 10 24 {+b,+a}
89 2 10 25 {+b,+a}
90 3 10 26 {+b,+a}
91 4 10 39 {+b,+a}
92 5 10 40 {+b,+a}
93 6 10 41 {+b,+a}
94 7 27 24 {+b,+a}
95 8 27 49 {+b,+a}
96 11 10 24 {+b DESC,+a}
97 12 10 25 {+b DESC,+a}
98 13 10 26 {+b DESC,+a}
99 14 10 39 {+b DESC,+a}
100 15 10 40 {+b DESC,+a}
101 16 10 41 {+b DESC,+a}
102 17 27 24 {+b DESC,+a}
103 18 27 49 {+b DESC,+a}
104 21 10 24 {+b,+a DESC}
105 22 10 25 {+b,+a DESC}
106 23 10 26 {+b,+a DESC}
107 24 10 39 {+b,+a DESC}
108 25 10 40 {+b,+a DESC}
109 26 10 41 {+b,+a DESC}
110 27 27 24 {+b,+a DESC}
111 28 27 49 {+b,+a DESC}
112 31 10 24 {+b DESC,+a DESC}
113 32 10 25 {+b DESC,+a DESC}
114 33 10 26 {+b DESC,+a DESC}
115 34 10 39 {+b DESC,+a DESC}
116 35 10 40 {+b DESC,+a DESC}
117 36 10 41 {+b DESC,+a DESC}
118 37 27 24 {+b DESC,+a DESC}
119 38 27 49 {+b DESC,+a DESC}
130 db eval "CREATE TABLE t2(a,b,c,d,e,f,PRIMARY KEY(b,c,d,e,f)) $rowidclause;"
140 SELECT a FROM t2 ORDER BY b,c,d,e,f;
141 } [db eval {SELECT a FROM t2 ORDER BY +b,+c,+d,+e,+f;}]
143 SELECT a FROM t2 ORDER BY b,c,d,e,+f;
144 } [db eval {SELECT a FROM t2 ORDER BY +b,+c,+d,+e,+f;}]
146 SELECT a FROM t2 ORDER BY b,c,d,+e,+f;
147 } [db eval {SELECT a FROM t2 ORDER BY +b,+c,+d,+e,+f;}]
149 SELECT a FROM t2 ORDER BY b,c,+d,+e,+f;
150 } [db eval {SELECT a FROM t2 ORDER BY +b,+c,+d,+e,+f;}]
152 SELECT a FROM t2 ORDER BY b,+c,+d,+e,+f;
153 } [db eval {SELECT a FROM t2 ORDER BY +b,+c,+d,+e,+f;}]
156 SELECT a FROM t2 ORDER BY b,c,d,e,f DESC;
157 } [db eval {SELECT a FROM t2 ORDER BY +b,+c,+d,+e,+f DESC;}]
159 SELECT a FROM t2 ORDER BY b,c,d,e DESC,f;
160 } [db eval {SELECT a FROM t2 ORDER BY +b,+c,+d,+e DESC,+f;}]
162 SELECT a FROM t2 ORDER BY b,c,d DESC,e,f;
163 } [db eval {SELECT a FROM t2 ORDER BY +b,+c,+d DESC,+e,+f;}]
165 SELECT a FROM t2 ORDER BY b,c DESC,d,e,f;
166 } [db eval {SELECT a FROM t2 ORDER BY +b,+c DESC,+d,+e,+f;}]
168 SELECT a FROM t2 ORDER BY b DESC,c,d,e,f;
169 } [db eval {SELECT a FROM t2 ORDER BY +b DESC,+c,+d,+e,+f;}]
172 SELECT a FROM t2 ORDER BY b DESC,c DESC,d,e,f LIMIT 31;
173 } [db eval {SELECT a FROM t2 ORDER BY +b DESC,+c DESC,+d,+e,+f LIMIT 31}]
175 SELECT a FROM t2 ORDER BY b,c,d,e,f DESC LIMIT 8 OFFSET 7;
176 } [db eval {SELECT a FROM t2 ORDER BY +b,+c,+d,+e,+f DESC LIMIT 8 OFFSET 7}]