Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Firing order of triggers with the same PRIORITY value

2 posts in Trigger Last posting was on 2008-11-06 16:27:40.0Z
Thomas Steinmaurer Posted on 2008-10-26 10:43:58.0Z
Date: Sun, 26 Oct 2008 11:43:58 +0100
From: Thomas Steinmaurer <t.steinmaurer_dontbugmewithspam_@upscene.com>
User-Agent: Thunderbird 2.0.0.17 (Windows/20080914)
MIME-Version: 1.0
Newsgroups: Advantage.Trigger
Subject: Firing order of triggers with the same PRIORITY value
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 212.241.89.51
Message-ID: <4904485c@solutions.advantagedatabase.com>
X-Trace: 26 Oct 2008 04:37:16 -0700, 212.241.89.51
Lines: 23
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!212.241.89.51
Xref: solutions.advantagedatabase.com Advantage.Trigger:414
Article PK: 1136475

Hello,

is the firing of triggers of the same event type with the same PRIORITY
somehow defined? E.g:

* By trigger name?
* By trigger creation order?

Or is it undefined, thus randomly?

Thanks!


--
Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2
Upscene Productions
http://www.upscene.com
My blog:
http://blog.upscene.com/thomas/


Mark Wilkins Posted on 2008-11-06 16:27:40.0Z
From: "Mark Wilkins" <mark@no.email>
Newsgroups: Advantage.Trigger
References: <4904485c@solutions.advantagedatabase.com>
Subject: Re: Firing order of triggers with the same PRIORITY value
Date: Thu, 6 Nov 2008 09:27:40 -0700
Lines: 39
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3350
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: 10.24.38.228
Message-ID: <4913197d@solutions.advantagedatabase.com>
X-Trace: 6 Nov 2008 09:21:17 -0700, 10.24.38.228
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!10.24.38.228
Xref: solutions.advantagedatabase.com Advantage.Trigger:416
Article PK: 1136477

Hi Thomas,

I believe it is undefined. The triggers are sorted based only on that
priority value. It does not use any other information. In this particular
case, it is an insertion sort and just stuffs it into the first spot that
meets the sort order, so the order will be "consistent" from run to run, but
you shouldn't depend on it since it could change in a subsequent release.
Or I think it could change if you removed a trigger and then re-added it.

Mark Wilkins
Advantage R&D

"Thomas Steinmaurer" <t.steinmaurer_dontbugmewithspam_@upscene.com> wrote in
message news:4904485c@solutions.advantagedatabase.com...
> Hello,
>
> is the firing of triggers of the same event type with the same PRIORITY
> somehow defined? E.g:
>
> * By trigger name?
> * By trigger creation order?
>
> Or is it undefined, thus randomly?
>
> Thanks!
>
>
> --
> Best Regards,
> Thomas Steinmaurer
> LogManager Series - Logging/Auditing Suites supporting
> InterBase, Firebird, Advantage Database, MS SQL Server and
> NexusDB V2
> Upscene Productions
> http://www.upscene.com
> My blog:
> http://blog.upscene.com/thomas/