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:

      a = 5
 
@@ -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:
-     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.