[sqlite] Bug in select from tables with unique constraint?

2009-12-16 Thread WClark
Hi people, I think I may have found a bug in v3.6.21 of Sqlite, but would someone be able to kindly verify my findings for me. If I do the following... CREATE TABLE t1 (c1 TEXT UNIQUE); CREATE TABLE t2 (c2 TEXT UNIQUE); INSERT INTO t1(c1) SELECT a UNION ALL SELECT b; INSERT INTO t2(c2)

Re: [sqlite] Bug in select from tables with unique constraint?

2009-12-16 Thread WClark
Hello again, I have also checked this with 3.6.17 (which works) and 3.6.18 (which doesn't), so it may be something that slipped in between these two versions. In case it is helpful, I'm running of the release checkouts from the fossil repository. The configure is called with