Index: Doc/Special/Core/vtab.html ================================================================== --- Doc/Special/Core/vtab.html +++ Doc/Special/Core/vtab.html @@ -873,11 +873,11 @@
column OP EXPR
Where "column" is a column in the virtual table, OP is an operator -like "=" or "<", and EXPR is an arbitrary expression. So, for example, +like "=" or "<", and EXPR is an arbitrary expression. So, for example, if the WHERE clause contained a term like this:
@@ -889,19 +889,19 @@ WHERE clause in order to extract as many constraints as it can. So, for example, if the WHERE clause contained something like this:a = 5
- x BETWEEN 10 AND 100 AND 999>y + x BETWEEN 10 AND 100 AND 999>y
The query optimizer might translate this into three separate constraints:
- x >= 10 - x <= 100 - y < 999 + x >= 10 + x <= 100 + y < 999
For each constraint, the aConstraint[].iColumn field indicates which column appears on the left-hand side of the constraint. The first column of the virtual table is column 0.