[sqlite] Comparison operator quirks

I've experienced some weirdness with the results of a comparison between values of different data types. I'm not sure if this is due to type affinity, implicit conversion, or something else, but it doesn't behave as I expect it to as indicated in the documentation. Take the following query for

Re: [sqlite] SQLite 3.6.21 - slow query

Simon Slavin wrote: > On 4 Jan 2010, at 3:02pm, Simon Davies wrote: > > >> 2010/1/4 Simon Slavin <slav...@bigfraud.org>: >> >>> On 4 Jan 2010, at 2:38pm, Jeremy Zeiber wrote: >>> >>> >>>> SELECT headerid, >>

Re: [sqlite] SQLite 3.6.21 - slow query

Simon Davies wrote: > 2010/1/4 Simon Slavin <slav...@bigfraud.org>: > >> On 4 Jan 2010, at 2:38pm, Jeremy Zeiber wrote: >> >> >>> That particular query runs in ~ 30 seconds with outerdetail.header or >>> header.headerid. I do have another qu

Re: [sqlite] SQLite 3.6.21 - slow query

Igor Tandetnik wrote: > Jeremy Zeiber wrote: > >> This query runs in ~ 17 ms: >> SELECT COUNT(data) FROM detail AS outerdetail WHERE headerid=4 AND data >> NOT IN (SELECT DISTINCT data FROM detail WHERE headerid<4) >> > > Here the subquery is not c