# Fixed
* Core Engine/API
- (CORE-3115)The internal record compression routines exhibited some bugs.
- (CORE-3103)A SELECT statement incurred more non-indexed reads in the third v.2.5 release candidate than the same statement in v.2.1.3.
- (CORE-3101)ALTER DOMAIN was not possible in a database that had been migrated from an earlier version.
- (CORE-3100)The WAIT mode and lock timeout parameters for the external transaction of EXECUTE STATEMENT were not matched to the corresponding parameters of the local transaction.
- (CORE-3096)A regression introduced with the fix for CORE-2893 caused double processing of nodes when preparing a statement, prompting an abort to occur in the debug build.
- (CORE-3094)Parameters would not work with NOT IN from a selectable stored procedure.
- (CORE-3090)Incorrect LEFT JOIN result using table and derived constant subquery.
- (CORE-3089)Attempt to run EXECUTE STATEMENT on an external data source failed when the data source was an InterBase 4.1 (ODS 8) database.
- (CORE-3079)Batch inserts were noticeably slowed down if they were all executed in a single transaction and involved triggers that posted events.

* Server Crashes
- (CORE-3109)The server would crash when isc_dql_exec_immed3_m() was called for CREATE DATABASE ... in a NULL transaction.

* Command-line Utilities
- gsec
- (CORE-3116)The gsec utility was sending its output list of users to stderr instead of stdout.

* v2.1.4
***************************

* Bugfix CORE-3285
100% CPU usage (endless loop) inside the lock manager
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>

* Bugfix CORE-3262
LIST() function may overwrite last part of output with zero characters
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at uol.com.br>

* Bugfix CORE-3244
Function POSITION: wrong result with '' if third argument present
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at uol.com.br>

* Bugfix CORE-3228
Function RIGHT() fails with multibyte text blobs > 1024 chars
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at uol.com.br>

* Bugfix CORE-3227
Function ASCII_VAL() fails if argument contains multi-byte character anywhere
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at uol.com.br>

* Bugfix CORE-3220
isc_info_svc_get_users returns error message in the result cluster
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>

* Bugfix CORE-3218
Statement cancellation request might be silently ignored by the currently running SQL code
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>

* Bugfix CORE-3208
Significant memory leaks with recursive queries
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
Vlad Khorsun <hvlad at users.sourceforge.net>

* Bugfix CORE-3205
isc_dsql_exec_immed2() doesn't return error codes isc_stream_eof and isc_sing_select_err
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>

* Bugfix CORE-3202
execute_immediate API call family may crash the remote server
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>

* Bugfix CORE-3188
Page 0 is of wrong type (expected 6, found 1)
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>

* Bugfix CORE-3148
Dangerous code in SQZ_apply_differences
Contributor(s):
Dmitry Kovalenko <dmitry.lipetsk at gmail.com>
Alex Peshkov <peshkoff at mail.ru>

* Bugfix CORE-3137
Partial rollback is possible for a selectable procedure modifying data
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>

* Bugfix CORE-3131
WIN1257_LV (Latvian) collation is wrong for 4 letters: A E I U.
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>

* Bugfix CORE-3119
100% CPU USAGE (endless loop) in the remote protocol code related to events processing
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>

* Bugfix CORE-3115
Bugs in the internal record compression routines
Contributor(s):
Dmitry Kovalenko <dmitry.lipetsk at gmail.com>
Alex Peshkov <peshkoff at mail.ru>

* Bugfix CORE-3091
Built-in function POWER(X, Y) does not work when the X argument is negative
and the Y value is scaled numeric but integral
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at uol.com.br>

* Bugfix CORE-3079
Strong slowing down inserts with EVENT-s in a single transaction.
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>

* Bugfix CORE-3067
Objects are not unmapped when shared memory is closed
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>

* Bugfix CORE-3064
Using both the procedure name and alias inside an explicit plan crashes the server
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>

* Bugfix CORE-3050
Race condition in LocksCache::get() could lead to AV in the engine
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>

* Bugfix CORE-3041
Engine could hang when working with read-only database
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>

