Lines Matching refs:BETWEEN
18328 ExprList *pList; /* op = IN, EXISTS, SELECT, CASE, FUNCTION, BETWEEN */
32076 ** x BETWEEN y AND z
32093 sqlite3TreeViewLine(pView, "BETWEEN");
110431 ** x BETWEEN y AND z
110914 ** Generate code for a BETWEEN operator.
110916 ** x BETWEEN y AND z
110935 Expr *pExpr, /* The BETWEEN expression */
110938 int jumpIfNull /* Take the jump if the BETWEEN is NULL */
155910 /* If a term is the BETWEEN operator, create two new virtual terms
155911 ** that define the range that the BETWEEN implements. For example:
155913 ** a BETWEEN b AND c
155917 ** (a BETWEEN b AND c) AND (a>=b) AND (a<=c)
155920 ** The new terms are "dynamic" and are children of the original BETWEEN
155921 ** term. That means that if the BETWEEN term is coded, the children are
155923 ** BETWEEN term is skipped.
158209 ** SELECT * FROM t1 WHERE a=? AND c BETWEEN ? AND ?;
158213 ** by some factor to account for the (c BETWEEN ? AND ?) expression based
158495 ** index. While a closed range (e.g. col BETWEEN ? AND ?) is estimated to
163257 ** ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW
163271 ** ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW
163302 ** RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW
163421 ** RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW
163452 ** GROUPS BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING
163497 ** GROUPS BETWEEN 1 FOLLOWING AND UNBOUNDED FOLLOWING
164699 ** (ORDER BY a, b GROUPS BETWEEN 2 PRECEDING AND 2 FOLLOWING)
165406 /* If this is a (RANGE BETWEEN a FOLLOWING AND b FOLLOWING) or
165407 ** (RANGE BETWEEN b PRECEDING AND a PRECEDING) frame, ensure the
165579 ** ROWS BETWEEN <expr1> PRECEDING AND <expr2> FOLLOWING
165636 ** differently from the above - "BETWEEN <expr> PRECEDING AND <expr> PRECEDING"
165637 ** and "BETWEEN <expr> FOLLOWING AND <expr> FOLLOWING". These are special
165643 ** ROWS BETWEEN <expr1> PRECEDING AND <expr2> PRECEDING
165671 ** ROWS BETWEEN <expr1> FOLLOWING AND <expr2> FOLLOWING
165715 ** ROWS BETWEEN <expr1> FOLLOWING AND UNBOUNDED FOLLOWING
165744 ** ROWS BETWEEN <expr1> PRECEDING AND <expr2> PRECEDING
165745 ** ROWS BETWEEN <expr1> FOLLOWING AND <expr2> FOLLOWING
165800 ** RANGE BETWEEN <expr1> PRECEDING AND <expr2> FOLLOWING
165836 ** RANGE BETWEEN <expr1> PRECEDING AND <expr2> PRECEDING
165866 ** RANGE BETWEEN <expr1> FOLLOWING AND <expr2> FOLLOWING
166006 /* If this is not a "ROWS BETWEEN ..." frame, then allocate arrays of
167502 0, /* BETWEEN => nothing */
167775 /* 48 */ "BETWEEN",
168268 /* 215 */ "between_op ::= BETWEEN",
168269 /* 216 */ "between_op ::= NOT BETWEEN",
168375 /* 322 */ "frame_opt ::= range_or_rows BETWEEN frame_bound_s AND frame_bound_e frame_exclude_opt",
169179 275, /* (215) between_op ::= BETWEEN */
169180 275, /* (216) between_op ::= NOT BETWEEN */
169286 309, /* (322) frame_opt ::= range_or_rows BETWEEN frame_bound_s AND frame_bound_e frame_exclude_opt */
169589 -1, /* (215) between_op ::= BETWEEN */
169590 -2, /* (216) between_op ::= NOT BETWEEN */
169696 -6, /* (322) frame_opt ::= range_or_rows BETWEEN frame_bound_s AND frame_bound_e frame_exclude_opt */
170059 case 216: /* between_op ::= NOT BETWEEN */ yytestcase(yyruleno==216);
170736 case 215: /* between_op ::= BETWEEN */
171194 case 322: /* frame_opt ::= range_or_rows BETWEEN frame_bound_s AND frame_bound_e frame_exclude_opt */
172059 ** 70: BETWEEN
172211 testcase( i==70 ); /* BETWEEN */
183026 "SELECT %s WHERE rowid BETWEEN %lld AND %lld ORDER BY rowid %s",
190198 "FROM %Q.'%q_segdir' WHERE level BETWEEN ? AND ?"
190202 /* 15 */ "SELECT max(level) FROM %Q.'%q_segdir' WHERE level BETWEEN ? AND ?",
190205 /* 17 */ "DELETE FROM %Q.'%q_segments' WHERE blockid BETWEEN ? AND ?",
190215 /* 26 */ "DELETE FROM %Q.'%q_segdir' WHERE level BETWEEN ? AND ?",
190271 "FROM %Q.'%q_segdir' WHERE level BETWEEN ? AND ? "
190499 /* "SELECT * FROM %_segdir WHERE level BETWEEN ? AND ? ORDER BY ..." */
192366 ** SELECT max(level) FROM %Q.'%q_segdir' WHERE level BETWEEN ? AND ?
192394 ** SELECT max(level) FROM %Q.'%q_segdir' WHERE level BETWEEN ? AND ?
210016 " (sql COLLATE nocase BETWEEN 'CREATE VIRTUAL' AND 'CREATE VIRTUAM'),"
230773 ** DELETE FROM %_data WHERE id BETWEEN $iFirst AND $iLast
236989 ** <tbl> MATCH <expr> AND rowid BETWEEN $iFirstRowid AND $iLastRowid