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
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
