It is as expected, data type constraints are enforced before all other operations.
What would be the purpose of firing a trigger if the data is not valid? Sean From: [email protected] [mailto:[email protected]] On Behalf Of W O Sent: Thursday, September 19, 2013 12:00 PM To: [email protected] Subject: Re: [firebird-support] Why IN AUTONOMOUS TRANSACTION doesnt work here? That's right, the trigger never fires when the column is VARCHAR(20) and the lenght of data is greater than 20. Is that a bug or it works as expected? Greetings. Walter. On Thu, Sep 19, 2013 at 10:28 AM, Mark Rotteveel <[email protected]<mailto:[email protected]>> wrote: On 19-9-2013 15:58, Alan McDonald wrote: > Use an external table to log errors. They are not subject to > transactions. But if the trigger doesn't fire, that won't help. Mark -- Mark Rotteveel
