--- In firebird-support@yahoogroups.com, Dmitry Yemanov <dimitr@...> wrote:

>
> ainpoissee wrote:
> >
> > I just ran into a problem with CURRENT_USER variable - following trigger worked OK with 2.1.0 but raises exception with 2.1.2:
>
> What exactly exception does it raise?

Sorry, I thought that this were obvious - it raises the user defined exception in the else clause - meaning that the user name was not found (in the select statement on the first line). But the user name is there and if I use "Trim(CURRENT_USER)" as opposed to just "CURRENT_USER" then it is found with FB2.1.2 too. So it looks like trailing spaces issue (CHAR vs VARCHAR)?


ain