whatsnew.txt

嵌入式InterBase

      Contributor(s):
        Dmitry Yemanov <yemanov at yandex.ru>

    * Fixed RC3 bug.
        When one merge was done no other merge could be generated by the optimizer.
      Contributor(s):
        Arno Brinkman <firebird at abvisie.nl>

    * Fixed RC3 bug.
        Various tempfile-related issues.
      Contributor(s):
        Dmitry Yemanov <yemanov at yandex.ru>

    * Fixed RC3 bug.
        Wrong console input processing in ISQL.
      Contributor(s):
        Tomas Skoda <tomas.skoda at jdsoftware.sk>.

    * Fixed unregistered bug.
        Non-existent deadlock is raised after execution of pre-(update/delete) triggers.
      Contributor(s):
        Alexander Peshkoff <peshkoff at hotmail.ru>

    * Parser improvement.
        Make INSERTING/UPDATING/DELETING keywords non-reserved.
      Contributor(s):
        Nickolay Samofatov <skidder at bssys.com>

    * Error reporting improvements.
        Added new (more specific) error messages for some of v1.5 changes.
      Contributor(s):
        Dmitry Yemanov <yemanov at yandex.ru>
        Arno Brinkman <firebird at abvisie.nl>
        Alexander Peshkoff <peshkoff at hotmail.ru>

    * Fixed RC3 bug.
        Disabled explicit SELECT locking for non-trivial queries (aggregates, SPs, joins, unions).
      Contributor(s):
        Dmitry Yemanov <yemanov at yandex.ru>
        Nickolay Samofatov <skidder at bssys.com>

    * Installation improvement / security fix.
        Added -login switch to instsvc allowing to install FB service as non-localsystem account.
      Contributor(s):
        Alexander Peshkoff <peshkoff at hotmail.ru>

    * Fixed RC3 bug.
        1) Made savepoints SQL99-compliant.
        2) Fixed bug related to exception handling when savepoints are used.
      Contributor(s):
        Dmitry Yemanov <yemanov at yandex.ru>

    * Fixed RC3 bug.
        'no current record for fetch operation' error for queries where a MERGE was done and/or SP/view/aggregates/unions were used together.
      Contributor(s):
        Arno Brinkman <firebird at abvisie.nl>

    * Re-introduced trimming of VARCHAR fields in the remote protocols.
      Contributor(s):
        Dmitry Yemanov <yemanov at yandex.ru>

    * Fixed unregistered bug.
        Random server crash in the case of big queries being prepared.
      Contributor(s):
        Dmitry Yemanov <yemanov at yandex.ru>

    * Fixed RC3 bug regarding API compatibility.
      Contributor(s):
        Dimitry Sibiryakov <sd at topol.udm.net>

    * Fixed RC3 memory leaks.
      Contributor(s):
        Dmitry Yemanov <yemanov at yandex.ru>

    * Fixed RC3 problem.
         Server crash on restore (caused by GCC 3.2 bug).
      Contributor(s):
        Nickolay Samofatov <skidder at bssys.com>
        Dimitry Sibiryakov <sd at topol.udm.net>

  **************
  * v1.5 RC 3
  **************

    * Fixed RC2 bug.
        Server crash on restore of some databases.
      Contributor(s):
        Nickolay Samofatov <skidder at bssys.com>

    * Configuration improvement.
        Make path management in firebird.conf to follow the OS requirements.
      Contributor(s):
        Alexander Peshkoff <peshkoff at hotmail.ru>

    * Fixed unregistered bug.
        Wrong UDF arguments of types DATE/TIME (dialect 3).
      Contributor(s):
        Oleg LOA <loa at mail.ru>

    * Fixed unregistered bug.
        Possible reference integrity violation.
      Contributor(s):
        Vlad Horsun <horsun at kdb.dp.ua>
        Dmitry Yemanov <yemanov at yandex.ru>

    * Fixed RC2 installation issues on Linux.
        1) Permissions problem for firebird.conf (SF #745090).
        2) Generate aliases.conf on install.
        3) Use rpmbuild to create packages.
      Contributor(s):
        Erik S. LaBianca <labiance at users.sourceforge.net>
        Nickolay Samofatov <skidder at bssys.com>

    * Fixed RC2 bug.
        Incorrect handling of numeric NULLs as EXCEPTION or EXECUTE STATEMENT arguments.
      Contributor(s):
        Dmitry Yemanov <yemanov at yandex.ru>

    * Fixed RC2 bugs.
        1) UDF linkage problems on Linux.
        2) Allow C programs use our shared libraries on POSIX platforms.
        3) Make libfbembed.so compatible with third-party tools such as Kylix.
      Contributor(s):
        Nickolay Samofatov <skidder at bssys.com>
	
    * Fixed unregistered bug.
        Allow easy adjustment of LockSemCount on POSIX platforms. No need to use gds_drop or reboot machine to make new setting take effect
      Contributor(s):
        Nickolay Samofatov <skidder at bssys.com>

    * Parser improvement.
        Make FIRST/SKIP keywords non-reserved.
      Contributor(s):
        Nickolay Samofatov <skidder at bssys.com>

    * Fixed RC2 bug.
        Problems with fbclient.dll on Win9x.
      Contributor(s):
        Alexander Peshkoff <peshkoff at hotmail.ru>

    * Fixed RC2 bug.
        Optimizer crash when all indices of a table had the selectivity of 1.
      Contributor(s):
        Arno Brinkman <firebird at abvisie.nl>

    * Fixed RC2 bug.
        Various issues with the lock manager.
      Contributor(s):
        Nickolay Samofatov <skidder at bssys.com>

    * Fixed unregistered bug.
        Wrong attachment reference after exception in PSQL.
      Contributor(s):
        Alexander Peshkoff <peshkoff at hotmail.ru>

    * Fixed unregistered bug.
        BREAK/LEAVE and EXIT statements are now available for usage in triggers.
      Contributor(s):
        Dmitry Yemanov <yemanov at yandex.ru>

    * Fixed RC2 bug.
        Server crash when NULL is used as EXECUTE STATEMENT argument.
      Contributor(s):
        Alexander Peshkoff <peshkoff at hotmail.ru>

    * Fixed RC2 bug.
        Server crash when explicit pessimistic locks are used from PSQL.
      Contributor(s):
        Nickolay Samofatov <skidder at bssys.com>

  **************
  * v1.5 RC 2
  **************

    * Fixed unregistered bug.
        Possible index corruptions during garbage collection.
      Contributor(s):
        Vlad Horsun <horsun at kdb.dp.ua>
        Dmitry Yemanov <yemanov at yandex.ru>

    * Fixed unregistered bug.
        Solved problems with temporary files management:
        1) Security hole on all POSIX platforms except FREEBSD/OPENBSD related to mktemp usage (possible DoS attacks or privileges elevation)
        2) Only 27 unique filenames generated on win32 (which could cause unpredictable behavior in SS builds)
      Contributor(s):
        Nickolay Samofatov <skidder at bssys.com>

    * Fixed RC1 bug.
        Various server crashes in the remote protocol code.
      Contributor(s):
        Nickolay Samofatov <skidder at bssys.com>

    * Event manager change.
        Disabled usage of definite aux port in CS builds due to known issues.
      Contributor(s):
        Dmitry Yemanov <yemanov at yandex.ru>

    * Fixed unregistered bug.
        Enabled aggregate functions from different parent context to be used inside another aggregate function.
      Example:
        SELECT MAX((SELECT COUNT(*) FROM RDB$RELATIONS)) FROM RDB$RELATIONS
      Contributor(s):
        Arno Brinkman <firebird at abvisie.nl>

    * Fixed RC1 bug.
        Aggregates from a different parent context were not allowed in the HAVING clause.
      Contributor(s):
        Arno Brinkman <firebird at abvisie.nl>

    * Fixed unregistered bug.
        Possible crashes on disconnect when event notification is used.
      Contributor(s):
        Dmitry Yemanov <yemanov at yandex.ru>

    * Service manager changes.
        Features of GSTAT/GSEC are not available via Services API in win32 CS (until v1.6 release).
      Contributor(s):
        Dmitry Yemanov <yemanov at yandex.ru>

    * Fixed unregistered bug.
        Wrong record statistics is reported when operation fails due to some reason.
      Contributor(s):
        Dmitry Yemanov <yemanov at yandex.ru>

    * Fixed RC1 bug.
        Problems with the service manager being attached from different clients simultaneously.
      Contributor(s):
        Dmitry Yemanov <yemanov at yandex.ru>

    * Fixed RC1 bug.
        Various server crashes when any remote protocol is used.
      Note:
        IMPORTANT!!! - Don't forget to update the client library, because this bug existed in both server and client.
      Contributor(s):
        Dmitry Yemanov <yemanov at yandex.ru>

    * Fixed unregistered bug.
        stdin/stdout cannot be used to redirect console I/O in win32 build of GBAK.
      Contributor(s):
        Alexander Peshkoff <peshkoff at hotmail.ru>

    * Fixed RC1 bug.
        Server crash in EXECUTE STATEMENT combined with exception handling block.
      Contributor(s):
        Alexander Peshkoff <peshkoff at hotmail.ru>

    * Fixed unregistered bug.
        Broken lock table resizing in CS. No more "lock manager out of room" (Win32 CS 1.5 RC1) or crashes (possible in all other CS builds of Interbase/Firebird).
      Contributor(s):
        Nickolay Samofatov <skidder at bssys.com>

    * INTL improvement.
        Make UPPER function work for WIN1251 charset without explicit collations.
      Contributor(s):
        Nickolay Samofatov <skidder at bssys.com>
        Dmitry Yemanov <yemanov at yandex.ru>

    * Fixed RC1 bug.
        Cannot connect to the service manager with non-default password.
      Contributor(s):
        Dmitry Yemanov <yemanov at yandex.ru>

    * Fixed RC1 bug.
        Fixed problem with CREATE OR ALTER TRIGGER.
      Contributor(s):
        Dmitry Yemanov <yemanov at yandex.ru>

    * Fixed RC1 bug.
        Server crashes in some cases of error handling.
      Contributor(s):
        Alexander Peshkoff <peshkoff at hotmail.ru>

    * Fixed unregistered bug.
        Possible database corruption when you modify/delete the same record in pre-trigger for which this trigger was called.
        This issue also was known as BUGCHECK(291) before.
      Contributor(s):
        Alexander Peshkoff <peshkoff at hotmail.ru>

    * Fixed RC1 bug.
        Incorrect values returned by ROW_COUNT.
      Contributor(s):
        Dmitry Yemanov <yemanov at yandex.ru>

    * Fixed unregistered bug.
        Buffer overrun in isc_database_info() call.
      Contributor(s):
        Oleg LOA <loa at mail.ru>

    * IMPORTANT!!! - Configuration manager change.
        Now the server exits on missing / wrong firebird.conf with error report in system log.
      Contributor(s):
        Alexander Peshkoff <peshkoff at hotmail.ru>

    * Fixed RC1 bug.
        SP with input parameters and aggregate tracking/validating methods failed.
      Contributor(s):
        Arno Brinkman <firebird at abvisie.nl>

    * Fixed RC1 bug.
        Crash on disconnect in the embedded server.
      Contributor(s):
        Dmitry Yemanov <yemanov at yandex.ru>

    * Fixed RC1 bug.
        Parameters from SPs in a sub-select were not remaped to the proper context in a aggregate query.
      Example:
        SELECT (SELECT SP.X FROM SP_TEST(T1.ID) SP) FROM TABLE1 T1 GROUP BY T1.ID
      Contributor(s):
        Arno Brinkman <firebird at abvisie.nl>

    * Fixed RC1 bug.
        Problem with start/stop commands of instsvc.
      Contributor(s):
        Dmitry Yemanov <yemanov at yandex.ru>

    * Fixed Services API.
        Enabled statistics Services API for POSIX CS builds.
      Contributor(s):
        Nickolay Samofatov <skidder at bssys.com>

  **************
  * v1.5 RC 1
  **************

    * Fixed Beta 4 bug.
        EXECUTE STATEMENT and SQLDA > 32KB.
      Contributor(s):
        Alexander Peshkoff <peshkoff at hotmail.ru>

    * Changed parser.
        1) ROWS_AFFECTED is renamed to ROW_COUNT
        2) CONNECTION_ID/TRANSACTION_ID are renamed to CURRENT_CONNECTION/CURRENT_TRANSACTION
        3) Some of newly introduced tokens are made non-reserved
      Contributor(s):
        Dmitry Yemanov <yemanov at yandex.ru>

    * Fixed Beta 4 bugs.
        1) sub-selects inside COALESCE function
        2) parameter ordering
      Contributor(s):
        Arno Brinkman <firebird at abvisie.nl>

    * Fixed Services API.
        Partially enabled Services API for win32 CS builds.
      Contributor(s):
        Dmitry Yemanov <yemanov at yandex.ru>

    * Fixed unregistered bug.
        Wrong type of event delivery (unnecessary usage of OOB packets).
      Contributor(s):
        Jim Starkey <jas at netfrastructure.com>
        Paul Reeves <preeves at ibphoenix.com>

    * Fixed Beta 4 bug.
        Optimizer couldn't ignore bad indices in some cases.
      Contributor(s):
        Dmitry Yemanov <yemanov at yandex.ru>

    * Improved lock manager
        Deadlocks are now detected and reported as soon all blocking processes received notifications, i.e. instantly in all normal cases
      Contributor(s):
        Nickolay Samofatov <skidder at bssys.com>

    * Fixed Beta 4 bug.