Re: [sqlite] Outer query returning results not found in subquery

On Thu, Feb 10, 2011 at 2:29 PM, Igor Tandetnik wrote: > On 2/10/2011 2:17 PM, Dan Kubb wrote: >> Database setup: >> >>      CREATE TABLE "test" ("letter" VARCHAR(1) PRIMARY KEY, "number" INTEGER >> NOT NULL); >> >>      INSERT INTO "test" ("letter", "number") VALUES('b',

Re: [sqlite] Outer query returning results not found in subquery

On 2/10/2011 2:17 PM, Dan Kubb wrote: > Database setup: > > CREATE TABLE "test" ("letter" VARCHAR(1) PRIMARY KEY, "number" INTEGER > NOT NULL); > > INSERT INTO "test" ("letter", "number") VALUES('b', 1); > INSERT INTO "test" ("letter", "number") VALUES('a', 2); > INSERT INTO

[sqlite] Outer query returning results not found in subquery

Hi, I have a query that when executed stand-alone returns different results than when it's a subquery. At first I wasn't sure if it was just me, so I submitted a question to Stackoverflow with some detail and someone else replied that they could reproduce what I was seeing: