Validating conflict avoiding and volatile Online cams
It will become publicly available in a subsequent v.2.x release.
Although the capability to run multiple Firebird servers simultaneously on a single host has been present since Firebird 1.5, we still do not provide the ability to set them up through our installer programs and scripts.
Calculation of index statistics has been revamped to improve the choices the optimizer has available, especially for complex outer join distributions and DISTINCT queries.
Many new additions have been made to the SQL language, including support for derived tables (SELECT ... FROM), PSQL blocks in dynamic SQL through the new EXECUTE BLOCK syntax and some handy new extensions in PSQL itself.
64-bit builds for both Superserver and Classic are ready and available for installing on Linux.Of special note are the fixes for the validation and shutdown issues described below in the Known Issues for V.2.0.5.The Tracker ticket numbers are CORE-2271 and CORE-2846, respectively.Make transportable gbak backups of your existing databases--including your old or (even older) isc4security databases-- you uninstall the older Firebird server and set out to install Firebird 2.0.Before you proceed, restore these backups in a temporary location, using the old gbak, and verify that the backups are good.
Naturally, with so much bug-removal and closing of holes, there are sure to be things that worked before and now no longer work.