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
