> On 8/25/15, V.Krishn <vkrishn4 at gmail.com> wrote: > > Hi, > > > > Will there be any issue if SQLITE_ENABLE_UPDATE_DELETE_LIMIT was enabled > > by > > > > default ? > > ( I understand it cannot be used in triggers even though ) > > That won't work with the amalgamation (sqlite3.c). You have to > download the canonical source code and build it from scratch, editing > the Makefile to insert the extra -DSQLITE_ENABLE_UPDATE_DELETE_LIMIT. > > Note that SQLITE_ENABLE_UPDATE_DELETE_LIMIT is one of the compile-time > options for SQLite that *is* extensively and rigorously tested prior
Thanks, that helped. Downloaded sqlite-src-3081101.zip exported -DSQLITE_ENABLE_UPDATE_DELETE_LIMIT in CFLAGS and compiled. Works now. > to every release. So there shouldn't be any issues - other than the > fact that you have to go to the extra trouble of compiling from > canonical sources. Though I had removed all Limit in Update routines from my previous application, I think I would let it stay that way unless becomes necessary. Secondly, don't know how other distros would pkg sqlite3, atleast it was enabled in my test on Knoppix. -- Regards. V.Krishn