On 3 Mar 2012, at 12:46am, Larry Brasfield <larry_brasfi...@iinet.com> wrote:

>> On 3 Mar 2012, at 12:29am, Larry Brasfield <larry_brasfield at iinet.com> 
>> 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 for narrowing what is happening.  Also, the 
>> > preprocessor settings may be the whole problem, one which can be quickly 
>> > diagnosed for you if they are revealed.
>> 
>> 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 that looks like either a SQLite code 
> error or a gcc code generation error, the optimization settings are also 
> likely to be needed, and those are not susceptible to that PRAGMA's behavior.

Don't forget this isn't is own weird project which may be using the API in an 
unusual way.  It's the shell tool.  Possibly even a the version downloaded from 
the SQLite web site.  Given how clear the bug is, with the addition of the 
bug-reporter's 'PRAGMA compile_options;', I think that's enough information to 
let the team try to reproduce the behaviour and see what happens.

By the way, this shell tool included with a recent version of OS X does not 
have the problem.

162:~ simon$ which sqlite3
/usr/bin/sqlite3
SQLite version 3.7.7 2011-10-10 22:11:44
sqlite> PRAGMA compile_options;
ENABLE_FTS3
ENABLE_FTS3_PARENTHESIS
ENABLE_LOCKING_STYLE=1
ENABLE_RTREE
OMIT_AUTORESET
OMIT_BUILTIN_TEST
OMIT_LOAD_EXTENSION
TEMP_STORE=1
THREADSAFE=2

Simon.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to