whatsnew.txt

嵌入式InterBase

        Locking and performance issues in win32 CS.
      Contributor(s):
        Nickolay Samofatov <skidder at bssys.com>

    * Fixed Beta 4 bug.
        Error during backup with "ignore in-limbo transactions" option.
      Contributor(s):
        Dmitry Yemanov <yemanov at yandex.ru>

    * Fixed unregistered bug.
        Server crashes in some Services API operations.
      Contributor(s):
        Arno Brinkman <firebird at abvisie.nl>

    * Fixed Beta 4 bug.
        Problems with IP address in connection strings.
      Contributor(s):
        Dmitry Yemanov <yemanov at yandex.ru>

    * Fixed Beta 4 bug.
        Compatibility problems with new IBX versions.
      Contributor(s):
        Dmitry Yemanov <yemanov at yandex.ru>

    * Fixed Beta 4 bug.
        EXECUTE STATEMENT: numeric variables and dialect 3 databases.
      Contributor(s):
        Alexander Peshkoff <peshkoff at hotmail.ru>

    * Advanced security abilities.
        Implemented configurable access for databases, external tables and UDF libraries.
      Contributor(s):
        Alexander Peshkoff <peshkoff at hotmail.ru>

    * Fixed resource/memory leaks.
      Contributor(s):
        Mike Nordell <tamlin at algonet.se>
        Alexander Peshkoff <peshkoff at hotmail.ru>
        Nickolay Samofatov <skidder at bssys.com>
        Dmitry Yemanov <yemanov at yandex.ru>

    * Fixed unregistered bug.
        Buffer overrun with multidimensional arrays.
      Contributor(s):
        Dmitry Yemanov <yemanov at yandex.ru>

    * Fixed Beta 4 bug.
        RECREATE VIEW with check option.
      Contributor(s):
        Dmitry Yemanov <yemanov at yandex.ru>

    * Fixed Beta 4 bug.
        Problems with loading INTL plugins.
      Contributor(s):
        Mike Nordell <tamlin at algonet.se>

  **************
  * v1.5 Beta 4
  **************

    * Fixed bugs SF #213460, #678718.
        Various issues with events used on multihomed hosts.
      Note:
        Now it's also possible to setup a definite port for event processing.
      Contributor(s):
        Dmitry Yemanov <yemanov at yandex.ru>

    * Fixed some resource leaks.
      Contributor(s):
        Mike Nordell <tamlin at algonet.se>
        Alexander Peshkoff <peshkoff at hotmail.ru>

    * Fixed Beta 3 bug.
        Bug with an aggregate sub-query inside a IN clause.
      Contributor(s):
        Arno Brinkman <firebird at abvisie.nl>

    * Fixed Services API.
        Enabled Services API for posix CS builds.
      Notes:
        1. Appropriate changes in Win32 CS are not ready yet
        2. Backup/restore service was fixed, tested and should work 
        3. Database validation was partially fixed and may work 
        4. Other services are probably non-functional in CS builds yet
      Contributor(s):
        Nickolay Samofatov <skidder at bssys.com>

    * SQL enhancement.
        Allowed NULLs in unique constraints and indices (SQL-99 spec).
      Contributor(s):
        Dmitry Yemanov <yemanov at yandex.ru>
        Nickolay Samofatov <skidder at bssys.com>

    * Fixed Beta 3 bug.
        Problems with RECREATE VIEW.
      Contributor(s):
        Dmitry Yemanov <yemanov at yandex.ru>

    * Performance improvement.
        VIO undo log now uses B+ tree to store savepoint record data. It improves performance when doing multiple updates of
        record in a single transaction just a little (usually 2-3 orders of magnitude for 100000 records).
      Contributor(s):
        Nickolay Samofatov <skidder at bssys.com>

    * Fixed unregistered bug.
        Database corruption when backing out the savepoint after large number of DML operations
        (so transaction-level savepoint is dropped) and record was updated _not_ under the savepoint and deleted under savepoint.
      Contributor(s):
        Nickolay Samofatov <skidder at bssys.com>
        
    * Improved EXECUTE STATEMENT.
        Now it's possible to return values from the dynamic SQL.
      Syntax:
        EXECUTE STATEMENT <value> INTO <var_list>; (singleton form)
        or
        FOR EXECUTE STATEMENT <value> INTO <var_list> DO <stmt_list>;
      Contributor(s):
        Alexander Peshkoff <peshkoff at hotmail.ru>

    * Fixed Beta 3 bug.
        With a large amount of SQL the server crashed on generating BLR.
      Contributor(s):
        Arno Brinkman <firebird at abvisie.nl>

  **************
  * v1.5 Beta 3
  **************

    * Fixed Beta 2 bug.
        EXECUTE STATEMENT doesn't work in autocommit transactions.
      Contributor(s):
        Dmitry Yemanov <yemanov at yandex.ru>

    * Fixed Beta 2 bug.
        Server crashes due to problems in the optimizer.
      Contributor(s):
        Arno Brinkman <firebird at abvisie.nl>

    * Fixed Beta 2 bug.
        Minor ODS upgrade is no longer critical. Now you can attach any ODS 10.0 database without errors (no need to backup/restore).
      Contributor(s):
        Dmitry Yemanov <yemanov at yandex.ru>

    * Fixed Beta 2 bug.
        "Wrong page type" error during some DDL operations.
      Contributor(s):
        Dmitry Yemanov <yemanov at yandex.ru>

    * Fixed unregistered bug.
        Server hangs during disconnect after mass updates.
      Contributor(s):
        Dmitry Yemanov <yemanov at yandex.ru>

    * Improved optimizer.
        Sub-selects in SET clause of UPDATE now can use indices.
      Contributor(s):
        Arno Brinkman <firebird at abvisie.nl>

    * Fixed unregistered bug.
        "Context already in use" error in the case of DISTINCT with sub-selects.
      Contributor(s):
        Arno Brinkman <firebird at abvisie.nl>

    * Enhanced isc_database_info abilities.
        List of currently active transactions is now available via isc_database_info call.
      Contributor(s):
        Nickolay Samofatov <skidder at bssys.com>

    * Fixed Beta 2 bug.
        ISQL cannot work with scripts containing character code 0xFF.
      Contributor(s):
        Dmitry Yemanov <yemanov at yandex.ru>

    * Fixed Beta 2 bug.
        Ineffective PLANs made by the optimizer for SPs and views.
      Contributor(s):
        Arno Brinkman <firebird at abvisie.nl>

    * Performance improvement.
        Shortcut boolean evaluation.
      Note:
        The behaviour is controlled by "CompleteBooleanEvaluation" option of firebird.conf. Default is 0 (shortcut evaluation).
      Contributor(s):
        Mike Nordell <tamlin at algonet.se>

    * Fixed Beta 2 bug.
        Stack overflow during statement preparation.
      Contributor(s):
        Dmitry Yemanov <yemanov at yandex.ru>
        Mike Nordell <tamlin at algonet.se>

    * Performance improvement.
        Speed-up for index operations (IA32 CPU architecture only)
      Contributor(s):
        Mike Nordell <tamlin at algonet.se>

    * Fixed Beta 2 bug.
        Wrong record operation statistics.
      Contributor(s):
        Evgeny Kilin <john at citycard.izhnet.ru>
        Dmitry Yemanov <yemanov at yandex.ru>

    * Fixed Beta 2 bug.
        Wrong line-number statistics in DSQL.
      Contributor(s):
        Nickolay Samofatov <skidder at bssys.com>

    * Fixed Beta 2 bug.
        Server crashes during some operations.
      Contributor(s):
        Alexander Peshkoff <peshkoff at hotmail.ru>

    * Change in universal triggers.
        Allowed access to both (OLD and NEW) contexts in universal triggers.
      Contributor(s):
        Dmitry Yemanov <yemanov at yandex.ru>

    * Improved optimizer.
        When an equal-node and other nodes (geq, leq, between...) are available for an index retrieval, then use the equal node always instead of the others.
      Contributor(s):
        Arno Brinkman <firebird at abvisie.nl>

    * Fixed unregistered bug.
        Long delays during connecting/disconnecting on WinXP.
      Contributor(s):
        Arno Brinkman <firebird at abvisie.nl>

    * Fixed Beta 2 bug.
        Server crash during service manager operations.
      Contributor(s):
        Dmitry Yemanov <yemanov at yandex.ru>

    * Generic cleanup.
        Removed a lot of unused code.
      Contributor(s):
        Blas Rodriguez Somoza <blas at puertareal.com>
        Erik Kunze <erik.kunze at philosys.de>

  **************
  * v1.5 Beta 2
  **************

    * Fixed bug SF #523589.
        View is affecting the result of a query.
      Comment:
        Problem was that RSE's (inside a view) where not flagged as variant.
      Contributor(s):
        Arno Brinkman <firebird at abvisie.nl>

    * Changed behaviour of the forced writes mode.
        Now, if FW=off (disabled), you can control how often dirty pages are flushed on disk.
      Note:
        It allows to use disabled FW mode with more reliablity than before (mostly it affects win32 platforms).
      Contributor(s):
        Blas Rodriguez Somoza <blas at puertareal.com>

    * Renamed ISC4.GDB.
        The security database has been renamed to security.fdb.
      Contributor(s):
        Dmitry Yemanov <yemanov at yandex.ru>

    * New configuration file.
        firebird.conf is finally published.
      Note:
        Directory handling options are not available yet.
      Contributor(s):
        Dmitry Yemanov <yemanov at yandex.ru>

    * New user-defined functions.
        Functions LPAD and RPAD are added to IB_UDF library.
      Contributor(s):
        Juan Guerrero <guerrero747 at yahoo.es>

    * Fixed Beta 1 bug.
        ISQL wasn't able to extract universal triggers.
      Contributor(s):
        Dmitry Yemanov <yemanov at yandex.ru>

    * Fixed unregistered bug.
        Sometimes GFIX didn't allow to specify "-user" and "-password" switches ("incompatible swiches" error).
      Contributor(s):
        Dmitry Yemanov <yemanov at yandex.ru>

    * Security connection cache.
        Connection to the security database is now cached, thus allowing to decrease time of subsequent database attachments.
      Contributor(s):
        Dmitry Yemanov <yemanov at yandex.ru>

    * Some improvements.
        1. Reduce memory usage by the server.
        2. Direct external I/O when the memory is not available for the sorting.
        3. Increased number of streams and predicates supported by the optimizer.
      Contributor(s):
        Dmitry Yemanov <yemanov at yandex.ru>

    * Fixed bug SF #508594.
        LEFT JOIN with VIEWs.
      Comment:
        Simple LEFT JOIN on a VIEW with only an ON clause didn't use an index even if it was possible.
      Contributor(s):
        Arno Brinkman <firebird at abvisie.nl>

    * Fixed Beta 1 bug.
        Server crashes during retrieval of the database statistics.
      Contributor(s):
        Dmitry Yemanov <yemanov at yandex.ru>

    * Fixed Beta 1 bug.
        Wrong context was used with FieldX IN (sub-select) predicate.
      Contributor(s):
        Arno Brinkman <firebird at abvisie.nl>

    * Fixed Beta 1 bug.
        Yet another "deadlock" error during metadata updates.
      Contributor(s):
        Dmitry Yemanov <yemanov at yandex.ru>

    * Fixed Beta 1 bug.
        It wasn't possible to use non-aggregate related-fields from an aggregate query inside a sub-query.
      Contributor(s):
        Arno Brinkman <firebird at abvisie.nl>

    * Fixed Beta 1 bug.
        The client library cannot be loaded in some cases.
      Contributor(s):
        Dmitry Yemanov <yemanov at yandex.ru>

    * Fixed Beta 1 bug.
        The guardian service cannot stop the server.
      Contributor(s):
        Dmitry Yemanov <yemanov at yandex.ru>

    * New character sets.
        DOS737, DOS775, DOS858, DOS862, DOS864, DOS866, DOS869,
        WIN1255, WIN1256, WIN1257,
        ISO8859_3, ISO8859_4, ISO8859_5, ISO8859_6, ISO8859_7, ISO8859_8, ISO8859_9, ISO8859_13
      Note:
        Collations for the above charsets are not available yet.
      Contributor(s):
        Blas Rodriguez Somoza <blas at puertareal.com>

  **************
  * v1.5 Beta 1
  **************

    * CREATE VIEW changes.
        Disallowed PLAN subclause.
      Contributor(s):
        Dmitry Yemanov <yemanov at yandex.ru>

    * Changed aggregate tracking behavior
        Introduce backwards compatibilty within aggregates.  Deepest field inside aggregate determine where an aggregate-context should belong to.
      Contributor(s):
        Arno Brinkman <firebird at abvisie.nl>

    * Improved optimizer.
        Better optimizations of "complex" JOIN queries (LEFT JOIN, views, SPs, etc).
      Contributor(s):
        Arno Brinkman <firebird at abvisie.nl>

    * Fixed Alpha 5 bug.
        Major memory leaks are fixed.
      Contributor(s):
        Dmitry Yemanov <yemanov at yandex.ru>