Firebird 3.0.4

# The default authentication method on Windows platforms is no longer mixed. It has been changed to native. For more information, see the notes on the configuration parameter Authentication.

# A fix in Firebird 2.5 that alleviates the “hogging” behaviour of the nBackup utility has been backported to this patch release. For more information, see the Improvement in V.2.1.3 note in the nBackup section of the Utilities chapter.

# By popular request, Dmitry Yemanov adds some helpful performance guidelines pertaining to the “internals” of the database monitoring system (a.k.a. “MON$”). The purpose is to assist those using this facility on heavily loaded systems to employ it in ways that provide the information you want while minimising its impact on the end-user experience.

* Bugfix CORE-2372
Server crashes inside CMP_release() while releasing an already freed collation resource
Contributor(s):
Vlad Khorsun

* Bugfix CORE-2368
Access violation after the isc_cancel_events() call if event was not found
Contributor(s):
Vlad Khorsun

* Bugfix CORE-2356
On Windows the listener process of Classic Server can't create necessary resources
after restart if any worker process was present
Contributor(s):
Vlad Khorsun

* Bugfix CORE-2355
Incorrect handling of LOWER/UPPER when result string shrinks in terms of byte length
Contributor(s):
Adriano dos Santos Fernandes

* Bugfix CORE-2354
"fb_lock_print -ia" output is not flushed to a file between iterations
Contributor(s):
Alex Peshkov

* Bugfix CORE-2351
An aliased database cannot be created
Contributor(s):
Alex Peshkov

* Bugfix CORE-2349
False "Invalid SQLDA" error
Contributor(s):
Vlad Khorsun

* Bugfix CORE-2348
More problems with transaction numbers overflowing 32-bit signed integer
and corrupting a database
Contributor(s):
Vlad Khorsun

* Bugfix CORE-2347
"Deadlock. Page type lock conversion denied" error is reported
under a concurrent "connect-work-disconnect" kind of load
Contributor(s):
Dmitry Yemanov

* Bugfix CORE-2341
Hidden variables conflict with output parameters, causing assertions,
unexpected errors or possibly incorrect results
Contributor(s):
Adriano dos Santos Fernandes

* Bugfix CORE-2340
Bugcheck 258 (page slot not empty) could occurs under high concurrent load
Contributor(s):
Vlad Khorsun

* Bugfix CORE-2339
Incorrect result for the derived expression based on aggregate and computation
Contributor(s):
Adriano dos Santos Fernandes

* Bugfix CORE-2320
Complex recursive query may produce not all rows
Contributor(s):
Vlad Khorsun

