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). > > BTW the team agreed it

Re: [sqlite] DISTINCT bug with 3.7.10

2012-03-02 Thread Roger Binns
-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

Re: [sqlite] DISTINCT bug with 3.7.10

2012-03-02 Thread Larry Brasfield
Simon Slavin wrote and quoted: >> Would the output of 'PRAGMA compile_options;' be sufficient ? > > That's a cute and useful feature I had forgotten. It would be sufficient to show the preprocessor variable values that were in effect as the amalgamation was compiled. However, for something th

Re: [sqlite] DISTINCT bug with 3.7.10

2012-03-02 Thread Simon Slavin
On 3 Mar 2012, at 12:46am, Larry Brasfield wrote: >> On 3 Mar 2012, at 12:29am, Larry Brasfield >> wrote: >> >> > That's approaching a pretty good "bug" report. However, I would suggest a >> > little more to promote a resolution of this problem. You do not state the >> > compilation optio

Re: [sqlite] DISTINCT bug with 3.7.10

2012-03-02 Thread Larry Brasfield
On 3 Mar 2012, at 12:29am, Larry Brasfield wrote: > That's approaching a pretty good "bug" report. However, I would suggest a little more to promote a resolution of this problem. You do not state the compilation options. Optimization settings and preprocessor variable settings are critical

Re: [sqlite] DISTINCT bug with 3.7.10

2012-03-02 Thread Simon Slavin
On 3 Mar 2012, at 12:29am, Larry Brasfield wrote: > That's approaching a pretty good "bug" report. However, I would suggest a > little more to promote a resolution of this problem. You do not state the > compilation options. Optimization settings and preprocessor variable > settings are cr

Re: [sqlite] DISTINCT bug with 3.7.10

2012-03-02 Thread Larry Brasfield
Steven Russell wrote: I just grabbed the 3.7.10 amalgamation source and built it, but have run into an issue where DISTINCT doesn't appear to actually return distinct values on a table that includes a UNIQUE clause. It unexpectedly returns duplicates instead. My build environment is: - Mac

[sqlite] DISTINCT bug with 3.7.10

2012-03-02 Thread Steven Russell
I just grabbed the 3.7.10 amalgamation source and built it, but have run into an issue where DISTINCT doesn't appear to actually return distinct values on a table that includes a UNIQUE clause. It unexpectedly returns duplicates instead. My build environment is: - Mac OS X 10.6.8 - Xcode 3.2