Re: [sqlite] EXT :Re: long insert statement failing on iPhone

2011-03-02 Thread Jean-Denis Muys
On 1 mars 2011, at 21:11, Mickey Mestel wrote: hi all, i've just discovered that the bug is there when compiling with the LLVM compiler 1.6, which comes as a standard compiler with the iOS SDK, and is the direction that Apple is moving towards. the problem is NOT there when

Re: [sqlite] EXT :Re: long insert statement failing on iPhone

2011-03-01 Thread Black, Michael (IS)
:Re: long insert statement failing on iPhone michael, No such thing as close enough when it comes to different versions. i do agree, although having tried 3 different version with exactly the same behavior, i don't expect 3.6.23.2 to act any different, although you never know. Can

Re: [sqlite] EXT :Re: long insert statement failing on iPhone

2011-03-01 Thread Mickey Mestel
michael, Have you run your test with and without crypto? If Apple can compile 3.6.23.2 to work you should be able to also (might be overly optimistic here but compilers are 100% deterministic, although not necessartiliy 100% binary match). we have encrypted and read a database

Re: [sqlite] EXT :Re: long insert statement failing on iPhone

2011-03-01 Thread Pavel Ivanov
       i also took the same statement and tried to run it in our app in a method called as soon as the application launches, and it fails.  so we have something going on at a different level. I suspect that as soon as the application launches means that no parallel threads are working yet

Re: [sqlite] EXT :Re: long insert statement failing on iPhone

2011-03-01 Thread Mickey Mestel
hi all, i've just discovered that the bug is there when compiling with the LLVM compiler 1.6, which comes as a standard compiler with the iOS SDK, and is the direction that Apple is moving towards. the problem is NOT there when compiling with GCC 4.2. the problem is

Re: [sqlite] EXT :Re: long insert statement failing on iPhone

2011-03-01 Thread Mickey Mestel
pavel, I suspect that as soon as the application launches means that no parallel threads are working yet (if they work already then look into what those threads are doing). Then the problem could be in some linking issues. E.g. you have some function that is named the same as some library

Re: [sqlite] EXT :Re: long insert statement failing on iPhone

2011-02-28 Thread Black, Michael (IS)
-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on behalf of Mickey Mestel [mmes...@epocrates.com] Sent: Monday, February 28, 2011 12:34 PM To: General Discussion of SQLite Database Subject: EXT :Re: [sqlite] long insert statement failing on iPhone simon, The theory is that you

Re: [sqlite] EXT :Re: long insert statement failing on iPhone

2011-02-28 Thread Simon Slavin
On 28 Feb 2011, at 7:36pm, Black, Michael (IS) wrote: Well that's one you never mentioned...it works on the version with the SDK? What version of sqlite comes with that? And why are you upgrading sqlite? Note that this problem does /not/ happen if he accesses SQLite by calling the version

Re: [sqlite] EXT :Re: long insert statement failing on iPhone

2011-02-28 Thread Mickey Mestel
michael, Well that's one you never mentioned...it works on the version with the SDK? it's on the second to last line of my original message, an easy place to miss. i should have put it in a more prominent place, as it is key. What version of sqlite comes with that? And why are you

Re: [sqlite] EXT :Re: long insert statement failing on iPhone

2011-02-28 Thread Mickey Mestel
Note that this problem does /not/ happen if he accesses SQLite by calling the version included in the iPhone frameworks. I still don't have a clue what his problem is, but whatever it is it's not simple. correct. and i agree, it probably isn't simple:-( mickm

Re: [sqlite] EXT :Re: long insert statement failing on iPhone

2011-02-28 Thread Black, Michael (IS)
[sqlite-users-boun...@sqlite.org] on behalf of Mickey Mestel [mmes...@epocrates.com] Sent: Monday, February 28, 2011 3:03 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] EXT :Re: long insert statement failing on iPhone michael, Well that's one you never mentioned...it works

Re: [sqlite] EXT :Re: long insert statement failing on iPhone

2011-02-28 Thread Mickey Mestel
michael, No such thing as close enough when it comes to different versions. i do agree, although having tried 3 different version with exactly the same behavior, i don't expect 3.6.23.2 to act any different, although you never know. Can somebody find the 3.6.23.2 amalgamation for