Re: [sqlite] sqlite 3.7.8 and sqlite 3.7.9 crash with Apple Xcode 4.2.1 on armv6 ios device

[James Berry]

Gilles,

I haven't filed a bug on this, but from discussion with others it appears that 
Apple at least know about this compiler bug. I'm not at all sure that they 
intend to put the resources into fixing it any time soon: arm6 is an outdated 
architecture for them, as they haven't shipped devices with arm6 for a number 
of years. Furthermore, there is little good argument for using thumb mode with 
arm6, as it really hurts floating point performance on arm6, given that 
floating point must be emulated. Given those reasons, I suspect that this is 
not a high priority for Apple to fix.

James


On Nov 30, 2011, at 11:04 PM, Gilles Vollant wrote:

> Thank you a lot for your answer.
> Do you known more about this bug? Is there any other documentation?
> Does it affect other code? Will apple fix it soon?
> 
> My currenct solution was using sqlite 3.7.1
> 
> Regards
> Gilles Vollant
> 
> 
> Le jeudi 1 décembre 2011, James Berry  a écrit :
>> Gilles,
>> 
>> This is due to bugs in llvm when compiling for arm6 with thumb mode
> enabled. Passing -mno-thumb to the compiler will solve the problem.
>> 
>> James
>> 
>> On Nov 30, 2011, at 4:31 PM, Gilles Vollant wrote:
>> 
>>> Hello,
>>> 
>>> I'm using a recompiled version of SQLite in one project (I need FTS3 and
> now
>>> FTS4 support, which is not avaiable in the sqlite included in iOS).
>>> So I just include "sqlite3.c" and "sqlite3.h" in my XCode projet.
>>> 
>>> I've discovered that using LLVM compiler of Xcode 4.2.1 on Mac OS Lion
>>> targeting armv6 (the project must be compatible with iPhone 3G) with
>>> optimisation has a bug with sqLite source.
>>> 
>>> Please note that :
>>> - sqlite 3.7.7.1 has no problem, sqlite 3.7.8 and sqlite 3.7.9 has the
>>> problem
>>> - there is no problem with armv7 (iPhone 3GS and higher) compiler
>>> - there is no problem in debug mode (or release with optimization fully
>>> disabled)
>>> - there is no problem with old xcode 4.0 and GCC 4.2 compiler
>>> 
>>> 
>>> you can download this project, do a Release build to iOS device and start
> on
>>> iOS device, then tap on the "i". This demo application crash in very
> simple
>>> sql code.
>>> (it crashes when compiling a very simple SQL command):
>>> 
>>> http://gvollant.free.fr/sqliteCrashXcode.zip
>>> 
>>> I used
>>> 
>>> http://sqlite.org/sqlite-amalgamation-3070900.zip : latest SQLite 3.7.9
>>> which crashes
>>> http://sqlite.org/sqlite-amalgamation-3070800.zip : SQLite 3.7.8 which
>>> crashes
>>> http://sqlite.org/sqlite-amalgamation-3070701.zip : SQLite 3.7.7.1 which
> run
>>> well
>>> 
>>> ___
>>> sqlite-users mailing list
>>> sqlite-users@sqlite.org
>>> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>> 
>> ___
>> sqlite-users mailing list
>> sqlite-users@sqlite.org
>> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>> 
> 

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

Re: [sqlite] sqlite 3.7.8 and sqlite 3.7.9 crash with Apple Xcode 4.2.1 on armv6 ios device

[sq sq]

Le jeudi 1 décembre 2011, James Berry  a écrit :
> Gilles,
>
> This is due to bugs in llvm when compiling for arm6 with thumb mode
enabled. Passing -mno-thumb to the compiler will solve the problem.
>
> James
>
> On Nov 30, 2011, at 4:31 PM, Gilles Vollant wrote:
>
>> Hello,
>>
>> I'm using a recompiled version of SQLite in one project (I need FTS3 and
now
>> FTS4 support, which is not avaiable in the sqlite included in iOS).
>> So I just include "sqlite3.c" and "sqlite3.h" in my XCode projet.
>>
>> I've discovered that using LLVM compiler of Xcode 4.2.1 on Mac OS Lion
>> targeting armv6 (the project must be compatible with iPhone 3G) with
>> optimisation has a bug with sqLite source.
>>
>> Please note that :
>> - sqlite 3.7.7.1 has no problem, sqlite 3.7.8 and sqlite 3.7.9 has the
>> problem
>> - there is no problem with armv7 (iPhone 3GS and higher) compiler
>> - there is no problem in debug mode (or release with optimization fully
>> disabled)
>> - there is no problem with old xcode 4.0 and GCC 4.2 compiler
>>
>>
>> you can download this project, do a Release build to iOS device and
start on
>> iOS device, then tap on the "i". This demo application crash in very
simple
>> sql code.
>> (it crashes when compiling a very simple SQL command):
>>
>> http://gvollant.free.fr/sqliteCrashXcode.zip
>>
>> I used
>>
>> http://sqlite.org/sqlite-amalgamation-3070900.zip : latest SQLite 3.7.9
>> which crashes
>> http://sqlite.org/sqlite-amalgamation-3070800.zip : SQLite 3.7.8 which
>> crashes
>> http://sqlite.org/sqlite-amalgamation-3070701.zip : SQLite 3.7.7.1 which
run
>> well
>>
>> ___
>> sqlite-users mailing list
>> sqlite-users@sqlite.org
>> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] sqlite 3.7.8 and sqlite 3.7.9 crash with Apple Xcode 4.2.1 on armv6 ios device