* Bugfix CORE-3034
Bugcheñk 300 (can't find shared latch)
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>

* Bugfix CORE-3022
gpre C++ compiler warnings with GCC 4.4.1
Contributor(s):
Daniel Dodson <zabbit at yahoo.com>

* Bugfix CORE-3019
Startup failure of SS and SC on linux gentoo
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>

* Bugfix CORE-3016
On disconnect it is possible to see "Fatal lock manager error:
invalid lock id (0), errno: 0" in firebird.log
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>

* Bugfix CORE-3015
Various "Cannot initialize the shared memory region" errors
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>

* Bugfix CORE-3011
Server hangs or crashes while monitoring connections repeatedly attaching and detaching
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>

* Bugfix CORE-3003
Procedure suspend check may cause restore to fail
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>

* Bugfix CORE-3001
Install fails to create user & group "firebird"
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>

* Bugfix CORE-2999
Message "SCH_validate -- not entered" is logged in firebird.log
when the Classic Server connection where events were used is finished
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>

* Bugfix CORE-2995
Same error in the status vector is reported twice
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>

* Bugfix CORE-2993
Fatal lock manager error "Invalid lock id (NNN)" while working with monitoring tables
on a highly loaded system
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>
Dmitry Yemanov <dimitr at firebirdsql.org>

* Bugfix CORE-2977
Server works with indexed fields of type DATE incorrectly in pre-ODS10 databases
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>

* Bugfix CORE-2969
RDB$SET_CONTEXT does not allow to overwrite any vars after encountering limit of them
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>

* Bugfix CORE-2956
Problems with requests of procedure parameters
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>

* Bugfix CORE-2943
Error while parsing a recursive query with two recursive parts
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>

* Bugfix CORE-2936
Wrong page type (expected 7 found N) error
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>

* Bugfix CORE-2928
Buffer overflow in GSEC
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>

* Bugfix CORE-2919
Installation script ignores non-standard ports
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>

* Bugfix CORE-2916
Broken error handling in the case of a conversion error happened during index creation
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>

* Bugfix CORE-2914
Server crashes while restoring a database having an expression index referencing a non-existent UDF
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>

* Bugfix CORE-2908
Engine could crash or raise not expected errors working with ODS 8.x database
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>

* Bugfix CORE-2900
Server crashes evaluating aggregate distinct
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at uol.com.br>

* Bugfix CORE-2888
A memory corruption cause incorrect query evaluation and may crash the server
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at uol.com.br>

* Bugfix CORE-2879
Sweep could raise error: page 0 is of wrong type (expected 6, found 1)
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>

* Bugfix CORE-2871
Outer ORDER BY clause has no effect
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>

* Bugfix CORE-2865
Segmentation fault when SuperServer binary is restarted
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>

* Bugfix CORE-2858
Possible memory trashing when raising some exceptions to signal failed security checks
Contributor(s):
Claudio Valderrama <cvalde at usa.net>

* Bugfix CORE-2856
Non-NULL key in unique index could be not found when key is removed
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>

* Bugfix CORE-2846
Cannot connect to the database if GFIX -shut <mode> -attach <timeout>
fails after the specified timeout (because of connections being still active)
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>

* Bugfix CORE-2845
Solaris 10 no longer requires SFIO
Contributor(s):
Paul Beach <pbeach at ibphoenix.com>

* Bugfix CORE-2833
Changing data that affects an expression index that contains references to null date fields fails
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>

* Bugfix CORE-2831
ISQL shouldn't display database and user names when extracting a script
Contributor(s):
Claudio Valderrama <cvalde at usa.net>

* Bugfix CORE-2827
Very slow prepare for complex interrelated metadata with many triggers indirectly involved
in the operation being prepared
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>

* Bugfix CORE-2826
Join condition fails for UTF-8 databases
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at uol.com.br>

* Bugfix CORE-2822
Error "no current row for fetch operation" when subquery includes a non-trivial derived table
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>

* Bugfix CORE-2820
Small memory leak in query with PLAN ORDER
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>

* Bugfix CORE-2815
PIP page could be marked after it was really changed
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>

* Bugfix CORE-2814
Bus error while sorting/merging on SPARC
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>

* Bugfix CORE-2793
Binary representation of the backup file is inconsistent among subsequent backup/restore cycles
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>

* Bugfix CORE-2785
BLOB transliteration problem in a specific case
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at uol.com.br>

* Bugfix CORE-2783
Access violation using recursive query as subquery in select list and ordering by it
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>

* Bugfix CORE-2741
Naive metadata extraction code in isql is defeated by "check" keyword typed in mixed case
Contributor(s):
Claudio Valderrama <cvalde at usa.net>

* Bugfix CORE-2720
Wrong evaluation result with divide and unary plus\minus operations
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>

* Bugfix CORE-2698
Infinite wait in LocksCache::get
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>

* Bugfix CORE-2684
Error page NNN is of wrong type (expected 7, found N)
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>

* Bugfix CORE-2679
Applications using the embedded server may hang while exiting
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>

* Bugfix CORE-2675
Small memory leak per every blob transliteration
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>

* Bugfix CORE-2648
NBackup's delta file ignores the "Forced Writes" database setting
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>

* Bugfix CORE-2640
A regular deadlock may not be detected by the lock manager under some conditions,
thus resulting in a hang
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>
Dmitry Yemanov <dimitr at firebirdsql.org>

* Bugfix CORE-2635
Unique index with a lot of NULL keys can be corrupted at level 1
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>

* Bugfix CORE-2634
Performance regression when restoring database with big metadata
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>

* Bugfix CORE-2632
"Invalid BLOB ID" error when working with the monitoring tables
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>

* Bugfix CORE-2616
Error "page <N> is of wrong type (expected 7, found 5)"
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>

* Bugfix CORE-2591
High mutex wait ratio and degraded performance after some time of performing normally
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>

* Bugfix CORE-2578
select rdb$db_key from a view with more than one table joined results in a conversion error
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>

* Bugfix CORE-2572
Locks of type LCK_page_space are processed incorrectly (big-endian machines)
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>

* Bugfix CORE-2539
Delta file is not deleted after backup is completed
Contributor(s):
Roman Simakov <roman.simakov at red-soft.biz>

* Bugfix CORE-2532
Incorrect size of volumes in multi volume database
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>

* Bugfix CORE-2519
GSTAT output is incorrect for tables with more than 2 billion records
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>

* Bugfix CORE-2507
Intermittent CreateFile failure
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>

* Bugfix CORE-2356
On Windows listener process of Classic Server can't create necessary resources after restart
if any worker process was present
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>

* Bugfix CORE-2301
select list(xxx, ';') from table into :xxx cause a memory leak
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at uol.com.br>

* Bugfix CORE-2289
Wrong (primary) constraint name is reported for the foreign key violation during FK creation
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>

* Bugfix CORE-2215
GROUP BY concatenation with empty string
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at uol.com.br>

* Bugfix CORE-2122
Translation of large text BLOB between UNICODE_FSS (UTF8) and other charsets
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at uol.com.br>

* Bugfix CORE-2107
Failed to establish TCP/IP connection with Windows Classic Server under high load
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>

* Bugfix CORE-2084
Services API security problem
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>

* Bugfix CORE-1752
Results of a join with different collations depend on the execution plan
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>

* Bugfix CORE-1346
LPAD and RPAD with two columns not working
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at uol.com.br>

* Bugfix CORE-1274
Wrong results when PLAN MERGE is chosen and datatypes
of the equality predicate arguments are different
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>

* Bugfix CORE-1089
Wrong ordering with views, distinct, left join and order by
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>

* Bugfix CORE-195
Bugcheck 291 (cannot find record back version)
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>

* Improvement CORE-3295
Estimate the actual record compression ratio in the optimizer
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>

* Improvement CORE-2769
Make XNET_CONNECT_TIMEOUT in xnet.h user configurable
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>

* Improvement CORE-1658
Avoid memory consumption of <page size> bytes per every temporary blob
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at uol.com.br>

* Improvement CORE-1234
More information about table that belongs to column when checking privileges
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>

* New feature CORE-2655
Add support for Linux/sh4 (Renesas SH) platform
Contributor(s):
Nobuhiro Iwamatsu <iwamatsu at nigauri.org>
Alex Peshkov <peshkoff at mail.ru>

· The SQLSTATE code has been made available as a PSQL context variable, for use in WHEN .. exception blocks, in the same manner as GDSCODE and SQLCODE
· Now it is possible to write to global temporary tables in a read-only database
· Diagnostics for internal trace errors were improved
· The fbtracemgr utility will now do a periodic flush to output
· Performance of gbak restore at the data insertion stages has improved
· Conversions between BLOBs and other data types can now be effected in the API functions
· The Services API now supports the “metadata-only” restore
· A “silent install” switch has been implemented for make install on POSIX
· The unused bytes of VARCHAR values in the message buffer are now set to zero
· The actual record compression ratio is now estimated in the optimizer
· The MON$STATEMENT_ID value now stays constant among monitoring snapshots
· The SO_KEEPALIVE option on the client TCP socket will now be set, as a measure to guard against aggressive timing out of sockets by newer Windows systems
· Lock Manager can now cancel waits that become interminable
· A platform port of v.2.5.1 for HPPA has been done for both Linux and Alpha