Lines Matching refs:y

41     CREATE TABLE t1(x, y, z);
60   count { SELECT max(y) FROM t1 WHERE x = '2'; }
65   count   { SELECT max(y) FROM t1 WHERE x = '2'; }
68   # Index optimizes the WHERE x='2' constraint and the MAX(y).
69   execsql { CREATE INDEX i2 ON t1(x,y) }
70   count   { SELECT max(y) FROM t1 WHERE x = '2'; }
73   # Index optimizes the WHERE x='2' constraint and the MAX(y).
74   execsql { DROP INDEX i2 ; CREATE INDEX i2 ON t1(x, y DESC) }
75   count   { SELECT max(y) FROM t1 WHERE x = '2'; }
78   count   { SELECT max(y) FROM t1 WHERE x = '2' AND y != 'V'; }
81   count   { SELECT max(y) FROM t1 WHERE x = '2' AND y < 'V'; }
84   count   { SELECT max(y) FROM t1 WHERE x = '2' AND z != 'five'; }
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).
99   execsql { CREATE INDEX i2 ON t1(x,y) }
100   count   { SELECT min(y) FROM t1 WHERE x = '2'; }
103   # Index optimizes the WHERE x='2' constraint and the MAX(y).
104   execsql { DROP INDEX i2 ; CREATE INDEX i2 ON t1(x, y DESC) }
105   count   { SELECT min(y) FROM t1 WHERE x = '2'; }
111   count   { SELECT min(y) FROM t1; }
114   # Index i1 optimizes the min(y)
115   execsql { CREATE INDEX i1 ON t1(y) }
116   count   { SELECT min(y) FROM t1; }
119   # Index i1 optimizes the min(y)
120   execsql { DROP INDEX i1 ; CREATE INDEX i1 ON t1(y DESC) }
121   count   { SELECT min(y) FROM t1; }
127   count   { SELECT max(y) FROM t1; }
130   # Index i1 optimizes the max(y)
131   execsql { CREATE INDEX i1 ON t1(y) }
132   count   { SELECT max(y) FROM t1; }
135   # Index i1 optimizes the max(y)
136   execsql { DROP INDEX i1 ; CREATE INDEX i1 ON t1(y DESC) }
137   execsql   { SELECT y from t1}
138   count   { SELECT max(y) FROM t1; }