[sqlite] outer join/order by bug?

2015-02-24 Thread Simon Davies
On 24 February 2015 at 15:20, Simon Davies wrote: > On 24 February 2015 at 15:02, Grisha Vinevich wrote: >> There seems to be some problem with left outer join in Windows version of >> sqlite3. >> I try to use the following (simplified) schema: >> . . . >> When I run this on

[sqlite] outer join/order by bug?

2015-02-24 Thread Simon Davies
On 24 February 2015 at 15:02, Grisha Vinevich wrote: > There seems to be some problem with left outer join in Windows version of > sqlite3. > I try to use the following (simplified) schema: > > CREATE TABLE "A" ( "Name" text); > CREATE TABLE "Items" ( "ItemName" text , "Name" text ); > INSERT

[sqlite] outer join/order by bug?

2015-02-24 Thread Grisha Vinevich
There seems to be some problem with left outer join in Windows version of sqlite3. I try to use the following (simplified) schema: CREATE TABLE "A" ( "Name" text); CREATE TABLE "Items" ( "ItemName" text , "Name" text ); INSERT INTO "Items" VALUES('Item1','Parent'); INSERT INTO "Items"

[sqlite] outer join/order by bug?

2015-02-24 Thread Richard Hipp
On 2/24/15, Grisha Vinevich wrote: > There seems to be some problem with left outer join in Windows version of > sqlite3. Thanks for the report. This appears to be a query planner bug introduced for SQLite version 3.8.8 by the check-in at https://www.sqlite.org/src/timeline?c=d95d03 We'll