Updating recursive xml views of relations
This fix, done in v.2.0.1, should remove the problems encountered under these conditions.
The old “” limit on index size is gone for good, replaced by much-extended limits that depend on page size.Note that the 64-bit ports have been done and tested for AMD64 only. The Intel IA-64 platform is not supported in this release.A Free BSD port of the 64-bit builds has also been done.However, in the interim, the port of Firebird 2.0.3 to Solaris 2.10 (Solaris 10) has been completed for both Intel and SPARC platforms. It should not be necessary to revert databases to pre-2.0.2 state but, if you used EXECUTE STATEMENT to operate on varchars, varchar data written from results might have suffered truncation.Bugfix (CORE-1133) "The XNET (IPC) communication protocol would not work across session boundaries" affects those attempting to access databases using the local protocol on Windows Vista as well as those using remote terminal services locally on XP or Server 2003.Note also few backported improvements that are present in this release: A long-standing, legacy loophole in the handling of DPB parameters enabled ordinary users to make connection settings that could lead to database corruptions or give them access to SYSDBA-only operations.
The loophole has been closed, a change that could affect several existing applications, database tools and connectivity layers (drivers, components).
During Firebird 2.1 development it was discovered that Forced Writes had never worked on Linux, in either the Inter Base or the Firebird era.
That was fixed in V.2.1 and backported to this sub-release.
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.
Win64 hosts are running without problems and the MS VC8 final release seems to work satisfactorily, so we are able to say we are no longer hampered by problems with the Microsoft compiler.