Re: [sqlite] Expression-index bug with OR query

2018-12-15 Thread Dan Kennedy
On 12/14/2018 07:22 AM, Jens Alfke wrote: We’ve found a bug where creating indexes on expressions causes a query to give incorrect results. Our indexes use some complex custom functions, but the bug is easy to reproduce just using the ‘abs’ function: SELECT * FROM docs WHERE abs(a)=2 OR

[sqlite] Expression-index bug with OR query

2018-12-13 Thread Jens Alfke
We’ve found a bug where creating indexes on expressions causes a query to give incorrect results. Our indexes use some complex custom functions, but the bug is easy to reproduce just using the ‘abs’ function: SELECT * FROM docs WHERE abs(a)=2 OR abs(b)=9 After indexing ‘abs(a)’ and ‘abs(b