On 16 Jul 2009, at 5:31pm, John Machin wrote:
> sqlite> create table foo (x, y, z);
> sqlite> insert into foo (x, y, x) values ('first', 'second', 'third');
> sqlite> insert into foo values ('first', 'second', 'third');
> sqlite> select * from foo;
> first|second|
> first|second|third
Interesting. I had expected the first row to be
third|second|
I bet the standard doesn't specify which value will be stored.
Simon.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
