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> 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 results are more comprehensible: > > OK> "1" "AB" > OK> "2" "CD" > OK> "4" "AB" > OK> "5" "CD" > > OK> So the sorting is connected to the existence of the index, I guess. > OK> Is this expected behavior or a bug? > > Without an ORDER BY clause, you can't expect or rely on any particular > ordering. > > Swithun. > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
