Subject Re: [firebird-support] Update database to new version?
Author Helen Borrie
At 01:17 PM 26/07/2004 +0100, you wrote:
>Do you need to do anything to update your database to make it use the newer
>version of Firebird, when you install 1.5?

Where does "need" end and "want" begin? If you upgrade your db to Firebird
1.5's ODS 10.1, you can take advantage of performance enhancements stemming
from indexing having been added to some of the system tables...there are
also some handy 10.1 features you might want to use, such as being able to
have descending indexes on primary keys, nulls in unique constraints,
separate custom names for constraints and their supporting indexes, et al.

Re the SQL problems - they're not from using IBX, per se, but from Fb 1.5
being stricter about enforcing legal SQL, particularly noticeable with
GROUP BY and ORDER BY criteria. You won't get away with ignoring the
release notes. :-)