Re: [sqlite] Possible issue in optimizer, strips away order by

Great, thanks! 2014-02-26 0:11 GMT-03:00 Richard Hipp-3 [via SQLite] < ml-node+s1065341n74140...@n5.nabble.com>: > On Tue, Feb 25, 2014 at 1:11 PM, nobre <[hidden > email]> > wrote: > > > Hi! Given this schema: > > > > create table q (id integ

Re: [sqlite] Possible issue in optimizer, strips away order by

On Tue, Feb 25, 2014 at 1:11 PM, nobre wrote: > Hi! Given this schema: > > create table q (id integer primary key, idLevel integer); > create table level (id integer primary key); > > insert into q values(1, 1); > insert into q values(2, 1); > insert into q values(3, 1); > insert into level value

[sqlite] Possible issue in optimizer, strips away order by

Hi! Given this schema: create table q (id integer primary key, idLevel integer); create table level (id integer primary key); insert into q values(1, 1); insert into q values(2, 1); insert into q values(3, 1); insert into level values(1); When running this query: select p.* FROM q as p inner joi