Subject Re: Upgrading from IB6.0 to FB1.0
Author Alexander V.Nevsky
--- In ib-support@y..., "rodbracher" <rod@m...> wrote:
> Are there any hidden issues I will come across by anyone else's
> experience of doing such an upgrade? I am aware there may be one or
> two new reserved words ( knowing my luck I will have them in some
> primary key ! ) and things like ambiguous querys not allowed ( that
> should be sorted out anyway ) – are there any other things I should
> prepare myself for ( that may not be obvious on first use ) ?

Rod, from application programmer's point of view IB6.0x and FB1 are
close to be twins. Except of amount of bugs, of course, FB is much
more clean and slightly faster. I can't recall any other bug-dependent
code except mentioned ambigious queries and sequence of checks and
triggers. What about additional keywords - I can recall only
FIRST-SKIP, BREAK, CURRENT_ROLE.

> My system is fairly stable on IB6.0 – should I not wait out for
> FB2.0 ?

I think it should be more stable on FB1 than on IB6. FB2 is in
progress, I don't like predictions on speed of such processes, so I
think if you can't wait for some monthes, perhaps half a year, it is
reasonable to migrate to FB1. About

> "SFID 444463 Before Triggers were firing after checks".

It is'nt enough to change server, you should re-compile triggers
under FB.

Best regards, Alexander V.Nevsky.