* Bugfix CORE-2317
select * from (select cast(.... returns null
Contributor(s):
Adriano dos Santos Fernandes

* Bugfix CORE-2313
INF_* functions may invalidate the whole output buffer
with isc_info_truncated at the beginning due to boundary condition
Contributor(s):
Claudio Valderrama

* Bugfix CORE-2311
Possible memory leak in WITH RECURSIVE query
Contributor(s):
Vlad Khorsun

* Bugfix CORE-2308
SIMILAR TO produces random results with [x-y] expressions
Contributor(s):
Adriano dos Santos Fernandes

* Bugfix CORE-2307
Incomplete API information values
Contributor(s):
Dmitry Yemanov

* Bugfix CORE-2300
Unexpected error "arithmetic exception, numeric overflow, or string truncation"
while evaluating SUBSTRING the second time
Contributor(s):
Adriano dos Santos Fernandes

* Bugfix CORE-2293
Wrong dependent object type (RELATION) in RDB$DEPEDENCIES for views
Contributor(s):
Vlad Khorsun

* Bugfix CORE-2291
Bugcheck 284 (cannot restore singleton select data)
Contributor(s):
Vlad Khorsun

* Bugfix CORE-2289
Wrong (primary) constraint name is reported for the foreign key violation during FK creation
Contributor(s):
Vlad Khorsun

* Bugfix CORE-2285
Database with many grants gets corrupted after backup/restore
Contributor(s):
Alex Peshkov

* Bugfix CORE-2282
*truncate UDFs are broken for numbers below -1
Contributor(s):
Claudio Valderrama

* Bugfix CORE-2281
*round UDFs are broken for negative numbers
Contributor(s):
Claudio Valderrama

* Bugfix CORE-2278
Incorrect conversion from/to CP943C in RISC machines
Contributor(s):
Adriano dos Santos Fernandes

* Bugfix CORE-2271
GFIX reports database ownership error way too late
Contributor(s):
Alex Peshkov

* Bugfix CORE-2270
ISQL consumes all memory and crashes when run in zlogin console
Contributor(s):
Jaroslaw Swierczynski
Alex Peshkov

* Bugfix CORE-2266
NBackup database locking not working correctly
Contributor(s):
Vlad Khorsun

* Bugfix CORE-2265
Grouping by function doesn't work properly
Contributor(s):
Adriano dos Santos Fernandes

* Bugfix CORE-2264
ALTER DOMAIN with dependencies may leave a transaction handle
in inconsistent state causing segmentation faults
Contributor(s):
Adriano dos Santos Fernandes
Dmitry Yemanov

* Bugfix CORE-2262
Client connection is abruptly terminated
Contributor(s):
Alex Peshkov

* Bugfix CORE-2258
Internal error when select UPPER() from union
Contributor(s):
Adriano dos Santos Fernandes

* Bugfix CORE-2257
Bugcheck 167 (invalid send request) while altering dependent procedures
Contributor(s):
Dmitry Yemanov

* Bugfix CORE-2255
Error "string right truncation" while altering a view with a join
Contributor(s):
Adriano dos Santos Fernandes

* Bugfix CORE-2248
Server crashes in server.cpp/loopThread() during port validation
Contributor(s):
Vlad Khorsun

* Bugfix CORE-2247
Message and descriptor buffers are not aligned properly in QLI
Contributor(s):
Alex Peshkov

* Bugfix CORE-2245
Error on restoring a database with long exceptions from a backup
Contributor(s):
Claudio Valderrama

* Bugfix CORE-2242
Engine incorrectly (for big-endian machines) fills BPB
Contributor(s):
Alex Peshkov

* Bugfix CORE-2241
Wrong number of records fetched when using index
Contributor(s):
Vlad Khorsun

* Bugfix CORE-2237
Assertion at srcjrdintl.cpp, line 569
Contributor(s):
Adriano dos Santos Fernandes

* Bugfix CORE-2234
Sometimes terminated worker processes in Classic are still considered being alive
Contributor(s):
Vlad Khorsun

* Bugfix CORE-2231
Bugcheck 179 (decompression overran buffer) when attempting to read
from the table RDB$TRIGGER_MESSAGES in a ODS 10.x database
Contributor(s):
Dmitry Yemanov
Vlad Khorsun

* Bugfix CORE-2230
Implement domain check of input parameters of EXECUTE BLOCK
Contributor(s):
Adriano dos Santos Fernandes

* Bugfix CORE-2227
Problem with column names with accents and triggers
Contributor(s):
Adriano dos Santos Fernandes

* Bugfix CORE-2223
Multiple bugs in GBAK when working with ACLs
Contributor(s):
Alex Peshkov

* Bugfix CORE-2222
Server crashes while storing a text blob with a transliteration blob filter applied
Contributor(s):
Vlad Khorsun

* Bugfix CORE-2221
Attach to any DB fails after modification of access rights
of security2.fdb from 0660 to 0666
Contributor(s):
Paul Beach
Alex Peshkov

* Bugfix CORE-2214
Incorrect restore of security classes
Contributor(s):
Adriano dos Santos Fernandes

* Bugfix CORE-2209
Very slow procesing of the monitoring requests under high load
and blocking other activity during that time
Contributor(s):
Dmitry Yemanov

* Bugfix CORE-2202
RDB$VIEW_RELATIONS is not cleaned when altering a view
Contributor(s):
Adriano dos Santos Fernandes

* Bugfix CORE-2186
fbintl.dll never get unloaded in the embedded server
after invoking isc_dsql_execute_immediate for CREATE DATABASE
Contributor(s):
Adriano dos Santos Fernandes

* Bugfix CORE-2183
Error when server shutdown started with an opened "execute statement" request
Contributor(s):
Vlad Khorsun

* Bugfix CORE-2182
It's impossible to drop an existing UDF which name overlaps
with a new built-in function name
Contributor(s):
Dmitry Yemanov

* Bugfix CORE-2179
Deadlock when trying to shutdown the server with an opened "execute statement" request
Contributor(s):
Alex Peshkov

* Bugfix CORE-2176
Unexpected (wrong) results with COALESCE and GROUP BY
Contributor(s):
Adriano dos Santos Fernandes

* Bugfix CORE-2174
DATEADD and DATEDIFF cause an assert in TimeStamp::decode()
Contributor(s):
Adriano dos Santos Fernandes

* Bugfix CORE-2171
Column MON$CALLER_ID of table MON$CALL_STACK reports invalid IDs
Contributor(s):
Dmitry Yemanov

* Bugfix CORE-2158
Client/embedded library crashes while being unloaded
Contributor(s):
Alex Peshkov

* Bugfix CORE-2154
"request synchronization error" when calling isc_dsql_sql_info() with isc_info_sql_records parameter
after last record is fetched with EXECUTE PROCEDURE
Contributor(s):
Vlad Khorsun

* Bugfix CORE-2153
SIMILAR TO predicate hangs with the "|" option
Contributor(s):
Adriano dos Santos Fernandes

* Bugfix CORE-2151
Temporary directory path with spaces in the middle is wrongly truncated from the rightmost space
Contributor(s):
Vlad Khorsun

* Bugfix CORE-2140
Error messages after parameters substitution contains ' ' characters instead of line break
Contributor(s):
Claudio Valderrama

* Bugfix CORE-2138
If a stored procedure with an EXECUTE STATEMENT against an external database fails at runtime,
then the external database remains attached
Contributor(s):
Vlad Khorsun

* Bugfix CORE-2137
Database restore may crash the server when DummyPacketInterval is set
Contributor(s):
Dmitry Yemanov

* Bugfix CORE-2132
Indexed retrieval cannot be chosen if a stored procedure is used
inside the comparison predicate
Contributor(s):
Dmitry Yemanov

* Bugfix CORE-2123
Problem with getting UNICODE_FSS data in the CP943C connection charset
Contributor(s):
Adriano dos Santos Fernandes
Dmitry Kovalenko

* Bugfix CORE-2122
Translation of large text blobs between UNICODE_FSS / UTF8 and other charsets
Contributor(s):
Adriano dos Santos Fernandes
Dmitry Kovalenko

* Bugfix CORE-2121
Client library may crash when working with BLOBs
Contributor(s):
Alex Peshkov

* Bugfix CORE-2117
Incorrect ROW_COUNT value with indexed retrieval and subquery
Contributor(s):
Adriano dos Santos Fernandes

* Bugfix CORE-2115
Query plan is missing for the long query
Contributor(s):
Dmitry Yemanov

* Bugfix CORE-2108
Error "get_free_slot() failed"
Contributor(s):
Vlad Khorsun

* Bugfix CORE-2107
Failed to establish TCPIP connection with Windows Classic Server under high load
Contributor(s):
Vlad Khorsun

* Bugfix CORE-2102
Firebird 2.5 does not build on MacOS (Darwin)
Contributor(s):
Alex Peshkov

* Bugfix CORE-2101
Bugcheck 249 (pointer page vanished) when attempting to fetch outside
the end-of-stream mark for the open PSQL cursor
Contributor(s):
Dmitry Yemanov

* Bugfix CORE-2098
View over global temporary table
Contributor(s):
Vlad Khorsun

* Bugfix CORE-2095
Bug in CVJIS_eucj_to_unicode()
Contributor(s):
Adriano dos Santos Fernandes
Dmitry Kovalenko

* Bugfix CORE-2093
SuperServer startup fails on Solaris 64-bit
Contributor(s):
Alex Peshkov

* Bugfix CORE-2087
RemoteBindAddress = hostname instead of IP address is silently ignored
and server binds to all interfaces (nothing in the firebird.log nor syslog)
Contributor(s):
Alex Peshkov

* Bugfix CORE-2081
RDB$DB_KEY in a subselect expression incorrectly returns NULL
Contributor(s):
Adriano dos Santos Fernandes

* Bugfix CORE-2078
Suboptimal join plan if there are selective non-indexed predicates involved
Contributor(s):
Dmitry Yemanov

* Bugfix CORE-2075
Parts of RDB$DB_KEY of views may be inverted when using outer joins
Contributor(s):
Adriano dos Santos Fernandes

* Bugfix CORE-2073
Expression indices bug: incorrect result for the inverted boolean
Contributor(s):
Dmitry Yemanov

* Bugfix CORE-2071
Client library crashes if isc_dsql_prepare() is called with a NULL statement text
Contributor(s):
Alex Peshkov

* Bugfix CORE-2069
Incorrect view expansion when RDB$DB_KEY is used inside a view body
Contributor(s):
Adriano dos Santos Fernandes

* Bugfix CORE-2068
Comparision with IN and subquery with RDB$DB_KEY returns wrong result
Contributor(s):
Adriano dos Santos Fernandes

* Bugfix CORE-2067
GROUP BY and RDB$DB_KEY problems
Contributor(s):
Adriano dos Santos Fernandes

* Bugfix CORE-2066
Conversion of SQL_TEXT / SQL_VARCHAR to SQL_TIMESTAMP / SQL_TIME / SQL_DATE
Contributor(s):
Adriano dos Santos Fernandes

* Bugfix CORE-2065
Client library not in default dynamic loader search paths
Contributor(s):
Paul Beach

* Bugfix CORE-2064
Server process crashes while exiting under high load
Contributor(s):
Alex Peshkov

* Bugfix CORE-2062
Error while remaping a lock file in Classic Server
Contributor(s):
Alex Peshkov

* Bugfix CORE-2061
ALTER VIEW WITH CHECK OPTION crashes the engine
Contributor(s):
Dmitry Yemanov

* Bugfix CORE-2055
Buffer overflow in fbclient
Contributor(s):
Alex Peshkov

* Bugfix CORE-2053
Computed expressions may be optimized badly if used
inside the RETURNING clause of the INSERT statement
Contributor(s):
Dmitry Yemanov

* Bugfix CORE-2045
References to non-existent system fields with blr_field are not resolved to NULL
Contributor(s):
Adriano dos Santos Fernandes

* Bugfix CORE-2044
Incorrect result for UPDATE OR INSERT ... RETURNING OLD and non-nullable columns
Contributor(s):
Adriano dos Santos Fernandes

* Bugfix CORE-2042
Connection lost to a database when using AUTONOMOUS TRANSACTION
Contributor(s):
Adriano dos Santos Fernandes

* Bugfix CORE-2041
UPDATE OR INSERT with GEN_ID() increments the generator by 3
Contributor(s):
Adriano dos Santos Fernandes

* Bugfix CORE-2039
Domain-level CHECK constraints wrongly process NULL values
Contributor(s):
Dmitry Yemanov

* Bugfix CORE-2038
New EXECUTE STATEMENT implementation asserts or throws an error
if used both before and after commin/rollback retaining
Contributor(s):
Dmitry Yemanov

* Bugfix CORE-2036
Parameters order of EXECUTE BLOCK statement is reversed if called from EXECUTE STATEMENT
Contributor(s):
Vlad Khorsun

* Bugfix CORE-2033
Unresolved symbol _Unwind_GetIP in the client library
Contributor(s):
Alex Peshkov

* Bugfix CORE-2031
NULL in the first record in a condition on RDB$DB_KEY
Contributor(s):
Adriano dos Santos Fernandes

* Bugfix CORE-2027
Incorrect buffer size for ORDER BY expressions with system fields
Contributor(s):
Adriano dos Santos Fernandes

* Bugfix CORE-2026
Problem with a read-only marked database
Contributor(s):
Vlad Khorsun

* Bugfix CORE-2022
EXECUTE BLOCK statement does not support CREATE USER
Contributor(s):
Alex Peshkov

* Bugfix CORE-2019
UTF-8 conversion error (string truncation)
Contributor(s):
Adriano dos Santos Fernandes

* Bugfix CORE-2018
Only one client can access a read-only database
Contributor(s):
Vlad Khorsun

* Bugfix CORE-2017
I/O statistics for stored procedures are not accounted in monitoring tables
Contributor(s):
Dmitry Yemanov

* Bugfix CORE-2016
Client hangs at use of XNET protocol in cases when database or attachment has been shut down
Contributor(s):
Dmitry Yemanov

* Bugfix CORE-2008
NOT NULL flag for procedure parameters in the system schema
Contributor(s):
Adriano dos Santos Fernandes

* Bugfix CORE-2002
Conversion error from UDF result causes memory leak if the result is marked with FREE_IT
Contributor(s):
Claudio Valderrama

* Bugfix CORE-2001
When trying to show "conversion error", "arithmetic exception/string truncation"
may appear instead, misleading the user
Contributor(s):
Claudio Valderrama

* Bugfix CORE-2000
Lock manager may report false deadlocks under high load
Contributor(s):
Vlad Khorsun

* Bugfix CORE-1994
Error "invalid database handle" while executing CREATE USER
Contributor(s):
Dmitry Yemanov

* Bugfix CORE-1989
UTF8 UNICODE_CI collate cannot be used in a foreing key constraint
Contributor(s):
Adriano dos Santos Fernandes

* Bugfix CORE-1986
Altering domain name drops dependencies using the domain
Contributor(s):
Adriano dos Santos Fernandes

* Bugfix CORE-1985
Lock manager code may create 100% CPU load for some time
Contributor(s):
Vlad Khorsun

* Bugfix CORE-1984
Lock manager may report false deadlocks if one of deadlock participants
waits with permitted timeout
Contributor(s):
Vlad Khorsun

* Bugfix CORE-1983
Out of memory condition in OS causes AV
Contributor(s):
Alex Peshkov

* Bugfix CORE-1982
Simultaneous backups or restores could interfere each with other using the Services API
Contributor(s):
Adriano dos Santos Fernandes

* Bugfix CORE-1980
Sweeper consumes 100% CPU forever
Contributor(s):
Vlad Khorsun

* Bugfix CORE-1972
Non-SYSDBA user can change FW mode of a database
Contributor(s):
Alex Peshkov

* Bugfix CORE-1970
Lock conversion denied (215) error may occurs
Contributor(s):
Vlad Khorsun

* Bugfix CORE-1965
Lock manager crashes (invalid lock ID) under concurrent DDL load
Contributor(s):
Dmitry Yemanov

* Bugfix CORE-1963
Possible server crash on commit when granting/revoking privileges
from multiple connections simultaneously
Contributor(s):
Dmitry Yemanov

* Bugfix CORE-1962
Incorrect extraction of MILLISECONDs
Contributor(s):
Adriano dos Santos Fernandes

* Bugfix CORE-1961
Bugcheck 210 (page in use during flush) is thrown during database validation
Contributor(s):
Dmitry Yemanov
Roman Simakov

* Bugfix CORE-1958
Bugcheck 179 (decompression overran buffer) when attempting to update
the same record multiple times
Contributor(s):
Dmitry Yemanov

* Bugfix CORE-1957
Long ACLs truncated
Contributor(s):
Alex Peshkov

* Bugfix CORE-1944
Monitoring tables contain wrong data (big-endian machines)
Contributor(s):
Alex Peshkov

* Bugfix CORE-1943
GROUP BY RAND() returns infinite rows
Contributor(s):
Adriano dos Santos Fernandes

* Bugfix CORE-1938
Bugcheck 243 (missing pointer page) while preparing/executing statements
that reference a table being dropped/recreated by another connection
Contributor(s):
Dmitry Yemanov

* Bugfix CORE-1936
The LOG(base, number) built-in function doesn't check parameters and delivers NAN values instead
Contributor(s):
Adriano dos Santos Fernandes

* Bugfix CORE-1935
SIMILAR TO character classes are incorrectly recognized
Contributor(s):
Adriano dos Santos Fernandes

* Bugfix CORE-1927
Procedure sp_register_character_set can generate the negative RDB$CHARACTER_SET_ID
Contributor(s):
Adriano dos Santos Fernandes

* Bugfix CORE-1923
"instsvc remove" returns 1 when succefully executed
Contributor(s):
Dmitry Yemanov

* Bugfix CORE-1914
Problem creating table leave the database in inconsistent state
Contributor(s):
Alex Peshkov

* Bugfix CORE-1894
Circular dependencies between computed fields crash the engine
Contributor(s):
Adriano dos Santos Fernandes

* Bugfix CORE-1812
Index is not used for some date/time expressions in dialect 1
Contributor(s):
Dmitry Yemanov

* Bugfix CORE-1696
Deadlock in the lock manager when using NBackup utility
Contributor(s):
Roman Simakov

* Bugfix CORE-1690
Error "arithmetic exception, numeric overflow, or string truncation" for UTF8 tables
Contributor(s):
Adriano dos Santos Fernandes

* Bugfix CORE-1650
Infinite row generation in "SELECT GEN_ID(..) FROM DRB$DATABASE" with GROUP BY
Contributor(s):
Adriano dos Santos Fernandes

* Bugfix CORE-1607
Correlated subquery is optimized badly if it depends on the union stream
Contributor(s):
Dmitry Yemanov

* Bugfix CORE-1606
Ability to insert child record if parent record is locked but foreign key target unchanged
Contributor(s):
Alexander Potapchenko
Vlad Khorsun

* Bugfix CORE-1596
Bug in CsConvert::convert
Contributor(s):
Adriano dos Santos Fernandes

* Bugfix CORE-1575
Serious memory bug on multiple update a table in a single transaction
Contributor(s):
Dmitry Yemanov

* Bugfix CORE-1544
RDB$PROCEDURES generator overflow
Contributor(s):
Dmitry Yemanov

* Bugfix CORE-1506
Server crashes with isc_dsql_execute_immediate() and zero length string
Contributor(s):
Alex Peshkov

* Bugfix CORE-1432
Collation is not propagated between record formats
Contributor(s):
Adriano dos Santos Fernandes

* Bugfix CORE-1343
Bug with a simple case and a subquery
Contributor(s):
Adriano dos Santos Fernandes

* Bugfix CORE-1246
Incorrect column values with outer joins and derived tables
Contributor(s):
Adriano dos Santos Fernandes

* Bugfix CORE-1245
Incorrect column values with outer joins and views
Contributor(s):
Adriano dos Santos Fernandes

* Bugfix CORE-903
Non-compliant behaviour of the SET clause of the UPDATE statement
Contributor(s):
Dmitry Yemanov

* Bugfix CORE-501
Optimization problem with COALESCE
Contributor(s):
Adriano dos Santos Fernandes

* Bugfix CORE-316
Cannot open database with MBCS/extended characters in name
See also:
/doc/README.connection_string_charset.txt
Contributor(s):
Adriano dos Santos Fernandes

* Bugfix CORE-216
Too many grants lose privileges
Contributor(s):
Alex Peshkov

* Bugfix CORE-210
Classic Server crashes while altering a stored procedure in two attachments
Contributor(s):
Dmitry Yemanov

* Improvement CORE-2376
Change default value for the authentication method parameter
Contributor(s):
Alex Peshkov

* Improvement CORE-2322
Support SYSDBA-like access of Windows domain administrators to the security database
Contributor(s):
Alex Peshkov

* Improvement CORE-2316
Throttling NBackup on large databases
Contributor(s):
Alex Peshkov

* Improvement CORE-2299
Use the SuperClassic architecture for the embedded server on Windows
Contributor(s):
Dmitry Yemanov

* Improvement CORE-2298
Add support for "SOME_COL = ? OR ? IS NULL" conditions
Contributor(s):
Adriano dos Santos Fernandes

* Improvement CORE-2243
Make Firebird distribution on Windows easier
Contributor(s):
Vlad Khorsun

* Improvement CORE-2233
Allow non-SYSDBA users to monitor not only their current attachment
but other their attachments as well
Contributor(s):
Dmitry Yemanov

* Improvement CORE-2200
Faster execution of a cross join of multiple tables
Contributor(s):
Dmitry Yemanov

* Improvement CORE-2197
Add support for -nodbtriggers switch in GBAK into Services API
Contributor(s):
Alex Peshkov

* Improvement CORE-2195
Review of the Linux CS install access rights
Contributor(s):
Alex Peshkov

* Improvement CORE-2185
Alias WIN_1258 for the charset WIN1258
Contributor(s):
Adriano dos Santos Fernandes

* Improvement CORE-2103
Verify well formed strings when using SJIS and EUCJ character sets
Contributor(s):
Adriano dos Santos Fernandes

* Improvement CORE-2094
Make it possible to use a hostname when specifying the interface to listen on in firebird.conf
Contributor(s):
Alex Peshkov

* Improvement CORE-2052
Allow the Classic Server to see the altered stored procedure
immediately after the modifier transaction commit
Contributor(s):
Dmitry Yemanov

* Improvement CORE-2029
Increase number of contexts avaiable when using derived tables
Contributor(s):
Adriano dos Santos Fernandes

* Improvement CORE-1937
Detect (instead of crash) FREE_IT UDFs that return pointer not allocated by ib_util_malloc()
Contributor(s):
Adriano dos Santos Fernandes

* Improvement CORE-1842
Don't evaluate DEFAULT value expressions until really necessary
Contributor(s):
Adriano dos Santos Fernandes

* Improvement CORE-1799
Improve the almost useless "expression evaluation not supported" message
Contributor(s):
Claudio Valderrama

* Improvement CORE-1758
NBackup support in the Services API
See also:
/doc/README.services_extension
Contributor(s):
Alex Peshkov

* Improvement CORE-1667
Reading password from file/stdin
See also:
/doc/README.read_password_from_file
Contributor(s):
Alex Peshkov

* Improvement CORE-1583
Enhance MON$STATEMENTS / MON$STATE to represent real CPU consumption
Contributor(s):
Dmitry Yemanov

* Improvement CORE-1477
Avoid excessive memory consumption by the undo-log after series of updates
Contributor(s):
Dmitry Yemanov

* Improvement CORE-1137
Better performance (optimized via index) for the NOT IN predicate
Contributor(s):
Adriano dos Santos Fernandes
Vlad Khorsun

* Improvement CORE-1107
Services API extension for new (single, full) shutdown modes
See also:
/doc/README.services_extension
Contributor(s):
Alex Peshkov

* Feature CORE-2323
Ability to trace various events happening inside the database engine
See also:
/doc/README.trace_services
Contributor(s):
Vlad Khorsun
Nickolay Samofatov
Dmitry Starodubov

* Feature CORE-2113
Revoke all privileges of a particular user or role
Syntax:
REVOKE ALL ON ALL FROM { | }
See also:
/doc/README.ddl.txt (section #12)
Contributor(s):
Alex Peshkov

* Feature CORE-2054
Ability to query contents database file pages via ISC API interface
in order to get low-level information for debug and deep analysis purposes
See also:
/doc/sql.extensions/README.isc_info_xxx
Contributor(s):
Vlad Khorsun

* Feature CORE-1945
Custom attribute for collations to sort numbers in numeric order
See also:
/doc/README.intl (NUMERIC-SORT)
Contributor(s):
Adriano dos Santos Fernandes

* Feature CORE-729
Log all SQL statements
See also:
/doc/README.trace_services
Contributor(s):
Vlad Khorsun
Nickolay Samofatov
Dmitry Starodubov

* Fixed unregistered bug
Issue with @prefix@ in aliases.conf on MacOS
* Bugfix CORE-2329
Significant performance degradation in v2.1.2 RC1
* Bugfix CORE-2326
Access violation when committing a new view while trigger on rdb$relations is in place
* Bugfix CORE-2271
GFIX reports the database ownership error way too late
* Bugfix CORE-2266
NBACKUP database locking not working correctly
* Bugfix CORE-2242
The engine incorrectly fills BPB
* Bugfix CORE-2241
Wrong number of records fetched when using index
* Bugfix CORE-2234
Sometimes terminated worker processes in Classic are still considered being alive
* Bugfix CORE-2227
Problem with column names with accents and triggers
* Bugfix CORE-2223
Multiple bugs in GBAK when working with ACLs
* Bugfix CORE-2222
AV in the engine when storing text blob with transliteration blob filter
* Bugfix CORE-2221
Attach to any DB fails after modification of access rights
of security2.fdb from 0660 to 0666
Contributor(s):
* Bugfix CORE-2209
Very slow processing of the monitoring requests under high load
and blocking other activity during that time
* Bugfix CORE-2184
Superserver hangs when multiple clients create tables simultaneously
* Bugfix CORE-2182
It's impossible to drop an existing UDF which name overlaps with a new built-in function name
* Bugfix CORE-2173
Server crashes after abnormal disconnect with open ExecuteStatement
* Bugfix CORE-2171
Column MON$CALLER_ID of table MON$CALL_STACK reports invalid IDs
* Bugfix CORE-2157
fbclient does not have the libpthread dependency
* Bugfix CORE-2151
Temporary directory path with spaces in the middle is wrongly truncated
from the rightmost space
* Bugfix CORE-2137
Database restore may crash the server when DummyPacketInterval is set
* Bugfix CORE-2118
UPDATE OR INSERT with subquery used in the MATCHING part doesn't insert record
* Bugfix CORE-2117
Incorrect ROW_COUNT value with indexed retrieval and subquery
* Bugfix CORE-2108
Error "get_free_slot() failed" reported
* Bugfix CORE-2098
View over global temporary table
* Bugfix CORE-2093
Superserver startup fails on Solaris 64-bit
* Bugfix CORE-2087
RemoteBindAddress = hostname instead of IP address is silently ignored
and server binds to all interfaces (nothing in either firebird.log or syslog)
* Bugfix CORE-2084
Services API security problem
* Bugfix CORE-2078
Suboptimal join plan if there are selective non-indexed predicates involved
* Bugfix CORE-2077
Signal TERM in Classic Server 2.1 for Linux
* Bugfix CORE-2073
Expression indices bug: incorrect result for the inverted boolean
* Bugfix CORE-2065
Client library is not in default dynamic loader search paths
* Bugfix CORE-2055
Buffer overflow in fbclient
* Bugfix CORE-2053
Computed expressions may be optimized badly if used
inside the RETURNING clause of the INSERT statement
* Bugfix CORE-2050
Performance regression: too many semop() system calls
* Bugfix CORE-2049
Performance regression: too many sigprocmask() system calls
* Bugfix CORE-2045
References to non-existent system fields with blr_field are not resolved to NULL
* Bugfix CORE-2039
Domain-level CHECK constraints wrongly process NULL values
* Bugfix CORE-2033
Unresolved symbol _Unwind_GetIP in the client library
* Bugfix CORE-2031
NULL in the first record in a condition on RDB$DB_KEY
* Bugfix CORE-2026
Problem with a read-only marked database and Firebird 2.1
* Bugfix CORE-2017
I/O statistics for stored procedures is not accounted in monitoring tables
* Bugfix CORE-2008
NOT NULL procedure parameters
* Bugfix CORE-2000
Lock manager may report false deadlocks under high load
* Bugfix CORE-1984
Lock manager may report false deadlocks if one of deadlock participants
waits with permitted timeout
* Bugfix CORE-1983
Out of memory condition in OS causes SEGV
* Bugfix CORE-1982
Simultaneous backups or restores could interfere each with other using the Services API
* Bugfix CORE-1972
Non-SYSDBA user can change FW mode of a database
* Bugfix CORE-1970
Lock conversion denied (215) error may occur
* Bugfix CORE-1963
Possible server crash on commit when granting/revoking privileges
from multiple connections simultaneously
* Bugfix CORE-1962
Incorrect extraction of MILLISECONDs
* Bugfix CORE-1958
Bugcheck 179 (decompression overran buffer) when attempting to update
the same record multiple times
* Bugfix CORE-1957
Long ACLs truncated
* Bugfix CORE-1944
Monitoring tables contain wrong data on big-endian machines
* Bugfix CORE-1930
Possible AV in engine if procedure was altered to have no outputs
and dependent procedures was not recompiled
* Bugfix CORE-1926
MON$DATABASE returns outdated transaction counters
* Bugfix CORE-1922
Trusted authentication doesn't work with the Services API
* Bugfix CORE-1919
Memory corruptions in EXECUTE STATEMENT may crash the server
Contributor(s):
* Bugfix CORE-1909
Garbage in firebird.log on linux/amd64
* Bugfix CORE-1843
GBAK with service manager doesn't allow path with space
* Bugfix CORE-1596
Bug in CsConvert::convert
* Bugfix CORE-1506
Server crash with isc_dsql_execute_immediate and zero length string
* Improvement CORE-2243
Make Firebird distribution on Windows easier
* Improvement CORE-2233
Allow non-SYSDBA users to monitor not only their current attachment
but other their attachments as well
* Improvement CORE-2200
Extremely slow executing a cross join of 3 tables in Firebird 2.x

***************************
* v2.1 Release Candidate 2
***************************

* Bugfix CORE-1746
Expression index can be created while doing inserts into table
Contributor(s):
Vlad Horsun <hvlad at users.sourceforge.net>

* Bugfix CORE-1729
Server process terminates when attempting to select the MON$ data
against a heavily loaded system (many concurrent connections)
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>

* Bugfix CORE-1728
Monitoring tables do not work after fresh linux install
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>

* Bugfix CORE-1726
Failure in isc_service_start()
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>

* Bugfix CORE-1724
Common table expressions cannot be used in computed columns and quantified predicates (IN / ANY / ALL)
Contributor(s):
Vlad Horsun <hvlad at users.sourceforge.net>

* Bugfix CORE-1716
Wrong variable initialization in recursive procedures
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at uol.com.br>

* Bugfix CORE-1715
Incorrect "key size exceeds implementation restriction for index" error
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at uol.com.br>

* Bugfix CORE-1713
Distinct with blob fields
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
Note(s):
This change restores the legacy behavior of DISTINCT / UNION / GROUP BY and ORDER BY operations.
Please beware that they may produce incorrect result set, because the ordering / distinct
is performed using blob IDs instead of the blob contents.
It implies that changes CORE-859 and CORE-1530 are rolled back.

* Bugfix CORE-1694
Bug in create/alter database trigger (with Russian comment)
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at uol.com.br>

* Fixed bug CORE-1434
Incorrect result with EXECUTE STATEMENT and VARCHAR columns
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at uol.com.br>

* Fixed bug CORE-1418
Races when starting and quickly shutting down blocking AST thread
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>

* Solaris port
Contributor(s):
Paul Beach <pbeach at ibphoenix.com>
Alex Peshkov <peshkoff at mail.ru>

* Bugfix CORE-1318
Error "Identifier ... is too long using multiple (nested) derived tables
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
Adriano dos Santos Fernandes <adrianosf at uol.com.br>

* Bugfix CORE-1315
Data type unknown
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at uol.com.br>
Vlad Horsun <hvlad at users.sourceforge.net>

* Bugfix CORE-1306
Indices not used for views
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at uol.com.br>

* Bugfix CORE-1303
Infinite loop in SS remote listener
Contributor(s):
Vlad Horsun <hvlad at users.sourceforge.net>

* Bugfix CORE-1300
Lower level index pages is missed from parent page
Contributor(s):
Vlad Horsun <hvlad at users.sourceforge.net>

* Bugfix CORE-1299
Wrong index entries order at non-leaf b-tree pages
Contributor(s):
Vlad Horsun <hvlad at users.sourceforge.net>

* Bugfix CORE-1298
BTRgarbage_collect code can make a deadlock in a page cache
Contributor(s):
Vlad Horsun <hvlad at users.sourceforge.net>

* Bugfix CORE-1292
Can't create table using long username and UTF8 as attachment charset
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at uol.com.br>

* Bugfix CORE-1291
Can't transliterate character set when look at procedure text in database
just created from script (and thus in ODS 11.1)
Contributor(s):
Vlad Horsun <hvlad at users.sourceforge.net>

* Bugfix CORE-1286
Bug with COMPUTED BY fields
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at uol.com.br>

* Bugfix CORE-1276
Sometime INET error reported as 0 in firebird.log instead of real error code
Contributor(s):
Vlad Horsun <hvlad at users.sourceforge.net>

* Bugfix CORE-1271
Creation of invalid procedures/triggers allowed
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at uol.com.br>

* Bugfix CORE-1267
Small bug with default value for domains in PSQL
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at uol.com.br>

* Bugfix CORE-1256
Table columns hide destination variables of RETURNING INTO
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at uol.com.br>

* Bugfix CORE-1253
LIST(DISTINCT) concatenate VARCHAR values as CHAR
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at uol.com.br>

* Bugfix CORE-1249
Full shutdown mode doesn't work on Classic if there are other connections to the database
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>

* Bugfix CORE-1248
Incorrect timestamp arithmetics when one of the operands is negative number
Contributor(s):
Vlad Horsun <hvlad at users.sourceforge.net>

* Bugfix CORE-1244
Server crash on "select * from <recursive CTE>"
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at uol.com.br>
Vlad Horsun <hvlad at users.sourceforge.net>

* Bugfix CORE-1240
Any task, using libfbclient, hangs on exit (Darwin PPC)
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>

* Bugfix CORE-1237
GBAK does not create backup in service_mgr mode if there is no space on disk, no error reported
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>

* Bugfix CORE-1228
Database often became corrupted after an out of disk space condition
Contributor(s):
Vlad Horsun <hvlad at users.sourceforge.net>

* Bugfix CORE-1227
LIST() function seems not work if used twice or more in a query
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at uol.com.br>

* Bugfix CORE-1223
Wrong message in firebird.log on Open SuSe Linux 10.2 : Open file limit increased from 1024 to 0
Contributor(s):
Vlad Horsun <hvlad at users.sourceforge.net>

* Bugfix CORE-1218
isc_dsql_info(isc_info_sql_stmt_type) doesn't set isc_info_end at the end of the passed user's buffer
Contributor(s):
Vlad Horsun <hvlad at users.sourceforge.net>

* Bugfix CORE-1215
Wrong SELECT query results using index to evaluate >= condition
Contributor(s):
Vlad Horsun <hvlad at users.sourceforge.net>

* Bugfix CORE-1207
FB embedded requires extra OS privileges
Contributor(s):
Vlad Horsun <hvlad at users.sourceforge.net>

* Bugfix CORE-1205
v2.1 GBAK crashes the v2.0.x server when attempting to backup a database
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
Claudio Valderrama <cvalde at usa.net>

* Bugfix CORE-1196
Long SQL statements break TCP/IP connection
Contributor(s):
Vlad Horsun <hvlad at users.sourceforge.net>
Alex Peshkov <peshkoff at mail.ru>
Dmitry Yemanov <dimitr at firebirdsql.org>

* Bugfix CORE-1183
View cannot be created if its WHERE clause contains IN <subquery> with a procedure reference
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>

* Bugfix CORE-1175
Error "Data type unknown" when any UDF argument is a built-in function
containing a DSQL parameter reference
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>

* Bugfix CORE-1174
GBAK restores NULL rdb$description in rdb$functions as blob (0, 0)
Contributor(s):
Claudio Valderrama <cvalde at usa.net>

* Bugfix CORE-1167
CHARACTER SET GBK is not installed
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at uol.com.br>

* Bugfix CORE-1165
WHEN <list of exceptions> tracks only the dependency on the first exception in PSQL
Contributor(s):
Claudio Valderrama <cvalde at usa.net>

* Bugfix CORE-1162
Problem altering numeric field type
Contributor(s):
Claudio Valderrama <cvalde at usa.net>

* Bugfix CORE-1153
Activating index change "STARTING" working as "LIKE" in join condition
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at uol.com.br>

* Bugfix CORE-1151
Error "database file not available" when running NBackup
Contributor(s):
Nickolay Samofatov <skidder at users.sourceforge.net>

* Bugfix CORE-981
x86_64 RPM package missing "provides"
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>

* Bugfix CORE-949
Restore with UDF in 'COMPUTED BY' fields fails
Contributor(s):
Dimitry Sibiryakov <sd at ibphoenix.com>

* Bugfix CORE-885
It is impossible to take away rights on update of a column
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>

* Bugfix CORE-856
Unable to set FName, MName, LName fields in the security database to blank
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>

* Bugfix CORE-703
Using DEL-Key in isql under Linux gives "~"
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>

* Bugfix CORE-132
Restore fails on external table
Contributor(s):
Vlad Horsun <hvlad at users.sourceforge.net>

* Bugfix CORE-107
Instance of fb_lock_mgr runs after build
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>

* Improvement CORE-1280
Verify well-formedness of text blobs
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at uol.com.br>

* Improvement CORE-1277
Automatic transliteration of text blobs
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at uol.com.br>

* Improvement CORE-1232
Wrong behaviour of services manager during backup/restore operations
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>

* Improvement CORE-1229
Allocate disk space by more than one page at a time
Contributor(s):
Vlad Horsun <hvlad at users.sourceforge.net>

* Improvement CORE-1226
Allow RETURNING in INSERT...SELECT, UPDATE and DELETE
See also:
/doc/README.returning
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at uol.com.br>

* Improvement CORE-1213
CURRENT OF is now allowed for views
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>

* Improvement CORE-1179
"CH" and "LL" are not separate spanish alphabet letters since 1994
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at uol.com.br>

* Improvement CORE-1178
Standarize ES_ES_CI_AI collation
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at uol.com.br>

* Improvement CORE-1170
Conversion of DDL source from client charset to metadata charset
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at uol.com.br>

* Improvement CORE-1169
Conversion of temporary blobs to the destination blob type when materializing
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at uol.com.br>

* Improvement CORE-961
Free external tables as soon as they're no longer in use by user requests
Contributor(s):
Vlad Horsun <hvlad at users.sourceforge.net>

* Improvement CORE-867
GBAK should change param0 to not show username/password in ps axf
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>

* Improvement CORE-787
Optionally disable non-SYSDBA use of Services API
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>

* Feature CORE-1235
NATURAL JOIN and JOIN...USING
See also:
/doc/README.joins.txt
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at uol.com.br>

* Added a wide set of new built-in functions
ABS, ACOS, ASCII_CHAR, ASCII_VAL, ASIN, ATAN, ATAN2,
BIN_AND, BIN_OR, BIN_SHL, BIN_SHR, BIN_XOR,
CEIL, COS, COSH, COT, DATEADD, DATEDIFF, DECODE,
EXP, FLOOR, GEN_UUID, HASH, LEFT, LN, LOG, LOG10, LPAD,
MAXVALUE, MINVALUE, MOD, OVERLAY, PI, POSITION, POWER,
RAND, REPLACE, REVERSE, RIGHT, ROUND, RPAD,
SIGN, SIN, SINH, SQRT, TAN, TANH, TRUNC
See also:
/doc/README.builtin_functions.txt
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at uol.com.br>
Oleg Loa <loa at mail.ru>
Alexey Karyakin <aleksey.karyakin at mail.ru>

- Improvement CORE-1071
Background garbage collector doesn't need to read backversions
of the active record
Contributor(s):
Vlad Horsun <horsun at kdb.dp.ua>

- Improvement CORE-1047
Add support for Gentoo/FreeBSD detection
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>

- Improvement CORE-1012
IBO problems with FB >= 1.5.3 "Error with joins
and auto-generated search query"
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at uol.com.br>

- Fixed bug CORE-1140
Server crashes when performing GC during index creation
(related to existence of expression indices on the same table)
Contributor(s):
Dmitry Yemanov <yemanov at yandex.ru>

- Fixed bug CORE-1139
NBackup doesn't delete the delta file after successful backup
on Win32 CS
Contributor(s):
Dmitry Yemanov <yemanov at yandex.ru>

- Fixed bug CORE-1136
NBackup cannot backup a recently created database
Contributor(s):
Dmitry Yemanov <yemanov at yandex.ru>

- Fixed bug CORE-1133
XNET (IPC) communication protocol does not work across sessions
Contributor(s):
Vlad Horsun <horsun at kdb.dp.ua>

- Fixed bug CORE-1130
Bad optimization: <procedure> left join <subquery> (or <view>)
Contributor(s):
Dmitry Yemanov <yemanov at yandex.ru>

- Fixed bug CORE-1127
Circular index references in corrupt database causes fbserver
to loop infinitely
Contributor(s):
Diane Downie <diane.downie at citrix.com>
Vlad Horsun <horsun at kdb.dp.ua>

- Fixed bug CORE-1126
UNION vs UTF8 literals: arithmetic exception is thrown
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at uol.com.br>

- Fixed bug CORE-1124
NBackup doesn't work in the interactive mode on Windows
Contributor(s):
Dmitry Yemanov <yemanov at yandex.ru>

- Fixed bug CORE-1121
NBackup: Page-level deadlock (bugcheck 215) when attempting
to lock/backup a database under load
Contributor(s):
Dmitry Yemanov <yemanov at yandex.ru>
George Sergeev <georgy.sergeev at inbox.ru>

- Fixed bug CORE-1110
isc_get_client_xxx_version not fully compatible with IB's gds32.dll
Contributor(s):
Vlad Horsun <horsun at kdb.dp.ua>

- Fixed bug CORE-1104
Linux install fails when x0rfbserver program is running
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>

- Fixed bug CORE-1094
isc_dsql_sql_info() returns unordered SQLVAR descriptors
Contributor(s):
Dmitry Yemanov <yemanov at yandex.ru>

- Fixed bug CORE-1080
Bugcheck 167 (invalid SEND request) in SS when many parallel attachments
begin to execute trigger not loaded into metadata cache
Contributor(s):
Vlad Horsun <horsun at kdb.dp.ua>

- Fixed bug CORE-1068
ISQL doesn't print not-nullable blobs
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at uol.com.br>

- Fixed bug CORE-1064
Wrong backup order for character sets and collations
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at uol.com.br>

- Fixed bug CORE-1063
Server hangs eating CPU and performs huge I/O
copying different codepage fields
Contributor(s):
Vlad Horsun <horsun at kdb.dp.ua>

- Fixed bug CORE-1059
Remote Linux Classic crash
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>

- Fixed bug CORE-1057
GSEC hiding error - CryptAcquireContext
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
Adriano dos Santos Fernandes <adrianosf at uol.com.br>

- Fixed bug CORE-1055
Wrong parameter matching for self-referenced procedures
Contributor(s):
Dmitry Yemanov <yemanov at yandex.ru>

- Fixed bug CORE-1053
Invalid results in SELECT, when index is used to evaluate
"greater" operator in WHERE clause
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
Arno Brinkman <firebird at abvisie.nl>
Vlad Horsun <horsun at kdb.dp.ua>

- Fixed bug CORE-1051
Possible stack corruption in DFWcheck_dependencies
Contributor(s):
Vlad Horsun <horsun at kdb.dp.ua>

- Fixed bug CORE-1046
Core dump in CVT_move
Contributor(s):
Dmitry Yemanov <yemanov at yandex.ru>

- Fixed bug CORE-1040
Wrong single-segment ascending index on character field with NULL
and empty string values
Contributor(s):
Vlad Horsun <horsun at kdb.dp.ua>
Arno Brinkman <firebird at abvisie.nl>

- Fixed bug CORE-1037
Command-line for Installation of SuperServer Component is not working
Contributor(s):
Paul Reeves <preeves at ibphoenix.com>

- Fixed bug CORE-1033
LIKE clause doesn't work for computed values (at least in a view)
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at uol.com.br>

- Fixed bug CORE-1029
Bad plan in outer joins with IS NULL clauses
(dependent on order of predicates)
Contributor(s):
Dmitry Yemanov <yemanov at yandex.ru>

- Fixed bug CORE-1025
Server crashes at runtime when an explicit MERGE plan
is specified over a few JOIN ones
Contributor(s):
Dmitry Yemanov <yemanov at yandex.ru>

- Fixed bug CORE-1020
Command-line switch /silent or /verysilent does not install the guardian
Contributor(s):
Paul Reeves <preeves at ibphoenix.com>

- Fixed bug CORE-1017
Service attachments (over presumably Xnet) fail
when Classic started with -x -i parameters
Contributor(s):
Dmitry Yemanov <yemanov at yandex.ru>

- Fixed bug CORE-1016
UdfAccess check is performed after loading the library
and executing its startup code
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>

- Fixed bug CORE-1011
Server crashes when being connected to via InterBase gds32.dll
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
Dmitry Yemanov <yemanov at yandex.ru>

- Fixed bug CORE-1010
Server crashes if DDL statement execution raises an error
Contributor(s):
Dmitry Yemanov <yemanov at yandex.ru>

- Fixed bug CORE-1006
AV at rollback and/or garbage collection if updated table has expression
index with SELECT in it
Contributor(s):
Vlad Horsun <horsun at kdb.dp.ua>

- Fixed bug CORE-1005
DISTINCT vs NULLS LAST clause: wrong order of NULLs
Contributor(s):
Dmitry Yemanov <yemanov at yandex.ru>

- Fixed bug CORE-1004
Context already in use (BLR error)
Contributor(s):
Dmitry Yemanov <yemanov at yandex.ru>

- Fixed bug CORE-997
Database Update 1.5 to 2.0 fails
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at uol.com.br>

- Fixed bug CORE-988
FB SuperServer 32bit old threading, regularly restarts
"fbserver terminated abnormally (-1)"
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>

- Fixed bug CORE-984
fbclient.dll changes the security descriptor of the calling process
Contributor(s):
Dmitry Yemanov <yemanov at yandex.ru>

- Fixed bug CORE-982
Error reading data from the connection
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>

- Fixed bug CORE-966
Bug in socket binding for database events
Contributor(s):
Paul Beach <pbeach at ibphoenix.com>

- Fixed bug CORE-959
GSTAT does not work using the localhost connection string
Contributor(s):
Dmitry Yemanov <yemanov at yandex.ru>

- Fixed bug CORE-952
AV when blob is used in expression index
Contributor(s):
Vlad Horsun <horsun at kdb.dp.ua>

- Fixed bug CORE-944
FB2 RC4 Linux Classic server crashes
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>

- Fixed bug CORE-943
Incorrect shutdown, when database is in the phisical backup mode
Contributor(s):
Dmitry Yemanov <yemanov at yandex.ru>

- Fixed bug CORE-888
DDL - object in use
Contributor(s):
Dmitry Yemanov <yemanov at yandex.ru>