[James Berry]

(you only need to turn off thumb mode for the arm6 architecture) -jdb

On Nov 30, 2011, at 8:02 PM, James Berry wrote:

> Gilles,
> 
> This is due to bugs in llvm when compiling for arm6 with thumb mode enabled. 
> Passing -mno-thumb to the compiler will solve the problem.
> 
> James
> 
> On Nov 30, 2011, at 4:31 PM, Gilles Vollant wrote:
> 
>> Hello,
>> 
>> I'm using a recompiled version of SQLite in one project (I need FTS3 and now
>> FTS4 support, which is not avaiable in the sqlite included in iOS).
>> So I just include "sqlite3.c" and "sqlite3.h" in my XCode projet.
>> 
>> I've discovered that using LLVM compiler of Xcode 4.2.1 on Mac OS Lion
>> targeting armv6 (the project must be compatible with iPhone 3G) with
>> optimisation has a bug with sqLite source.
>> 
>> Please note that :
>> - sqlite 3.7.7.1 has no problem, sqlite 3.7.8 and sqlite 3.7.9 has the
>> problem
>> - there is no problem with armv7 (iPhone 3GS and higher) compiler
>> - there is no problem in debug mode (or release with optimization fully
>> disabled)
>> - there is no problem with old xcode 4.0 and GCC 4.2 compiler
>> 
>> 
>> you can download this project, do a Release build to iOS device and start on
>> iOS device, then tap on the "i". This demo application crash in very simple
>> sql code.
>> (it crashes when compiling a very simple SQL command):
>> 
>> http://gvollant.free.fr/sqliteCrashXcode.zip
>> 
>> I used
>> 
>> http://sqlite.org/sqlite-amalgamation-3070900.zip : latest SQLite 3.7.9
>> which crashes
>> http://sqlite.org/sqlite-amalgamation-3070800.zip : SQLite 3.7.8 which
>> crashes
>> http://sqlite.org/sqlite-amalgamation-3070701.zip : SQLite 3.7.7.1 which run
>> well
>> 
>> ___
>> sqlite-users mailing list
>> sqlite-users@sqlite.org
>> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> 
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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

Re: [sqlite] sqlite 3.7.8 and sqlite 3.7.9 crash with Apple Xcode 4.2.1 on armv6 ios device

[James Berry]

Gilles,

This is due to bugs in llvm when compiling for arm6 with thumb mode enabled. 
Passing -mno-thumb to the compiler will solve the problem.

James

On Nov 30, 2011, at 4:31 PM, Gilles Vollant wrote:

> Hello,
> 
> I'm using a recompiled version of SQLite in one project (I need FTS3 and now
> FTS4 support, which is not avaiable in the sqlite included in iOS).
> So I just include "sqlite3.c" and "sqlite3.h" in my XCode projet.
> 
> I've discovered that using LLVM compiler of Xcode 4.2.1 on Mac OS Lion
> targeting armv6 (the project must be compatible with iPhone 3G) with
> optimisation has a bug with sqLite source.
> 
> Please note that :
> - sqlite 3.7.7.1 has no problem, sqlite 3.7.8 and sqlite 3.7.9 has the
> problem
> - there is no problem with armv7 (iPhone 3GS and higher) compiler
> - there is no problem in debug mode (or release with optimization fully
> disabled)
> - there is no problem with old xcode 4.0 and GCC 4.2 compiler
> 
> 
> you can download this project, do a Release build to iOS device and start on
> iOS device, then tap on the "i". This demo application crash in very simple
> sql code.
> (it crashes when compiling a very simple SQL command):
> 
> http://gvollant.free.fr/sqliteCrashXcode.zip
> 
> I used
> 
> http://sqlite.org/sqlite-amalgamation-3070900.zip : latest SQLite 3.7.9
> which crashes
> http://sqlite.org/sqlite-amalgamation-3070800.zip : SQLite 3.7.8 which
> crashes
> http://sqlite.org/sqlite-amalgamation-3070701.zip : SQLite 3.7.7.1 which run
> well
> 
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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