[sqlite] Enable SQLITE_ENABLE_UPDATE_DELETE_LIMIT by default

2015-08-26 Thread V.Krishn
> 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


[sqlite] Enable SQLITE_ENABLE_UPDATE_DELETE_LIMIT by default

2015-08-26 Thread V.Krishn

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 )

-- 
Regards.
V.Krishn


[sqlite] Enable SQLITE_ENABLE_UPDATE_DELETE_LIMIT by default

2015-08-25 Thread Richard Hipp
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
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