Re: [sqlite] DISTINCT bug with 3.7.10

2012-03-05 Thread Steven Russell
Fri, 02 Mar 2012 19:00:30, Roger Binns wrote: > 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). >

[sqlite] DISTINCT bug with 3.7.10

2012-03-02 Thread Steven Russell
and 2 both only show up once). As a point of reference, the sqlite3 shell tool that ships with the OS (3.6.12) does produce the correct results. -- Steven Russell sruss...@extensis.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sql

[sqlite] SQLITE_ENABLE_LOCKING_STYLE status?

2008-03-14 Thread Steven Russell
I'm trying to use the network filesystem support on Mac OS X that is, to my understanding, enabled by the SQLITE_ENABLE_LOCKING_STYLE flag. As also noted by someone else in the archives of this list, I'm finding that Sqlite 3.5.6 won't compile with the flag defined. I noticed that there