> On 8/25/15, V.Krishn 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