-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 02/03/12 15:20, Steven Russell wrote: > I obviously don't expect the duplicate results here. If you create the > table without the UNIQUE clause, then the results are as expected (1 > and 2 both only show up once).
BTW the team agreed it was a bug, created a ticket, fixed it and added it to the test suite. For some reason they don't tend to mention this on the mailing list. If you follow the timeline you can tell. http://www.sqlite.org/src/info/3557ad65a0 Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.11 (GNU/Linux) iEYEARECAAYFAk9RiU4ACgkQmOOfHg372QQ2UACeMM1hQi7pIctdSHwTVJx+h4R/ FtcAoJvexerIIuyuT2eX428cmIFH+kT4 =s4jH -----END PGP SIGNATURE----- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
