Re: [sqlite] sqlite 3.8.* EXPLAIN QUERY PLAN leaves out LEFT JOIN table

On Fri, Dec 13, 2013 at 8:53 AM, Mark Brand wrote: > > Hi, > > I notice that EXPLAIN QUERY PLAN in sqlite 3.8.* doesn't mention the LEFT > JOIN > table in examples like the following. Sqlite 3.3.17 does mention it. Is > this > by design, or is something going wrong? > > >

[sqlite] sqlite 3.8.* EXPLAIN QUERY PLAN leaves out LEFT JOIN table

Hi, I notice that EXPLAIN QUERY PLAN in sqlite 3.8.* doesn't mention the LEFT JOIN table in examples like the following. Sqlite 3.3.17 does mention it. Is this by design, or is something going wrong? CREATE TABLE aaa (a INTEGER PRIMARY KEY); CREATE TABLE bbb (b INTEGER PRIMARY KEY);