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;
-----

(result prior 3.7.15)
-----
1|foo|2000
2|bar|2001
foo
bar
-----

(result 3.7.15 and newer)
-----
1|foo|2000
2|bar|2001
bar
foo
-----
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to