Lines Matching refs:min

90   count { SELECT min(y) FROM t1 WHERE x = '2'; }
95   count   { SELECT min(y) FROM t1 WHERE x = '2'; }
98   # Index i2 optimizes the WHERE x='2' constraint and the min(y).
100   count   { SELECT min(y) FROM t1 WHERE x = '2'; }
105   count   { SELECT min(y) FROM t1 WHERE x = '2'; }
111   count   { SELECT min(y) FROM t1; }
114   # Index i1 optimizes the min(y)
116   count   { SELECT min(y) FROM t1; }
119   # Index i1 optimizes the min(y)
121   count   { SELECT min(y) FROM t1; }
162   execsql { SELECT min(b) FROM t2 WHERE a = 1; }
165   execsql { SELECT min(b) FROM t2 WHERE a = 1 AND b>1; }
168   execsql { SELECT min(b) FROM t2 WHERE a = 1 AND b>-1; }
171   execsql { SELECT min(b) FROM t2 WHERE a = 1; }
174   execsql { SELECT min(b) FROM t2 WHERE a = 1 AND b<2; }
177   execsql { SELECT min(b) FROM t2 WHERE a = 1 AND b<1; }
180   execsql { SELECT min(b) FROM t2 WHERE a = 3 AND b<1; }
202   execsql { SELECT min(b) FROM t2 WHERE a = 1; }
205   execsql { SELECT min(b) FROM t2 WHERE a = 1 AND b>1; }
208   execsql { SELECT min(b) FROM t2 WHERE a = 1 AND b>-1; }
211   execsql { SELECT min(b) FROM t2 WHERE a = 1; }
214   execsql { SELECT min(b) FROM t2 WHERE a = 1 AND b<2; }
217   execsql { SELECT min(b) FROM t2 WHERE a = 1 AND b<1; }
220   execsql { SELECT min(b) FROM t2 WHERE a = 3 AND b<1; }
258     SELECT min(x) FROM t4;
263     SELECT min(x COLLATE nocase) FROM t4;
268     SELECT min(x), min(x COLLATE nocase) FROM t4;
273     SELECT min(x COLLATE binary), min(x COLLATE nocase) FROM t4;
278     SELECT min(x COLLATE nocase), min(x COLLATE rtrim) FROM t4;
283     SELECT min(x COLLATE nocase), min(x) FROM t4;