What's wrong with adding new code to existing triggers instead of creating new ones?
Pavel On Tue, Mar 2, 2010 at 3:38 PM, Jens Frøkjær <j...@frokjaer.net> wrote: > Hi, > Sorry to BUMP this thread. I was hoping someone would come along with a > better answer. > This means that executing the same deterministic piece of SQL on two > identical databases could yield different results. And I don't mean > different in "order of rows in tables" or something similar. My databases > would not contain the same data. Not close. This seems quite frighting to > me. > Is this something there could be an interest in changing? I don't request > any specific order. SQLite-developers, define an order, any order. Document > it, and stick with it. Thats all I want for Christmas. > So, please consider this a feature request: "Deterministic order of > triggers". > -- > Jens F! > > > On Mon, Feb 22, 2010 at 10:17 PM, Pavel Ivanov <paiva...@gmail.com> wrote: >> >> I cannot find right now details on this in SQLite documentation but >> AFAIK order of triggers execution is undefined and you cannot rely on >> any of them. >> >> >> Pavel >> >> On Mon, Feb 22, 2010 at 3:15 PM, Jens Frøkjær <j...@frokjaer.net> wrote: >> > Hi, >> > >> > I was wondering in what order triggers are executed. I'm using the after >> > update, and have both "column-based" and "row-based" triggers. By >> > column-based, i simply mean triggers that only fire if a specific column >> > is >> > updated. >> > >> > I did a bit of googling myself, and came up with [1]. It is pretty >> > clear, >> > triggers should be executed alphabetically. That actually seemes like a >> > great idea, because, then I have full control. I also did my own >> > testing, >> > which turned up reverse-creating ordering. That means, the newest >> > created >> > trigger is called first. >> > >> > Is the order actually fixed, or can it be "any order"? And if it is >> > fixed, >> > can I, to some degree, trust that it will not change in future relases? >> > >> > [1]: http://code.google.com/p/sqlite-fk-triggers/wiki/TriggerOrder >> > >> > Best regards, >> > Jens F! >> > _______________________________________________ >> > sqlite-users mailing list >> > sqlite-users@sqlite.org >> > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> > > > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
