whatsnew.txt

嵌入式InterBase

    * New API functions.
        IB7-compliant functions to return version of the client library.
        isc_get_client_version(), isc_get_client_major_version(), isc_get_client_minor_version()
      Contributor(s):
        Dmitry Yemanov <yemanov at yandex.ru>

    * Sort/merge improvement.
        Merging (SORT MERGE plans) is now done via in-memory sorting module.
      Contributor(s):
        Dmitry Yemanov <yemanov at yandex.ru>

    * Fixed Alpha 5 bug.
        "Invalid transaction handle (expecting explicit transaction start)" error.
      Contributor(s):
        Dmitry Yemanov <yemanov at yandex.ru>

    * New memory manager.
        Internal implementation of the memory manager has been changed to give us better performance.
      Contributor(s):
        Nickolay Samofatov <skidder at bssys.com>

    * Win32 build changes.
        1. Changed names of USER32 objects to allow the server run simultaneously with IB/FB1.
        2. Map name for local (IPC) protocol is changed, so v1.5 client library is no longer compatible with the previous versions via IPC.
        3. All transport protocol names (INET port and service, WNET pipe, IPC map) are now configurable via firebird.conf.
      Contributor(s):
        Dmitry Yemanov <yemanov at yandex.ru>

    * Fixed unregistered bug.
        Trashed RDB$FIELD_LENGTH for views that contain concatenation of long CHAR/VARCHAR fields.
      Contributor(s):
        Dmitry Yemanov <yemanov at yandex.ru>

    * Triggers improvement.
        Added runtime action checks (INSERTING/UPDATING/DELETING predicates).
      Example:
        if (INSERTING) then
          new.OPER_TYPE = 'I';
        else
          new.OPER_TYPE = 'U';
      Contributor(s):
        Dmitry Yemanov <yemanov at yandex.ru>

    * Fixed unregistered bug.
        Cursors (WHERE CURRENT OF clause) cannot be used in triggers.
      Contributor(s):
        Dmitry Yemanov <yemanov at yandex.ru>

    * Fixed Alpha 5 bug.
        SAVEPOINT-related statements were allowed in PSQL via EXECUTE STATEMENT.
      Contributor(s):
        Dmitry Yemanov <yemanov at yandex.ru>

    * Fixed bug SF #221921.
        ORDER BY has no effect.
      Contributor(s):
        Arno Brinkman <firebird at abvisie.nl>

    * Fixed bug SF #213859.
        Subquery connected with 'IN' clause.
      Contributor(s):
        Arno Brinkman <firebird at abvisie.nl>

    * Fixed Alpha 5 bug.
        Wrong plan is used in the case of compound indices.
      Contributor(s):
        Arno Brinkman <firebird at abvisie.nl>,
        Dmitry Yemanov <yemanov at yandex.ru>

    * Fixed Alpha 5 bug.
        Backward compatibility with explicit plans is broken.
      Contributor(s):
        Dmitry Yemanov <yemanov at yandex.ru>

    * ORDER BY improvement.
        Allowed arbitrary expressions in the ORDER BY clause.
      Contributor(s):
        Nickolay Samofatov <skidder at bssys.com>

    * Fixed unregistered bug.
        When UNIONS where used in a VIEW and that VIEW was used in the WHERE clause inside an sub-select then the engine crashed.
      Contributor(s):
        Arno Brinkman <firebird at abvisie.nl>

    * Fixed Alpha 5 bug.
        Fixed FB XDR double representation for Linux server and client.
        This fixes numerous bugs with double precision columns and UDF's when using Linux server and Jaybird or Windows client.
      Contributor(s):
        Nickolay Samofatov <skidder at bssys.com>

    * Fixed Alpha 5 bug.
        PLAN wasn't correctly returned.
      Contributor(s):
        Arno Brinkman <firebird at abvisie.nl>

    * Fixed Alpha 5 bug.
        Server crash or "deadlock" error during execution of ALTER PROCEDURE statement.
      Contributor(s):
        Nickolay Samofatov <skidder at bssys.com>

    * Generic code cleanup.
        Structures within Y-valve.
      Contributor(s):
        Alexander Peshkoff <peshkoff at hotmail.ru>
        Nickolay Samofatov <skidder at bssys.com>

    * Comments improvement.
        Single-line comments (--) are now allowed in any position of the SQL statement.
      Contributor(s):
        Dmitry Yemanov <yemanov at yandex.ru>

    * Fixed unregistered bug.
        "Request sycnhronization error" with BREAK statement.
      Contributor(s):
        Dmitry Yemanov <yemanov at yandex.ru>

    * Fixed bug SF #625899.
        Bugcheck 291.
      Contributor(s):
        Alexander Peshkoff <peshkoff at hotmail.ru>

    * PSQL change.
        EXECUTE VARCHAR is renamed to EXECUTE STATEMENT.
      Contributor(s):
        Alexander Peshkoff <peshkoff at hotmail.ru>

    * Fixed Alpha 5 bug and SF #219525.
        No current record for fetch operation.
      Contributor(s):
        Arno Brinkman <firebird at abvisie.nl>

    * Fixed unregistered bug.
        QLI doesn't understand BIGINT (aka INT64) datatype.
      Contributor(s):
        Dmitry Yemanov <yemanov at yandex.ru>

    * Fixed unregistered bug.
        Length of text variables inside procs/triggers wasn't copied to descriptor structure.
      Contributor(s):
        Arno Brinkman <firebird at abvisie.nl>

  **************
  * v1.5 Alpha 5
  **************

    * FIRST/SKIP and ORDER BY changes.
        1. Implemented ORDER BY clause in subqueries.
        2. Disallowed FIRST/SKIP for views.
        3. Allowed zero as valid argument for FIRST.
      Contributor(s):
        Dmitry Yemanov <yemanov at yandex.ru>
	
    * Fixed unregistered bug.
        Buffer overflow (MAXPATHLEN) and rewritten local function dirname.
      Contributor(s):
        Erik Kunze <erik.kunze at philosys.de>

    * Fixed unregistered bug.
        Make SQLDA parameter mapping consistent with order and number of parameters in source SQL string.
      Notes:
        You can enable older mapping behavior (for backward compatibility) using "OldParameterOrdering" configuration manager parameter.
      Contributor(s):
        Nickolay Samofatov <skidder at bssys.com>

    * Fixed Alpha 4 bug.
        Crash when grouping by invariant subquery.
      Contributor(s):
        Nickolay Samofatov <skidder at bssys.com>

    * Improved optimizer.
        Let sub-selects also use indices when their parent is a stored procedure.
      Contributor(s):
        Arno Brinkman <firebird at abvisie.nl>

    * Fixed unregistered bug.
        Removed request size limitation.
      Contributor(s):
        Dmitry Yemanov <yemanov at yandex.ru>

    * Fixed unregistered bug.
        Nulls first/last and collation handling in "order by" clause of unions.
      Contributor(s):
        Nickolay Samofatov <skidder at bssys.com>

    * Fixed Alpha 4 bug.
        Optimizer, LEFT OUTER JOIN and error "no current record for fetch operation".
      Contributor(s):
        Arno Brinkman <firebird at abvisie.nl>

    * Fixed Alpha 4 bug.
        Wrong privileges checks.
      Contributor(s):
        Dmitry Yemanov <yemanov at yandex.ru>

    * Fixed Alpha 4 bug.
        UDF node didn't contain any character set, was always NONE.
      Contributor(s):
        Arno Brinkman <firebird at abvisie.nl>

    * Generic code cleanup.
        Renamings, new safe macros, support for mingw.
      Contributor(s):
        Erik Kunze <erik.kunze at philosys.de>,
        Ignacio J. Ortega <nacho at siapi.es>,
        Dimitry Sibiryakov <sd at topol.udm.net>

    * Explicit record locking.
        Finalized explicit locking implementation. Should be stable and consistent now.
      Contributor(s):
        Nickolay Samofatov <skidder at bssys.com>

    * Improved optimizer.
        Better handling of AND nodes inside an OR node.
      Contributor(s):
        Arno Brinkman <firebird at abvisie.nl>

    * Fixed Alpha 4 bug.
        Restore problem for databases having views that use procedures AND are used by procedures.
      Contributor(s):
        Nickolay Samofatov <skidder at bssys.com>

    * Fixed Alpha 4 bug.
        Bad performance of the memory manager and some memory leaks.
      Contributor(s):
        Dmitry Yemanov <yemanov at yandex.ru>

    * Fixed Alpha 4 bug.
        Wrong ordinals of GDS32 exports.
      Contributor(s):
        Dmitry Yemanov <yemanov at yandex.ru>

  **************
  * v1.5 Alpha 4
  **************

    * Fixed Alpha 3 bug.
        Database cannot be restored properly in some situations.
      Contributor(s):
        Nickolay Samofatov <skidder at bssys.com>

    * Fixed Alpha 3 bug.
        Dynamic exception messages don't work properly.
      Contributor(s):
        Dmitry Yemanov <yemanov at yandex.ru>

    * Fixed unregistered bug.
        Exceptions inside for/while loop in triggers are not handled correctly.
      Contributor(s):
        Alexander Peshkoff <peshkoff at hotmail.ru>

    * Fixed bug SF #623992.
        Double forward slash in connection string.
      Contributor(s):
        Paul Reeves <preeves at ibphoenix.com>,
        Mark O'Donohue <mark.odonohue at cytopia.com.au>

    * Fixed unregistered bug.
        Deadlock during some database operations.
      Contributor(s):
        Alexander Peshkoff <peshkoff at hotmail.ru>

    * Improved optimizer.
        If a few indices with much different selectivity could be used for index retrieval, only better of them are used while others are ignored.
      Contributor(s):
        Dmitry Yemanov <yemanov at yandex.ru>

    * Fixed Alpha 3 bug.
        Memory corruption that prevented restore of databases with procedures using plan expressions with long index names.
      Contributor(s):
        Nickolay Samofatov <skidder at bssys.com>

    * Fixed unregistered bug.
        Quoted identifiers problem in plan expressions.
      Contributor(s):
        Nickolay Samofatov <skidder at bssys.com>

    * Win32 Classic Server.
        CS architecture is now supported on Win32 as well, but it still cannot be considered stable, so any feedback is welcome.
      Contributor(s):
        Dmitry Yemanov <yemanov at yandex.ru>

    * Fixed Alpha 3 bug.
        API routines are not accessible if gds32.dll is explicitly loaded.
      Contributor(s):
        Dmitry Yemanov <yemanov at yandex.ru>

    * Fixed unregistered bug.
        Stored procedures are no longer recompiled before deletion.
      Contributor(s):
        Nickolay Samofatov <skidder at bssys.com>

    * New collation for WIN1251 charset.
        WIN1251_UA for both Ukrainian and Russian languages.
      Contributor(s):
        Dmitry Yemanov <yemanov at yandex.ru>

    * Client library change.
        API routines are no longer exported by ordinals.
      Contributor(s):
        Dmitry Yemanov <yemanov at yandex.ru>

    * New configuration manager.
        Enable the same plain file based configuration for all supported platforms. Default configuration file will be released in the first beta build.
      Contributor(s):
        Dmitry Yemanov <yemanov at yandex.ru>

    * Improved optimizer.
        Added better support for using indices with "OR". Pick the best available compound index from all "AND" nodes.
      Contributor(s):
        Arno Brinkman <firebird at abvisie.nl>

    * Fixed Alpha 3 bug.
        Database appears corrupted (damaged BLOB pages).
      Contributor(s):
        Dmitry Yemanov <yemanov at yandex.ru>

    * Savepoints.
        Added support for explicit savepoint management.
      Syntax:
        SAVEPOINT savepoint_name; (create savepoint)
        ROLLBACK [WORK] TO [SAVEPOINT] savepoint_name; (rollback to previously created savepoint)
      Notes:
        Not available in PSQL.
      Contributor(s):
        Nickolay Samofatov <skidder at bssys.com>

    * Protocol cleanup.
        IPX/SPX network protocol is no longer supported.
      Contributor(s):
        Sean Leyne <sleyne at atkin.com>

    * Fixed Alpha 3 bug.
        Memory corruption when working with long record verion chains.
      Contributor(s):
        Dmitry Yemanov <yemanov at yandex.ru>

    * Obsolete platforms cleanup.
        Some platform are no longer supported by the current source code.
        DELTA, IMP, DG_X86, M88K, UNIXWARE, Ultrix, NeXT, ALPHA_NT, DGUX, MPE/XL, DecOSF, SGI, HP700, Netware, MSDOS, SUN3_3
      Contributor(s):
        Sean Leyne <sleyne at atkin.com>

    * Improved optimizer.
        Added support for detecting use of index with sub-selects in aggregate select.
      Contributor(s):
        Arno Brinkman <firebird at abvisie.nl>

    * Improved thread scheduler for Win32 SS.
        Now the server should be more responsible under heavy load.
      Contributor(s):
        Alexander Peshkoff <peshkoff at hotmail.ru>

    * Explicit record locking.
        Added support for explicit locking. Wait behavior in isc_tpb_wait transaction modes is not stable yet.
      Syntax:
        SELECT <...> [FOR UPDATE [OF col [, col ...]] [WITH LOCK]]      
      Contributor(s):
        Nickolay Samofatov <skidder at bssys.com>

  **************
  * v1.5 Alpha 3
  **************