[sqlite] Bug: LEFT JOIN on view confusing the query optimiser

>The result is correct. I am so surprized by your assertion I am sure there is some misunderstanding. The way 1) is performed, scan song_artist first, is suboptimal. Try my example with ~8000 rows and a where clause that returns multiple songs and you will see what I mean. >This would not necess

[sqlite] Windows A and W APIs dual support

On 2016/02/13 6:52 AM, J Decker wrote: > On Fri, Feb 12, 2016 at 8:00 PM, Igor Tandetnik wrote: >> On 2/12/2016 10:44 PM, J Decker wrote: >>> >>> I expect it to take any string >> >> What is the basis of this expectation, other than wishful thinking? > I don't think expectation and wishful thin

[sqlite] query Benchmark

On 2016/02/12 6:38 PM, Michele Pradella wrote: > Already solved with UNION of SELECT > It isn't solved, it is circumvented by trial and error without understanding why. I'm sure that works ok for you in this case, but the point is if you do study those documents a bit more, you may grasp the

[sqlite] Temporary table in SQLite

Short answer, Yes. Long answer, have you read the SQLite documents? Gerry On Feb 13, 2016 8:13 PM, wrote: > Hi, > > Is it possible to create a temporary table in SQLite so that it will only > be > visible to the current session and be destroyed after the session is > closed? > Just like SQL Ser