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 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. -- D. Richard Hipp drh at sqlite.org
