Re: [sqlite] A question about the ancient history of SQLite triggers

2013-03-06 Thread Philip Warner
On 6/03/2013 1:59 AM, Jay A. Kreibich wrote: In this case, it is any trigger that invokes any other trigger. Prior to 3.6.18 there was no trigger stack and triggers could be only one layer deep. Ah, thanks. That solves the problem. I can dynamically generate a single inefficient trigger

Re: [sqlite] A question about the ancient history of SQLite triggers

2013-03-05 Thread Richard Hipp
On Tue, Mar 5, 2013 at 1:11 AM, Philip Warner p...@rhyme.com.au wrote: What I am seeing in 3.5.9 on Android is that the triggers are executed precisely once each, rather than once for each row. Recursive triggers (triggers that invoke themselves either directly or indirectly) were added in

Re: [sqlite] A question about the ancient history of SQLite triggers

2013-03-05 Thread Philip Warner
On 5/03/2013 9:53 PM, Richard Hipp wrote: Recursive triggers (triggers that invoke themselves either directly or indirectly) were added in version 3.6.18, 2009-09-11. These are not strictly recursive; the 'when' clause means that trigger 1 will cause trigger 2 to be called etc.

Re: [sqlite] A question about the ancient history of SQLite triggers

2013-03-05 Thread Jay A. Kreibich
On Tue, Mar 05, 2013 at 11:20:27PM +1100, Philip Warner scratched on the wall: On 5/03/2013 9:53 PM, Richard Hipp wrote: Recursive triggers (triggers that invoke themselves either directly or indirectly) were added in version 3.6.18, 2009-09-11. These are not strictly recursive; the 'when'

Re: [sqlite] A question about the ancient history of SQLite triggers

2013-03-05 Thread Dan Kennedy
On 03/05/2013 09:59 PM, Jay A. Kreibich wrote: On Tue, Mar 05, 2013 at 11:20:27PM +1100, Philip Warner scratched on the wall: On 5/03/2013 9:53 PM, Richard Hipp wrote: Recursive triggers (triggers that invoke themselves either directly or indirectly) were added in version 3.6.18, 2009-09-11.