On Sun, 14 Apr 2013 01:22:46 +0900, kenichi ishigaki wrote: > Hi. > > I received a report that the result of the following SQL has changed > since 3.7.15. > I haven't looked into the sqlite source yet, but can we call this a bug? > > Regards, > > Kenichi Ishigaki > > ----- > create table cd (id integer primary key, title unique, year); > insert into cd (title, year) values ('foo', 2000); > insert into cd (title, year) values ('bar', 2001); > select * from cd; > select title from cd;
If you don't specify "order by", *any* relational db will return the results in any order it chooses. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users