well, this doesn't seem to be a stack size issue. i put the long insert statement on it's own thread, but first increased the stack size to 1024k from the initial 512k, and no difference.
> My first (and only) reaction is "bug in your code" overrunning a char buffer. > > If you could show where you do this maybe we can help. Problem is that it > could be another statement doing the overrun too so as much code as you could > share would help. > > Michael D. Black > Senior Scientist > NG Information Systems > Advanced Analytics Directorate > > > > ________________________________________ > From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on > behalf of Mickey Mestel [mmes...@epocrates.com] > Sent: Friday, February 25, 2011 8:37 PM > To: sqlite-users@sqlite.org > Subject: EXT :[sqlite] long insert statement failing on iPhone > > hi all, > > new to the list. > > we are compiling the sqlite.c amalgamation file into our project, as > we want to encrypt the database, and the sqlite that comes with the iOS sdk > does not allow for that. > > we are developing on iOS 4.2, and to date have tried 3 different > versions of sqlite.c, all of which have the same effect. > > the issue is that when we prepare a statement like: > > insert into tablename (foo, foo1, foo2) values (?,?,?) > > and that statement is longer that roughly 250 characters, the table > name and sometimes the column name are getting munged, most often over > written with one of the column names in the table, or column list in the > statement, wherever it is getting it from. > > i've just started on this problem, so i may not yet have a lot of > details, but by the time we are in yy_reduce() and calling sqlite3Insert(), > the corruption has already taken place. so i'm trying to trace this back and > see what is going on. > > this only happens on the device, not the simulator, unfortunately. > the sqlite library that comes with iOS does not exhibit this behavior. > > any thoughts or pointers or help? > > thanks, > > mickm > _______________________________________________ > 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
