Lines Matching refs:e1

245   CREATE TABLE e1(a, b, c, d, e);
246   CREATE INDEX e1ab ON e1(a, b);
247   CREATE INDEX e1cde ON e1(c, d, e);
251   SELECT * FROM e1 WHERE (a, b) > (?, ?)
252 } {SEARCH e1 USING INDEX e1ab ((a,b)>(?,?))}
255   SELECT * FROM e1 WHERE (a, b) < (?, ?)
256 } {SEARCH e1 USING INDEX e1ab ((a,b)<(?,?))}
259   SELECT * FROM e1 WHERE c = ? AND (d, e) > (?, ?)
260 } {SEARCH e1 USING INDEX e1cde (c=? AND (d,e)>(?,?))}
263   SELECT * FROM e1 WHERE c = ? AND (d, e) < (?, ?)
264 } {SEARCH e1 USING INDEX e1cde (c=? AND (d,e)<(?,?))}
267   SELECT * FROM e1 WHERE (d, e) BETWEEN (?, ?) AND (?, ?) AND c = ?
268 } {SEARCH e1 USING INDEX e1cde (c=? AND (d,e)>(?,?) AND (d,e)<(?,?))}