[sqlite] OR in virtual tables

[Jos van den Oever]

Hi All,

I'm playing with virtual tables and found that when i do
SELECT * FROM vtable WHERE x = 'a' OR x = 'b'
xBestIndex is called without constraints. Is there a way to circumvent
this? I dont want sqlite to traverse all the rows just because of the
OR statement.
The version I'm using is 3.3.13.
Using
 info->estimatedCost = 100000;
does not trigger additional calls to xBestIndex.

Cheers,
Jos

-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------