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.