[sqlite] Unexpected ordering when index exists

Ok, I understand. Thanks for your quick answers. Oliver > Date: Thu, 10 Sep 2015 15:31:02 +0100 > From: swithun at swithun.servebeer.com > To: sqlite-users at mailinglists.sqlite.org > Subject: Re: [sqlite] Unexpected ordering when index exists > > Hello > > OK> Th

[sqlite] Unexpected ordering when index exists

Hello OK> The result consists of 4 rows, in the following order: OK> "1""AB" OK> "4""AB" OK> "2""CD" OK> "5""CD" OK> Especially you can see that the result is sorted by column 'y'. OK> This is reproducible and I can't understand that. OK> When you remove the index ix_t1_y, the res

[sqlite] Unexpected ordering when index exists

Hi sqlite mailing list, I'm experiencing unexpected ordering with a WHERE clause and an index on the filtered column. At first I'll state the reproduction steps: DROP TABLE IF EXISTS t1; CREATE TABLE t1(x, y); CREATE INDEX ix_t1_y ON t1(y); INSERT INTO t1(x,y) VALUES(1,'AB'); INSERT INTO t1(x,y

[sqlite] Unexpected ordering when index exists

-users-boun...@mailinglists.sqlite.org] On Behalf Of Oliver Kock Sent: Donnerstag, 10. September 2015 14:40 To: sqlite-users at mailinglists.sqlite.org Subject: [sqlite] Unexpected ordering when index exists Hi sqlite mailing list, I'm experiencing unexpected ordering with a WHERE clause and an