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 for 3.5.9.


___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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.


These are not strictly recursive; the 'when' clause means that trigger 1
will cause trigger 2 to be called etc.


   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.


I think that should have worked though. Trigger 1 should have been able
to invoke trigger 2. However, trigger 2 could not then invoke trigger 1.
So you could say that there was a kind of stack, but no single trigger
could appear within it more than once.




___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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' clause means that trigger 1
> will cause trigger 2 to be called etc.

  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.

   -j

-- 
Jay A. Kreibich < J A Y  @  K R E I B I.C H >

"Intelligence is like underwear: it is important that you have it,
 but showing it to the wrong people has the tendency to make them
 feel uncomfortable." -- Angela Johnson
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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.

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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  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 version 3.6.18, 2009-09-11.


-- 
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users