firebird/firebird-mirror
firebird/firebird-mirror
8
0
Fork 1
mirror of https://github.com/FirebirdSQL/firebird.git synced 2025-01-22 20:03:02 +01:00
Code Issues
B3_0_Release
firebird-mirror/doc/WhatsNew
Dmitry Yemanov d31799d047 Document v3.0.12 changes
2024-07-31 21:15:54 +03:00

6286 lines
216 KiB
Plaintext
Raw Permalink Blame History

**************************
* v3.0.12
**************************
* Improvement #8181
Ensure the standalone CS listener on Linux uses the SO_REUSEADDR socket option
Contributor(s): Dmitry Yemanov
* Improvement #8030
Better cardinality estimation when empty data pages exist
Contributor(s): Vlad Khorsun
* Improvement #7978
Update Windows distributions with zlib version 1.3.1
Contributor(s): Vlad Khorsun
* Bugfix #8178
Fix boolean conversion to string inside DataTypeUtil::makeFromList()
Contributor(s): Dmitry Yemanov
* Bugfix #8156
Can not specify concrete IPv6 address in ES/EDS connection string
Contributor(s): Vlad Khorsun
* Bugfix #8151
Deadlock happens when run 'List Trace Sessions' service and there are many active trace sessions
Contributor(s): Vlad Khorsun
* Bugfix #8149
The hung or crash could happen when connection fires TRACE_EVENT_DETACH event and new trace session created concurrently
Contributor(s): Vlad Khorsun
* Bugfix #8110
Firebird 5 crash On Android API level 34
Contributor(s): Vlad Khorsun
* Bugfix #8101
Firebird crashes if a plugin factory returns nullptr and no error in status
Contributor(s): Vlad Khorsun, Dimitry Sibiryakov
* Bugfix #8089
AV when attaching database while low of free memory
Contributor(s): Vlad Khorsun
* Bugfix #8079
Engine could crash when executing some trigger(s) while another attachment modifies them
Contributor(s): Vlad Khorsun
* Bugfix #8027
Broken gbak statistics
Contributor(s): Alexander Peshkov
* Bugfix #7993
Unexpected results when using CASE WHEN with RIGHT JOIN
Contributor(s): Dmitry Yemanov
* Bugfix #7985
Hang in case of error when sweep thread is attaching to database (Classic Server)
Contributor(s): Alexander Peshkov
* Bugfix #7979
Hang when database with disconnect trigger using MON$ tables is shutting down
Contributor(s): Alexander Peshkov
* Bugfix #7950
Unable to restore database when .fbk was created on host with other ICU
Contributor(s): Alexander Peshkov
* Bugfix #7917
Hang in case of error when sweep thread is attaching to database
Contributor(s): Alexander Peshkov
* Bugfix #7860
Crash potentially caused by BETWEEN operator
Contributor(s): Vlad Khorsun
* Bugfix #7844
Removing first column with SET WIDTH crashes ISQL
Contributor(s): Adriano dos Santos Fernandes
* Bugfix #7839
Potential bug in BETWEEN operator
Contributor(s): Vlad Khorsun
* Bugfix #7817
Memory leak is possible for UDF array arguments
Contributor(s): Dmitry Yemanov
* Bugfix #7812
Service backup does not work in multiple engines configuration
Contributor(s): Alexander Peshkov
* Bugfix #7779
Firebird is constantly crashing with the same symptoms (fbclient.dll)
Contributor(s): Vlad Khorsun
* Bugfix #7762
Crash on "Operating system call pthread_mutex_destroy failed. Error code 16" in log
Contributor(s): Alexander Peshkov
* Bugfix #7747
Fix an issue where the garbage collection in indexes and blobs is not performed in VIO_backout()
Contributor(s): Ilya Eremin
* Bugfix #7738
Crash on multiple connections/disconnections
Contributor(s): Alexander Peshkov
* Bugfix #7737
Fix cases where the precedence relationship between a record page and a blob page is not set
Contributor(s): Ilya Eremin
* Bugfix #7713
FOR SELECT statement can not see any changes made in DO block
Contributor(s): Vlad Khorsun
* Bugfix #7522
Shared memory area is probably already created by another engine instance in another Windows session, failed to create database
Contributor(s): Vlad Khorsun
* Bugfix #7480
Firebird server stops accepting new connections after some time
Contributor(s): Alexander Peshkov
**************************
* v3.0.11
**************************
* Improvement #7539
RDB$GET/SET_CONTEXT(): enclosing in apostrophes or double quotes of a missed namespace/variable will made output more readable
Contributor(s): Vlad Khorsun
* Improvement #7494
Firebird performance issue - non necessary index reads
Contributor(s): Vlad Khorsun
* Improvement #7468
Add switch to control in guardian timeout before killing firebird server process
Contributor(s): Alexander Peshkov
* Improvement #7437
zlib version 1.2.13 released 2022-10-13
Contributor(s): Vlad Khorsun
* Improvement #7418
Reliability of plugin manager
Contributor(s): Alexander Peshkov
* Improvement #7259
Remove TcpLoopbackFastPath and use of SIO_LOOPBACK_FAST_PATH
Contributor(s): Vlad Khorsun
* Bugfix #7665
Wrong result ordering in LEFT JOIN query
Contributor(s): Dmitry Yemanov
* Bugfix #7664
DROP TABLE executed for a table with big records may lead to "wrong page type" or "end of file" error
Contributor(s): Vlad Khorsun, Ilya Eremin
* Bugfix #7662
Peformance issues in prepare_update()
Contributor(s): Ilya Eremin
* Bugfix #7661
FB3 CS rejects new connections
Contributor(s): Vlad Khorsun
* Bugfix #7626
Segfault when new attachment is done to shutting down database
Contributor(s): Alexander Peshkov
* Bugfix #7556
FB Classic can hang when attempts to attach DB while it is starting to encrypt/decrypt
Contributor(s): Alexander Peshkov
* Bugfix #7555
Invalid configuration for random fresh created database may be used after drop of another one with alias in databases.conf
Contributor(s): Alexander Peshkov
* Bugfix #7537
Wrong name in error message when unknown namespace is passed into RDB$SET_CONTEXT()
Contributor(s): Vlad Khorsun
* Bugfix #7517
Successful compiling of procedure with wrong PLAN(s) used by some of its statement(s)
Contributor(s): Dmitry Yemanov
* Bugfix #7514
Segfault when detaching after deleting shadow on Classic
Contributor(s): Alexander Peshkov
* Bugfix #7510
Firebird regularly crashes soon after unload of udr_engine plugin
Contributor(s): Alexander Peshkov
* Bugfix #7501
Precision of standalone unit may differ from packaged one in SQL dialect 1
Contributor(s): Vlad Khorsun
* Bugfix #7499
Problem with restore
Contributor(s): Vlad Khorsun
* Bugfix #7473
Client application crash when processing callback requests from server during attachDatabase
Contributor(s): Alexander Peshkov
* Bugfix #7467
Simple sql crashes firebird: select cast(rdb$db_key as integer) from rdb$database
Contributor(s): Alexander Peshkov
* Bugfix #7465
Restore success illegally reported when gbak was unable to activate all indices
Contributor(s): Alexander Peshkov
* Bugfix #7446
Attempt to use data in destroyed transaction pool
Contributor(s): Alexander Peshkov
* Bugfix #7444
isql crashes when executing test from QA suite
Contributor(s): Alexander Peshkov
* Bugfix #7434
Crash or error in SUBSTRING()'s regexp parser with UTF-8 encoding
Contributor(s): Alexey Mochalov
* Bugfix #7428
Problem with editing procedures being in use
Contributor(s): Vlad Khorsun
* Bugfix #7415
DbCrypt/KeyHolder plugins key changing issues on running server
Contributor(s): Alexey Mochalov
* Bugfix #7413
Regression: bad plan in FB 3.0.9+ (correct in FB 3.0.8)
Contributor(s): Dmitry Yemanov
* Bugfix #7406
Regression - trusted role does not work with version 3.0.10
Contributor(s): Alexander Peshkov
* Bugfix #7402
Server crashes on startup error
Contributor(s): Alexander Peshkov
* Bugfix #7393
Access violation after double fault in attachDatabase()
Contributor(s): Alexander Peshkov
* Bugfix #7370
Segfault under OOM conditions
Contributor(s): Alexander Peshkov
* Bugfix #7365
Client side aliases do not work in databases.conf
Contributor(s): Alexander Peshkov
* Bugfix #7349
Contradictory licensing/distribution statements in several charset-support files
Contributor(s): Mark Rotteveel
* Bugfix #7314
Multitreaded activating indices restarts server process
Contributor(s): Vlad Khorsun
* Bugfix #7299
gfix hangs on disconnect when transactions trace active
Contributor(s): Alexander Peshkov
* Bugfix #7298
Unreliable info result parsing
Contributor(s): Alexander Peshkov
* Bugfix #7296
During shutdown op_disconnect may be sent to invalid handle
Contributor(s): Alexander Peshkov
* Bugfix #7295
Unexpected message 'Error reading data from the connection' when fbtracemgr is closed using ctrl-C
Contributor(s): Alexander Peshkov
* Bugfix #7314
Sporadic crash on 3.0.10.33106
Contributor(s): Vlad Khorsun
* Bugfix #7237
Starting operator become unstable on indexed varchar fields
Contributor(s): Adriano dos Santos Fernandes
* Bugfix #7233
Slow database restore when Classic server mode is used
Contributor(s): Ilya Eremin
* Bugfix #6947
Query to mon$ tables does not return data when the encryption/decryption thread is running
Contributor(s): Alexander Peshkov
* Bugfix #6941
Dummy (always true) conditions may change the join order
Contributor(s): Dmitry Yemanov
* Bugfix #5853
Wrong formatting of "Elapsed time" in isql
Contributor(s): Jiri Cincura
* Bugfix #4729
Grant and Revoke update (field)
Contributor(s): Alexander Peshkov
* Bugfix #3810
Wrong or missing IS NULL optimization (regression)
Contributor(s): Vlad Khorsun
**************************
* v3.0.10
**************************
* Improvement #7194
Make it possible to avoid fbclient dependency in Pascal programs using firebird.pas
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Improvement #7161
Update zlib to 1.2.12
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>
* Improvement #7093
Improve indexed lookup speed of strings when the last keys characters are part of collated contractions
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Improvement #6872
Faster execution of indexed STARTING WITH with UNICODE collation
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix #7197
Segfault in Linux CS after successful detach from a database
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix #7191
gstat fails, but return 0 error code with incorrect databases.conf
Contributor(s):
Alexey Mochalov <aleksey.mochalov at red-soft.ru>
* Bugfix #7184
gbak output is not being flushed to disk
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix #7176
Incorrect error "Invalid token. Malformed string." with union + blob + non-UTF8 varchar
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix #7160
Missing checkout in trace manager when performing user mapping may cause server hang
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix #7158
Serious issue with SYSDBA user after a Windows install with EnableLegacyClientAuth
Contributor(s):
Paul Reeves <preeves at ibphoenix.com>
* Bugfix #7147
Problems with use of big timeout (or no timeout at all) in trace service
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix #7141
Services manager breaks long lines into 1023 bytes portions when using isc_info_svc_line in Service::query()
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix #7140
Wrong select result in case of special sort character
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix #7138
Problems accessing FB4 database, copied from another host
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix #7137
Optimizer regression: bad plan (HASH instead of JOIN) is chosen for some inner joins
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix #7135
Firebird engine randomly fails when delivering mapping clear to other processes
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix #7128
Incorrect error message with isc_sql_interprete()
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>
* Bugfix #7122
Invalid state of mapping cache after replacement of database
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix #7121
Mapping error when server tries to use mapping rules from database in full shutdown state
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix #7106
Wrong detection of must-be-delimited user names
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix #7094
Incorrect indexed lookup of strings when the last keys characters are part of collated contractions and there is multi-segment insensitive descending index
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
**************************
* v3.0.9
**************************
* Bugfix #7119
Database statistics service could not find existing table(s)
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>
* Bugfix #7118
Chained JOIN .. USING across the same column names may be optimized badly
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix #7115
Server hangs in trace code when it tries to update mapping cache
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix #7112
Avoid unload of plugins in MacOS due to problematic reload of them
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix #7109
Content of DB file can be overwritten with zero characters in some (rare) cases
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>
* Bugfix #7103
FB service hangs and cannot be stopped after several 'DELETE FROM MON$STATEMENTS' being issued in order to stop ES/EDS which waits record for updating
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>
* Bugfix #7084
Creating unique constraints on MacOS fails on larger tables
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix #7067
Deadlock when using not initialized security database
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix #7060
Deadlock when execute test for CORE-4337
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix #7057
Client-side positioned updates work wrongly with scrollable cursors
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix #7056
Fetching from a scrollable cursor may overwrite user-specified buffer and corrupt memory
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix #7043
Wrong message when user has no access to /tmp/firebird
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix #6966
Status vector for ES(<EMPTY_STRING>) is unstable if another execute block with correct statement was executed before
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix #3357
Bad execution plan if some stream depends on multiple streams via a function
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
**************************
* v3.0.8
**************************
* Improvement #6957
Add database creation time to the output of ISQL's command SHOW DATABASE
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>
* Improvement #6769 (CORE-6542)
More efficient implementation of SUBSTRING for UTF8 character set
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Improvement #6748 (CORE-6519)
Freeing a statement using DSQL_drop or DSQL_unprepare should send free packet immediately
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>
* Improvement #5913 (CORE-5647)
Increase number of formats/versions of views from 255 to 32K
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Improvement #5137 (CORE-4841)
Make message about missing password being always displayed as reply on attempt to issue CREATE new login without PASSWORD clause
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix #7044
Validation error: Data page N {sequence M} marked as secondary but contains primary record versions in table T
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>
* Bugfix #7036
Unexpected messages '"Missing security context ...' in firebird.log
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix #7034
Scroll cursor server crash
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix #7031
gbak -b fails with "invalid transaction handle (expecting explicit transaction start)"
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>
* Bugfix #6999
GBAK removes database and backup files if finished unsuccessfully
Contributor(s):
Ilya Eremin <ilya071294 at gmail.com>
Alex Peshkov <peshkoff at mail.ru>
* Bugfix #6987
DATEDIFF does not support fractional value for MILLISECOND
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix #6984
Committed transaction could be marked as dead in some very special and rare case
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix #6967
PIO_read / PIO_write may falsely return success in a case when block was read/written incompletely
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix #6949
On Windows, engine may hang on initialization when another instance with different lock directory is running
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>
* Bugfix #6932
GTT's pages are not released while dropping it
Contributor(s):
Ilya Eremin <ilya071294 at gmail.com>
Vlad Khorsun <hvlad at users.sourceforge.net>
* Bugfix #6918
Service detach is always traced
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>
* Bugfix #6896
Client forcing server to encryption
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix #6866
Orphan records are left in RDB$SECURITY_CLASSES and RDB$USER_PRIVILEGES after DROP PROCEDURE/FUNCTION
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>
* Bugfix #6854
Crash occurs when SIMILAR TO is used
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix #6836
fb_shutdown() does not wait for self completion in other thread
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix #6817
-fetch_password passwordfile does not work with GFIX
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix #6796
Buffer overflow when padding line with national characters causes ISQL to crash
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix #6782
Cannot get "records fetched" counter for procedures/functions in trace
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>
* Bugfix #6781
Crashing (due to UDF exception) server process hangs
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>
* Bugfix #6780
firebird.msg is missing in Firebird Android builds
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix #6777
AV when engine shut down and cancels attachment that is waiting in lock manager
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>
* Bugfix #6768 (CORE-6542)
Backup cannot be restored on a raw device (error during "open O_CREAT" operation for file "/dev/sda1")
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix #6759 (CORE-6532)
Results of concatenation with blob has no info about collation of source columns (which are declared with such info)
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>
* Bugfix #6758 (CORE-6531)
COMPUTED BY column looses charset and collate of source field <F> when <F> is either of type BLOB or VARCHAR casted to BLOB
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>
* Bugfix #6755 (CORE-6528)
Connect to a database that contains broken pages can lead to server crash
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix #6752 (CORE-6525)
Segfaults in fbclient when receiving invalid / unexpected data from server
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix #6751 (CORE-6524)
Various segfaults in fbclient
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix #6750 (CORE-6521)
CAST of infinity values to FLOAT doesn't work
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix #6747 (CORE-6518)
Wrong message when connecting to tiny trash database file
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix #6746 (CORE-6517)
CREATE DATABASE fails with 'Token unknown' error when DB name is enclosed in double quotes and 'DEFAULT CHARACTER SET' is specified after DB name
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix #6731 (CORE-6501)
Segfault when shutting down database which got encrypted by another process
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix #6729 (CORE-6499)
GSTAT with switch -t executed via services fails with "found unknown switch" error
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix #6724 (CORE-6494)
Inconsistent translation "string->timestamp->string->timestamp" in the Dialect 1
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix #6719 (CORE-6489)
User without ALTER ANY ROLE privilege can use COMMENT ON ROLE
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix #6718 (CORE-6488)
Event delivery could be missed when local (XNET) protocol is used
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>
* Bugfix #6717 (CORE-6487)
FETCH ABSOLUTE and RELATIVE beyond bounds of cursor should always position immediately before-first or after-last
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix #6716 (CORE-6486)
FETCH RELATIVE has an off by one error for the first row
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix #6710 (CORE-6479)
COMMENT ON USER can only apply comment on user defined by the default UserManager plugin
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix #6708 (CORE-6477)
Rare race condition in Plugin Manager could lead to the server crash
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>
* Bugfix #6700 (CORE-6468)
Wire compression causes sporadic "Error reading data from the connection" errors
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix #6698 (CORE-6466)
Comments before the first line of code are removed
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix #6683 (CORE-6450)
Races in cache of opened security databases
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix #6680 (CORE-6447)
Unexpectedly different text of message for parameterized expression starting from second run
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>
* Bugfix #6679 (CORE-6446)
CLOOP envelopes are wrong regarding IStatus
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix #2367 (CORE-6441)
Srp plugin keeps connection after database has been removed for ~10 seconds (SS and SC)
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix #6674 (CORE-6440)
Expression indexes containing COALESCE inside cannot be matched by the optimizer after migration from v2.5 to v3.0
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix #6672 (CORE-6437)
GFIX cannot set big value for buffers
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>
* Bugfix #6670 (CORE-6433)
Firebird server crashes during a daily maintenance / set statistics index
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix #6669 (CORE-6432)
Possible buffer overflow in client library in Attachment::getInfo() call
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix #6650 (CORE-6412)
Firebird freezes when trying to manage users via triggers
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix #6646 (CORE-6408)
RETURNING clause in MERGE cannot reference column in aliased target table using qualified reference (alias.column) if DELETE action present
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix #6624 (CORE-6385)
Wrong line and column information after IF statement
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix #6265 (CORE-6015)
Segfault when using expression index with complex expression
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>
* Bugfix #6220 (CORE-5966)
Slow performance when executing SQL scripts as non-SYSDBA user
Contributor(s):
Roman Simakov <roman.simakov at red-soft.biz>
* Bugfix #5877 (CORE-5611)
Higher memory consumption for prepared statements
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix #5534 (CORE-5255)
String truncation exception on UPPER/LOWER functions, UTF8 database and some multibyte characters
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix #5173 (CORE-4878)
Compound ALTER TABLE statement with ADD and DROP the same constraint failed if this constraint involves index creation (PK/UNQ/FK)
Contributor(s):
Ilya Eremin <ilya071294 at gmail.com>
* Bugfix #5082 (CORE-4783)
Exception "too few key columns found for index" raises when attempt to create table with PK and immediatelly drop this PK within the same transaction
Contributor(s):
Ilya Eremin <ilya071294 at gmail.com>
* Bugfix #3886 (CORE-3529)
RECREATE TABLE T with PK or UK is impossible after duplicate typing w/o commit when ISQL is launched in AUTODDL=OFF mode
Contributor(s):
Ilya Eremin <ilya071294 at gmail.com>
* Bugfix #1210 (CORE-2917)
Server hangs on I/O error during "open" operation for file "/tmp/firebird/fb_trace_ksVDoc"
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix #2469 (CORE-2032)
Stored procedure recursively called by calculated field fails after reconnect
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>
**************************
* v3.0.7
**************************
* Improvement CORE-6413
Remove PIDFile/-pidfile option from Super(Server/Classic) systemd unit
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Improvement CORE-6362
Better diagnostic for the 'Missing security context' error
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Improvement CORE-6339
Detach server from the security database when missing plugin data structures are causing an error
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-6411
FB crashes attempting to create a table with >5460 fields
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-6396
Unknown tag (0) in isc_svc_query() results
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-6392
Space in database path prevent working gbak -se ... -b "pat to/database" backup
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-6388
Client asserts when closing the event thread in the debug build
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-6370
Server leaks memory when a computed field containing COALESCE/CAST is selected
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-6367
Segfault when receiving a malformed packet from the network
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-6364
Wrong reference counting in the UDR trigger sample
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>
* Bugfix CORE-6360
Engine may hang due to races when starting the crypt thread and simultaneous shutdown
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-6358
Adding NOT NULL column with DEFAULT value may cause default values to be volatile or have the wrong charset
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-6351
Inter-dependent computed fields could be wrongly evaluated as NULL in some cases
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>
* Bugfix CORE-6348
Wire compression causes server freezes
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-6347
New connections to the server sometimes stall, when there is an existing connection to the database
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>
* Bugfix CORE-6346
New connection to the server hangs
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>
* Bugfix CORE-6340
Alternate quoting does not work on some particular cases
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-6253
Server may crash sue to the locked fb_lock file
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>
* Bugfix CORE-6147
Script with extracted (using isql -x) metadata may fail creating the global mapping
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
**************************
* v3.0.6
**************************
* New feature CORE-4933
Better transaction control in ISQL
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>
* Improvement CORE-6334
Missing relocation support on MacOS
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Improvement CORE-6274
Increase parsing speed of long queries
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Improvement CORE-6237
Performance problem when using SRP plugin
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-6345
Server crashes on overflow of division result
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-6343
Rolled back transaction produces unexpected results leading to duplicate values in PRIMARY KEY
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-6331
Memory leak with some statements and expressions
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-6329
GBAK with service_mgr and WinSSPI authentication raises error in clumplet API
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-6323
File-system ID may be duplicated among databases located on different volumes
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-6319
NBACKUP locks database file after error
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>
* Bugfix CORE-6317
Server is crashing on long GRANT statement
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-6314
Assigning RDB$DB_KEY to MBCS CHAR/VARCHAR does not enforce the target limit
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-6310
VARCHAR length limit is not enforced when assigning string with trailing spaces in MBCS
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-6309
FBSVCMGR can not decode information buffer returned by gfix list limbo service
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-6296
Many connections results in poor performance
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>
* Bugfix CORE-6295
Incomplete header files in distributed packages
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>
Paul Reeves <preeves at ibphoenix.com>
* Bugfix CORE-6290
Hex number used at end of statement (for example with CREATE DOMAIN ... DEFAULT) may read invalid memory and produce wrong values or exceptions
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-6283
isNullable() in message metadata, returned by metadata builder, does not match with datatype set by setType() in metadata builder
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-6280
MERGE statement loses parameters in WHEN (NOT) MATCHED clause that will never be matched, crashes server in some situations
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-6269
Server (on Linux) ignores KeepAlive settings, when client connection is lost the corresponding server connection/process is not killed
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-6266
Deleting records from MON$ATTACHMENTS using ORDER BY clause doesn't close the corresponding attachments
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-6265
Mapping rules destroyed by backup / restore
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-6264
GBAK with PIPE to stdout: invalid content if user '-se <host>:service_mgr' command switch
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-6260
Warnings are not always displayed in ISQL
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-6254
AV in engine when using SET TRANSACTION and ON TRANSACTION START trigger uses EXECUTE STATEMENT against current transaction
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>
* Bugfix CORE-6253
Crash caused by the locked fb_lock file
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>
* Bugfix CORE-6252
UNIQUE CONSTRAINT violation
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>
* Bugfix CORE-6251
Regression: crash when built-in function LEFT() or RIGHT() missed 2nd argument (number of characters to be taken)
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-6250
Signature mismatch when creating package body on identical packaged procedure header
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-6246
[fbclient] Problem with too many number of columns in resultset
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-6233
Wrong dependencies of stored function on view after backup and restore
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-6231
Access violation on shutdown of XNET connection to local database when events have been registered
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>
* Bugfix CORE-6230
Unable to connect with database if security.db reference is removed from databases.conf file
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-6227
isc_info_svc_user_dbpath always returns alias of main security database
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-6224
Server may crash due double destruction of the rem_port object
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>
* Bugfix CORE-6221
Incorrect (throw-based) allocFunc for zlib1 (possible memory leak)
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-6217
[inet.cpp] Wrong work with pointer: delete ptr; ptr=new ;
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-6212
Authentication plugin on server may get garbage data from client instead of empty packet
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-6208
CREATE DATABASE grant is lost in security.db after backup/restore cycle
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-6189
Building bundled libtommath fails
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-6130
Creating backup to stdout using service manager is broken
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-6116
Metadata script extracted using ISQL -X of a database restored from a FB 2.5 backup is invalid when a table has COMPUTED BY field
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-6110
64-bit transaction IDs are not stored properly in the status vector
Contributor(s):
Ilya Eremin <ilya071294 at gmail.com>
* Bugfix CORE-5972
External engine trigger crashing server if a table has computed field
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-5862
VARCHAR computed column without explicit type does not populate RDB$CHARACTER_LENGTH
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-5364
gfix -online normal <db> does not produce error when there is a parallel SYSDBA attachment
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-2251
GBAK doesn't return error code
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
**************************
* v3.0.5
**************************
* Bugfix CORE-6204
Server crashes because TraceSvcJrd::checkPrivileges can pass NULL in 'alias'
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>
* Bugfix CORE-6203
"Error reading data from the connection" is raised sometimes when using non-default authentication plugin
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-6197
Memory leak in INET_connect()
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-6185
Some (wrong ?) parameters of ENCRYPT() leads FB to crash
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-6182
Firebird's internal timer incorrectly resets existing timer entries
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>
* Bugfix CORE-6171
Error "no current record for fetch operation" with queries with aggregated subselect
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-6163
Generator pages are not encrypted
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-6150
Bugcheck when PK\UK\FK constraint check read record already marked as damaged
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>
* Bugfix CORE-6144
Inconsistent behaviour of the NEW context variable in AFTER UPDATE OR DELETE triggers
Contributor(s):
Ilya Eremin <ilya071294 at gmail.com>
* Bugfix CORE-6143
Error 'Multiple maps found for ...' is raised in not appropriate case
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-6142
Error "connection lost to database" could happen when application creates few local attachments (using XNET) simultaneously
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>
* Bugfix CORE-6141
fbsvcmgr action_repair rpr_list_limbo_trans does not show list of transactions in LIMBO state
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-6138
Inconsistent behavior regarding visibility of master record on detail inserts
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>
* Bugfix CORE-6137
Server crashes when it run SQL
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>
* Bugfix CORE-6134
Win_Sspi in the list of auth plugins leads message about failed login to be changed (from 'Your user name and password are not defined...' to 'Missing security context ...')
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-6122
UDFs in Firebird 3.0.4 on macOS Mojave - when trying to call UDF from fbudf.dylib in isql, a message "Statement failed, SQLSTATE = 39000 invalid request BLR at offset 35" is displayed
Contributor(s):
Paul Beach <pbeach at ibphoenix.com>
* Bugfix CORE-6108
Regression: FB3 throws "Datatypes are not comparable in expression" in procedure parameters
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-6104
Incorrect error "invalid request handle" is thrown when an embedded user doesn't have SELECT permissions
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-6097
Connection does not see itself in the MON$ATTACHMENTS when Domain/Username (using SSPI) is exactly 31 bytes long
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-6090
BLOB fields may be suddenly set to NULLs during UPDATE after a table format change
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-6089
BLOBs are unnecessarily copied during UPDATE after a table format change
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-6087
Problem with casting within UNION
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-6086
Creating of the large procedure crashes the server
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>
* Bugfix CORE-6078
Permissions for CREATE OR ALTER statements are not checked
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-6068
Server hangs when compiling big package with error
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-6067
Memory leak in fbclient
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>
* Bugfix CORE-6063
FB3 (protocol 13) returns op_accept instead op_accept_data
Contributor(s):
Dmitry Kovalenko <dmitry.lipetsk at gmail.com>
* Bugfix CORE-6050
When FB 3 fbclient.dll connects to a remote FB 2.5 server, it tries to open local (client-side) directories and files
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-6045
Segmentation fault in fbtracemgr when closing it using ctrl-C
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-6043
GTTs do not release used space
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>
* Bugfix CORE-6040
Metadata script extracted using ISQL is invalid/incorrect when table has COMPUTED BY field
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-6038
SRP user manager sporadically creates users which can not attach
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-6031
Little valgrind memory leak in isc_attach_database
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-6028
Trigger on system table is restored in FB3 database and can't be deleted
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-6027
Server hangs on new attachment right after trace session stop
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-6026
Alignment issue with FB_MESSAGE C++ macro (as well UDR macros) and BIGINT/DECFLOAT types in Linux 32-bits
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-6015
Segfault when using expression index with complex expression
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-6009
I/O error during "open" operation for file "/tmp/firebird/fb_trace_*" in firebird.log
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-6007
Firebird does not build on Mac with fresh toolchain
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-6000
GBAK reports "Your user name and password are not defined" when command switch "-fe(tch_password) ..." is specified when run as service
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-5995
Creator user name is empty in user trace sessions
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>
* Bugfix CORE-5993
When creation of audit log file fails, there is no error message in firebird.log
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>
* Bugfix CORE-5991
Trace could not work correctly with quoted file names in trace configurations
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>
* Bugfix CORE-5989
iconv / libiconv 1.15 vs libc / libiconv_open | common/isc_file.cpp
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-5986
Incorrect evaluation of NULL IS [NOT] {FALSE | TRUE}
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-5985
Regression: ROLE does not passed in ES/EDS (specifying it in the statement is ignored)
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-5982
Read permission error for a BLOB field, when it's input/output procedure's parameter
Contributor(s):
Dmitriy Starodubov <dmitry.starodubov at red-soft.biz>
* Bugfix CORE-5980
Firebird crashes due to concurrent operations with expression indices
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>
* Bugfix CORE-5972
External engine trigger crashing server if table have computed field
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-5966
Slow performance when executing SQL scripts as non-SYSDBA user
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-5965
FB 3.0 optimizer chooses less efficient plan than FB 2.5 optimizer
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-5959
Firebird returns wrong time after changes of time zone
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>
* Bugfix CORE-5955
Unable to init binreloc with ld >= 2.31
Contributor(s):
Roman Simakov <roman.simakov at red-soft.biz>
* Bugfix CORE-5950
Deadlock when attaching to bugchecked database
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-5949
Bugcheck could happen when read-only database with non-zero linger is set to read-write mode
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>
* Bugfix CORE-5943
Server crashes preparing a query with both DISTINCT/ORDER BY and non-field expression in the select list
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-5936
Firebird server segfaults in the end of database backup
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>
* Bugfix CORE-5935
Bugcheck 165 (cannot find tip page)
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>
* Bugfix CORE-5934
gpre_boot fails to link using cmake, undefined reference 'dladdr' and 'dlerror'
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-5927
With some non-standard authentication plugins providing correct crypt key wire anyway remains not encrypted
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-5926
Attempt to create mapping with non-ASCII user name which is encoded in single-byte codepage (win1251) leads to the 'malformed string' error
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-5918
Memory pool statistics is not accurate
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-5907
Regression: can not launch trace if its 'database' section contains regexp pattern with curvy brackets to enclose quantifier
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-5902
Add Firebird Event fails with error "While isc_que_events - Failed to establish a secondary connection for event processing."
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
Vlad Khorsun <hvlad at users.sourceforge.net>
* Bugfix CORE-5888
Firebird server on Android has problem with numerics
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-5845
ORDER BY on index can cause suboptimal index choices
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-5823
No permission for SELECT access to blob field in stored procedure
Contributor(s):
Dmitriy Starodubov <dmitry.starodubov at red-soft.biz>
* Bugfix CORE-5800
Indices by expression on computed field are not working properly after backup/restore
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-5795
ORDER BY clause on compound index may disable usage of other indices
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-5784
Lock folder inizialization is not multi-process safe
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-5639
Mapping rule using WIN_SSPI plugin: windows user group conversion to firebird role does not work
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-5395
Invalid data type for negation (minus operator)
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-5118
Indices on computed fields are broken after restore (all keys are NULL)
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-5074
Lost the charset ID in selection of array element
Contributor(s):
Dmitry Kovalenko <dmitry.lipetsk at gmail.com>
* Bugfix CORE-5070
Compound index cannot be used for filtering in some ORDER/GROUP BY queries
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-3925
Creating self-referential FK crashes database (bug-check) whether constraint violation had place
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>
* Bugfix CORE-2440
Restoring DB with computed index on computed field provides wrong index and wrong select results
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Improvement CORE-6072
Ensure providers compatibility across versions
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Improvement CORE-6004
Add a configuration switch to disable the "TCP Loopback Fast Path" option (Windows only)
Contributor(s):
KarloX2 <info at ait-software.de>
* Improvement CORE-5948
Make WIN_SSPI plugin produce keys for the wirecrypt plugin
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Improvement CORE-5928
Make it possible for AuthClient plugin to access authentication block from DPB
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Improvement CORE-5741
Replace word "fixing" with "adjusting" in GBAK output
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Improvement CORE-5724
Add ability to use "install.sh -path /opt/my_path" without need to install FB first in the default folder ("/opt/firebird")
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Improvement CORE-4462
Make it possible to restore compressed .nbk files without explicitly decompressing them
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
Vlad Khorsun <hvlad at users.sourceforge.net>
**************************
* v3.0.4
**************************
* Bugfix CORE-5911
Connection could hung after no activity for 60 seconds
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>
* Bugfix CORE-5905
Inconsistencies with PSQL FUNCTION vs UDF
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-5904
An attempt to create global mapping with long (> SQL identifier length) FROM field fails
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-5900
Login attempts while engine is shutting down caused unnecessary delays in shutdown process
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-5899
Memory leak in GBAK code when used as service
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-5898
ROLE not passed in EXECUTE STATEMENT ... ON EXTERNAL
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>
* Bugfix CORE-5893
GBAK may crash database when mixing alias with full database name
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-5891
Invalid events are released in mapping shared memory when dead process is detected
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-5886
Nbackup does not work after 32K of backups iterations
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-5884
Initial global mapping from Srp plugin does not work
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-5881
Network server ignores any error that took place in KeyHolderPlugin when establishing initial callback with client
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-5880
Unhandled: C0000005.ACCESS_VIOLATION
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>
* Bugfix CORE-5879
Error reading/writing data to connection
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>
* Bugfix CORE-5872
Database validation reports false errors "Record XXX has bad transaction" and\or "Record XXX is wrong length" when record transaction number is greater than 2^32
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>
* Bugfix CORE-5870
ISQL's "show database" command works wrong with 64-bit numbers
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>
* Bugfix CORE-5869
Sweep can't move OIT value over 2^32, when Next already greater than 2^32 (4'294'967'296)
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>
* Bugfix CORE-5865
Alignment error on x86_64
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-5863
Classic process crashes when client has disconnected
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>
* Bugfix CORE-5852
There is no check of existance generator and exception when privileges are granted
Contributor(s):
Roman Simakov <roman.simakov at red-soft.biz>
* Bugfix CORE-5847
"Malformed string" instead of key value in PK violation error message
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>
* Bugfix CORE-5846
CREATE VIEW issues "Implementation of text subtype 512 not located"
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-5844
Firebird freezes for new connections
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>
* Bugfix CORE-5843
Wrong handling of failures of TRANSACTION START trigger
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>
* Bugfix CORE-5840
Reference privilege is ignored
Contributor(s):
Roman Simakov <roman.simakov at red-soft.biz>
* Bugfix CORE-5837
Inconsistent results when working with GLOBAL TEMPORARY TABLE ON COMMIT PRESERVE ROWS
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>
* Bugfix CORE-5833
DDL triggers for some object types (views, exceptions, roles, indexes, domains) are lost in backup-restore process
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-5831
Not user-friendly output of GSTAT at encrypted database
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-5830
Encryption Interface crashing Firebird process when working on big db file
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-5829
GSEC does not release user manager plugin
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-5824
Segmentation fault during install on Linux
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-5822
Client gets SQLSTATE = 28000 ("user/password not defined") if WireCrypt = Disabled is used on client side
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-5819
Attachment might not gone after it was deleted FROM MON$ATTACHMENTS
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>
* Bugfix CORE-5817
Unable to compile Firebird with ICU 60 or higer
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-5815
Server hangs for 60/120 seconds if client exits during database encryption key transfer callback
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-5804
Multiple errors in REVOKE operator
Contributor(s):
Roman Simakov <roman.simakov at red-soft.biz>
* Bugfix CORE-5801
All database blobs can be acceses by any user (id iteration may be used for unauthorized access)
Contributor(s):
Dmitriy Starodubov <dmitry.starodubov at red-soft.biz>
* Bugfix CORE-5796
GSTAT may produce faulty report about presence of some none-encrypted pages in database
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-5793
Error returned from DbCryptPlugin::setKey() is not shown
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-5791
ODS for windows builds and linux-x64 (on the one side) and linux-x86 (on the other side) does not match
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-5790
User with DROP DATABASE privilege can't drop database
Contributor(s):
Roman Simakov <roman.simakov at red-soft.biz>
* Bugfix CORE-5788
Security Patch: Replacement of use of SHA-1 in the SRP Client Proof with SHA-256
Contributor(s):
Tony Whyman <tony.whyman at mccallumwhyman.com>
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-5783
EXECUTE STATEMENT ignores the text of the SQL-query after a comment of the form "-"
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>
* Bugfix CORE-5780
Server hangs when client tries to send too long DB encryption key(s)
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-5778
install.sh fails if -path argument contains "firebird"
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-5776
"Input parameter mismatch" error after altering external function into PSQL function
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>
* Bugfix CORE-5773
PSQL cursor doesn't see inserted record
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>
* Bugfix CORE-5772
Client hangs when working with events under high load
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-5769
Database crypt plugin sample on Pascal is broken
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-5765
Missing directives in Firebird.pas
Contributor(s):
Tony Whyman <tony.whyman at mccallumwhyman.com>
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-5764
Installation of Firebird 3.0.3 on SLES 12 SP3 fails with ''Could not find acceptable ICU library"
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-5762
Wrong transaction number in RDB$PAGES relation may cause infinite recusrion in engine and segfault
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-5760
Server process crashes while restoring database
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>
* Bugfix CORE-5757
Deadlock with events
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-5756
FB crashes when trying to recreate table that is in use by DML
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-5755
No error if the GRANT target object does not exist
Contributor(s):
Roman Simakov <roman.simakov at red-soft.biz>
* Bugfix CORE-5754
ALTER TRIGGER check privilege for alter database instead of table
Contributor(s):
Roman Simakov <roman.simakov at red-soft.biz>
* Bugfix CORE-5753
Parser should not allow to use GRANT OPTION for FUNCTION and PACKAGE
Contributor(s):
Roman Simakov <roman.simakov at red-soft.biz>
* Bugfix CORE-5747
User can grant usage privilege by himself
Contributor(s):
Roman Simakov <roman.simakov at red-soft.biz>
* Bugfix CORE-5745
GRANT privileges error during database restore
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-5743
Conversion error when both GROUP/ORDER BY expressions and WHERE expressions contain literals
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-5742
Incorrect error message in iSQL when trying to create database with wrong password
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-5737
Invalid parameters of gds transaction in ISQL
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-5702
Firebird Handle Leak Windows
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>
* Bugfix CORE-5436
SuperClassic server hangs (under load test)
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>
* Bugfix CORE-4964
Real errors during connect to security database are hidden by Srp user manager
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-405
Garbage vs indices/constraints
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>
* Improvement CORE-5913
Add context variables with compression and encryption status of current connection
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>
* Improvement CORE-5908
Enhance dynamic libraries loading related error messages
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Improvement CORE-5876
Provide name of udf function for "arithmetic exception, numeric overflow, or string truncation"
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Improvement CORE-5860
Support auth_plugin_list dpb/spb item from application to client
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Improvement CORE-5853
Forward-compatible expressions LOCALTIME and LOCALTIMESTAMP
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Improvement CORE-5746
Remove the restriction on create/delete, enable/disable the user-defined indexes in system tables
Contributor(s):
Rashid Abzalov <rashid.abzalov at gmail.com>
Vlad Khorsun <hvlad at users.sourceforge.net>
**************************
* v3.0.3
**************************
* Bugfix CORE-5735
Additional keyholder opens unauthorized connections to encrypted database
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-5730
Connection to server may hang when working with encrypted databases over non-TCP protocol
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-5721
Information items isc_info_length and fb_info_crypt_state have the same code
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-5720
Sweep in Firebird 3 in CS mode could run too slow when there is big load on server
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>
* Bugfix CORE-5719
FB 3 crashes when restoring backup made by FB 2.5
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-5713
Field alias disappears in complex query
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-5707
Begin and end of physical backup in the same transaction could crash engine
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>
* Bugfix CORE-5706
Trace config with misplaced "{" lead Firebird to crash
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-5695
Position function does not consider the collation for blob
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>
* Bugfix CORE-5694
Duplicate values in columns with a unique constraint
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>
* Bugfix CORE-5686
Firebird 3.0.2 allows any protocol version >= 10 to connect, including interbase protocol 14
Contributor(s):
Mark Rotteveel <mark at lawinegevaar.nl>
* Bugfix CORE-5684
Error "no current record for fetch operation" is raised while deleting record from MON$ATTACHMENTS using ORDER BY clause
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-5681
AV when external statement is executed and local transaction is rolled back
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>
* Bugfix CORE-5675
isc_vax_integer() and isc_portable_integer() work wrongly with short negative numbers
Contributor(s):
Dimitry Sibiryakov <sd at ibphoenix.com>
* Bugfix CORE-5673
Unique constraint not working in encrypted database on first command
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-5667
Message "CTE 'X' has cyclic dependencies" appear when 'X' is alias for resultset and there is previous CTE part with the same name 'X' in the query
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>
* Bugfix CORE-5659
Bad PLAN generated for query on Firebird v3.0
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-5655
isc_info_sql_relation_alias reports incorrect alias for CTE or nested queries
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>
* Bugfix CORE-5654
Mixed intermediate build files for plugins examples
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-5653
GBAK restore with large number of small blobs is very slow using Linux Classic
Contributor(s):
Roman Simakov <roman.simakov at red-soft.biz>
* Bugfix CORE-5651
Problem migrating users to V3.0
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-5650
Segfault when procedure is being dropped on Classic server
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-5649
isc_add_user / isc_modify_user produce unusable user record
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-5645
Wrong transaction can be passed to the external engine
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-5643
Message "Operating system call munmap failed" can appear in firebird.log under heavy load (2.5.x, CS, SC)
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-5638
Wrong result with index on case-insensitive collation using NUMERIC-SORT
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-5630
Cannot create the shadow file
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-5624
Using backslash in alias on Linux does not work
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-5618
Part of the pages of the second level blobs is not released when deleting relations
Contributor(s):
Denis Logashov <den.logash at gmail.com>
* Bugfix CORE-5613
SuperServer could hung when changing physical backup state under high load
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>
* Bugfix CORE-5605
Incorrect check for existing MAP in a case when pre-FB3 security database is used
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-5600
Invalid blob id when add a new blob column of type text and update another field
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>
* Bugfix CORE-5598
Error "block size exceeds implementation restriction" while inner joining large datasets with a long key using the HASH JOIN plan
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-5591
Engine hangs soon after some errors during transaction start
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-5588
DbInfo interface is not passed to ancillary instances of plugin
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-5580
Signature of packaged functions is not checked for mismatch with [NOT] DETERMINISTIC attribute
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-5579
Request synchronization error in the GBAK utility (during restore)
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>
* Bugfix CORE-5576
Bugcheck on queries containing WITH LOCK clause
Contributor(s):
Roman Simakov <roman.simakov at red-soft.biz>
* Bugfix CORE-5570
Negative infinity (double) shown incorrectly without sign in ISQL
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-5569
ISQL incorrectly pads UNICODE_FSS/UTF8 columns when they use a collation
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-5567
Direct system table modifications are not completely prohibited
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-5566
Server crashes while restoring backup if the shadow file already exists
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-5562
Firebird crashes when UDF gets loaded and unloaded frequently
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-5555
Firebird 3 error handling for SELECT WITH LOCK breaks compatibility with 2.5
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>
* Bugfix CORE-5553
Database cannot be encrypted if DatabaseAccess is set to None
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-5550
Computed decimal field in a view has wrong RDB$FIELD_PRECISION
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-5549
Errors building / running FB on non-SSE enabled HW
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-5547
Server crashes while compiling stored procedure with nested references to query-based computed fields
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-5542
Database-level triggers related to TRANSACTION events (start/commit/rollback) do not take in account their POSITION index
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-5540
Every other execution of embedded ISQL is slow
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>
* Bugfix CORE-5535
Garbage value in RDB$FIELD_SUB_TYPE in RDB$FUNCTION_ARGUMENTS after altering function
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-5533
Crash on 3.0 and 4.0 when DB contains database-level trigger
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-5528
internal Firebird consistency check (limbo impossible (184), file: vio.cpp line: 2379)
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>
* Bugfix CORE-5527
External routines does not receive default values for they output parameters
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-5526
External routines receives parameters with incorrect length or datatype
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-5521
Race condition between event notification and event registration
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>
* Bugfix CORE-5517
Classic server periodically raise "Global mapping memory overflow" and need to be restarted to accept new connections
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-5516
Firebird service crashes when stopping
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>
* Bugfix CORE-5510
Firebird 3+ may send status vector with more then 20 items to old clients and cause disconnect
Contributor(s):
Roman Simakov <roman.simakov at red-soft.biz>
* Bugfix CORE-5416
Memory leak: Firebird does not release memory after load tests
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>
* Bugfix CORE-5415
[security3.fdb] wrong page type page 22 is of wrong type (expected pointer, found index root)
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>
* Bugfix CORE-4492
OR/IN predicates for RDB$DBKEY lead to NATURAL plan
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-2853
Bugcheck: page N, page type 5 lock conversion denied (215)
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>
* Bugfix CORE-2731
Recursive EXECUTE STATEMENT works wrong
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>
* Bugfix CORE-2502
Aliases and error about cyclic dependencies in CTE
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>
* Bugfix CORE-2284
Records left in RDB$PAGES after rollback of CREATE TABLE statement
Contributor(s):
Roman Simakov <roman.simakov at red-soft.biz>
Dmitry Yemanov <dimitr at firebirdsql.org>
* Improvement CORE-5727
Faster engine response on cancel/shutdown signals when scanning long list of pointer pages
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>
* Improvement CORE-5712
Access to the name of DB encryption key
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Improvement CORE-5704
Avoid UPDATE of RDB$DATABASE by ALTER DATABASE statement when possible
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>
* Improvement CORE-5676
Consider equivalence classes for index navigation
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Improvement CORE-5674
Allow unused Common Table Expressions
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>
* Improvement CORE-5660
Make flush of big number of dirty pages faster
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>
* Improvement CORE-5648
Avoid serialization of isc_attach_database calls issued by EXECUTE STATEMENT implementation
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>
* Improvement CORE-5629
GSTAT output does not include datetime of analysis
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Improvement CORE-5614
Physical backup merge stage could run too long, especially with huge page cache
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>
* Improvement CORE-5610
Provide info about database (or alias) which was in use during "Error during sweep: connection shutdown"
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Improvement CORE-5602
ALTER DOMAIN is slow if many dependencies exist
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>
* Improvement CORE-5601
Add details on compression and crypt status of connection (fb_info_conn_flags) to getInfo() API call
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Improvement CORE-5543
Restore of pre ODS 11.1 database can leave RDB$RELATION_TYPE null
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Improvement CORE-4913
Database backup using Nbackup is getting slow when directed to NAS over SMB protocol
Contributor(s):
Jan Hejda <jan.hejda at lim.cz>
Vlad Khorsun <hvlad at users.sourceforge.net>
* Improvement CORE-3295
Estimate the actual record compression ratio in the optimizer
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
**************************
* v3.0.2
**************************
* Bugfix CORE-5503
Classic Server has a maximum of 64 connections when using systemd init scripts
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-5501
CORE-5501: Unclear gstat's diagnostics when damaged page in DB file appears encrypted
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-5498
Cannot create connection for events processing
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>
* Bugfix CORE-5496
Creating SRP SYSDBA with explicit admin (-admin yes in gsec or grant admin role in create user) creates two SYSDBA accounts
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-5489
Bad performance for NULLs filtering inside a navigational index scan
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-5484
Database on NFS share is unavailable when accessed using mount point path
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-5477
Trace duplicates ascii_char(13) in its output (Windows only)
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>
* Bugfix CORE-5474
'Restrict UDF' is not effective, because fbudf.so is dynamically linked against libc
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-5472
Problems with dbcrypt key transfer
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-5470
Trace INCLUDE_FILTER with [[:WHITESPACE:]]+ does not work when statement contains newline is issued
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>
* Bugfix CORE-5464
AV in fbclient when reading blob stored in incompatible encoding
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>
* Bugfix CORE-5458
Connections fail due to dead NFS mount points
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-5457
Bugcheck 167 (invalid SEND request)
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-5456
Migrating Firebird 2.5.2 to 3.0.1 gbak restore crashes at the end always
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-5452
Segfault when engine's dynamic library is unloaded right after closing worker threads (GC and/or cache writer)
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-5448
FB3 bugchecks when creating view on table which has column with character set NONE, database default charset is UTF8, and default collation is UNICODE
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>
* Bugfix CORE-5447
EXECUTE STATEMENT <e> when <e> starts with '--' (comment) issues "Unexpected end of command" error with wrong column number
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-5435
Badly selective index could be used for extra filtering even if selective index is used for sorting
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-5432
Performance regression in Classic Server: too much time is spent during context switches
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-5428
Rare segfault when preparing request working with a table with triggers
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-5425
Server hangs under load test
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-5422
Decompression overran buffer after rollback
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>
* Bugfix CORE-5421
Performance degradation in FB 3.0.2 compared to FB 2.5.7
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-5417
Engine could hang up if auto-sweep is starting while database is shutting down
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>
* Bugfix CORE-5414
Error restoring on FB 3.0 from FB 2.5: bugcheck 221 (cannot remap)
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-5410
Dependencies are not stored when using some type of constructions in subroutines
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-5393
Bad optimization of some operations with views containing subqueries
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-5392
BUGCHECK 179 (decompression overran buffer) or unexpected lock conflict may happen during record versions backout
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-5390
ISQL crashes corrupting memory when statement length is greater than 10 MB
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-5384
Plugin manager fails to provide appropriate config information when name of configuration file is set in plugins.conf
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-5383
Dependencies in PSQL packages are not recognised
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-5382
Incorrect processing (truncation) of SQL statement longer than 10MB
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-5381
Regression: could not execute query (select from view with nested view)
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-5368
Regression: client application hangs or throw AV on selecting from multiple threads using 1 embedded connection
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-5367
Regression: (boolean) parameters as search condition no longer allowed
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-5366
Regression: could not use CASE expression with more than 255 conditions
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-5359
New API - MessageMetadata's getScale() returns int but MetadataBuilder's setScale() wants unsigned
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-5350
Assertion in CachedMasterInterface::set
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>
* Bugfix CORE-5314
UDFs declared with large varchars take excessive time to execute
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-5120
Configure: snprintf function is already defined on MSVC 2015
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>
* Bugfix CORE-3530
BETWEEN operand/clause not supported for COMPUTED columns -- "feature is not supported"
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-1894
Circular dependencies between computed fields crashs the engine
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Improvement CORE-5475
Provide ability to filter out info and warnings from trace log
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>
* Improvement CORE-5442
Enhance control upon ability to share database crypt key between attachments in SS
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Improvement CORE-5441
Cache physical numbers of often used data pages to reduce number of fetches of pointer pages
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>
* Improvement CORE-5434
Read-only transactions in SuperServer could avoid immediate write of Header and TIP pages after change
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>
* Improvement CORE-5374
Make database name available to crypt plugin
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Improvement CORE-5257
Enable nested keys in plugin configuration
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>
* Improvement CORE-5204
Build the Linux code with --enable-binreloc and create an option in the installer
to install in different locations than /opt/firebird
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Improvement CORE-4486
Trace: provide filter to INCLUDE / EXCLUDE errors by their mnemonical names
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>
* Improvement CORE-3637
Port for Linux/m68k
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Improvement CORE-1095
Support BETWEEN predicate for select expressions
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* New feature CORE-5332
libfbclient.so for Android (x86/x86-64/arm64)
Contributor(s):
Marius Adrian Popa <mapopa at gmail.com>
* New feature CORE-4563
Add support for Windows 8/2012 fast/low-latency "TCP Loopback Fast Path" functionality
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>
* New feature CORE-3885
Android port (arm32)
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
**************************
* v3.0.1
**************************
* Bugfix CORE-5355
XpbBuilder fails to create new TPB
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-5351
LEFT JOIN incorrectly pushes UDF into the inner stream causing wrong results
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-5348
Databases created at build process are owned by Windows administrator, not SYSDBA
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>
* Bugfix CORE-5347
Races when initializing wire compression
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-5341
User collate doesn't work with blobs
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-5339
Assertion in createDatabase() when doing overwrite check
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-5337
Subquery in the insert list expression ignores the changes made earlier in the same executable block
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>
* Bugfix CORE-5335
Segfault when op_que_events is used on a port not prepared for events processing
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-5329
Database gets partially corrupted in the "no-reserve" mode
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-5327
BUGCHECK 165 (cannot find tip page)
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>
* Bugfix CORE-5322
Cascade deletion in self-referencing table could raise "no current record for fetch operation" error
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>
* Bugfix CORE-5313
Data type unknown error with LIST
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-5308
ISQL hangs in BLOBVIEW command
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-5307
Random "invalid transaction handle" errors are returned from the engine
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-5305
CASCADE UPDATE fails for self-referencing FK
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>
* Bugfix CORE-5302
Performance regression when bulk inserting into table with indices
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>
* Bugfix CORE-5296
Error in network protocol when performing callback to client for database crypt key
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-5295
Validation could read after the end-of-file when handle multifile database
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>
* Bugfix CORE-5294
Memory leak when use SHOW GRANTS on new empty database
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-5292
Database corrupted when trying to encrypt it but appropriate key is missing
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-5289
Small memory leak when resultset is empty
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>
* Bugfix CORE-5285
Segfault when attachment is closed before it's request/statement/etc.
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-5284
Firebird fails to build with USE_VALGRIND
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-5279
Granting access rights to view is broken
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-5278
Some SPB parameters fail in FB 3.0
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-5277
Parameters with multibyte character sets allow to bypass the character limit of VARCHAR fields
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-5275
Expression index may become inconsistent if CREATE INDEX was interrupted after b-tree creation but before commiting
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-5270
FBSVCMGR does not produce error while attempting to shutdown a database without specified timeout (prp_force_shutdown N)
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-5268
Nested OR conditions may lead to incorrest results
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-5264
Database cannot be unlocked (nbackup) if located on a raw device
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-5249
Incorrect use of readlink() system call
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-5248
Improve consistency in GRANT syntax between roles and privileges according to SQL standard
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-5246
String truncation error while selecting from MON$ tables if some user-defined context variable exceeds 255 bytes in length
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-5244
Wrong error message when trying to execute SELECT statement using isc_dsql_execute_immediate()
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-5241
Affected rows are not counted for some update operations with views
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-5236
IN/ANY/ALL predicates may cause sub-optimal (late filtering) execution of joins
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-5234
Access violation on UDF crashes server
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>
* Bugfix CORE-5233
Unaligned memory access in MET_format() causes segfault on big-endian machines
Contributor(s):
James Clarke <jrtc27 at jrtc27.com>
* Bugfix CORE-5232
32-bit locks on big-endian systems lead to deadlock
Contributor(s):
James Clarke <jrtc27 at jrtc27.com>
* Bugfix CORE-5231
EXECUTE STATEMENT: BLR error if more than 256 output parameters exist
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-5228
Restore may hang if the database contains more than 4 billion records
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-5226
Incorrect result set (missing records) may be returned by the ORDER plan query navigating on a descending index
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-5225
Authentication end with first plugin that has the user but auth fails (should continue with next plugin)
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-5224
Transaction id tags for services API do not support new 48 bit transaction ids
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-5222
SELECT WITH LOCK may raise unexpected update conflict errors under concurrent load
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-5220
ISQL -X: double quotes are missed for COLLATE <C> of CREATE DOMAIN statement when <C> is from any non-ascii charset
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-5218
Explicitly defined names for NOT NULL constraints are not exported into script by ISQL -x
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-5217
ISQL -x may crash while exporting an exception with message text length > 127 bytes
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-5213
Database may get decrypted after changing couple of bytes in database header w/o 'agreement' from crypt plugin
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-5210
Firebird 3.0 + fbclient 3.0 - POST_EVENT won't work
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>
* Bugfix CORE-5207
ISQL -X may generate invalid GRANT USAGE statements for domains
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-5203
Single CPU core fully utilized with trace session
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-5193
Precedence problem with operator IS
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-5183
Regression: line/column numbering may be twisted if alias.name syntax is used
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-5154
Services API don't work with non-ASCII database names
Contributor(s):
Dimitry Sibiryakov <sd at ibphoenix.com>
* Bugfix CORE-5142
Error "no current record to fetch" if some record is to be deleted both by the statement itself and by some trigger fired during statement execution
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>
* Bugfix CORE-1746
Expression index can be created while doing inserts into table
Contributor(s):
Vlad Khorsun <hvlad at users.sourceforge.net>
* Improvement CORE-5266
Allow statement 'create OR ALTER user sysdba password ...' to initialize empty securityN.fdb as 'CREATE user ...'
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Improvement CORE-5257
Enable nested keys in plugin configuration
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Improvement CORE-5229
Allow to enforce IPv4 or IPv6 in URL-like connection strings
Contributor(s):
Michal Kubeček <mike at mk-sys.cz>
* Improvement CORE-5216
Provide location context (line/column numbers) for runtime errors raised inside EXECUTE BLOCK
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Improvement CORE-5205
Add a switch to build linux binaries with builtin libtommath
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Improvement CORE-5201
Return nonzero result code when restore fails on activating and creating deferred user index
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Improvement CORE-5167
Allow implicit conversion between boolean and string
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
**************************
* v3.0 Final Release
**************************
* Bugfix CORE-5194
Invalid COMPUTED BY definition generated by ISQL (extract metadata)
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-5189
Codes of operation of user management plugin are missing in public API
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-5184
Assertion in cloop dispatcher when trying to save exception information in status interface
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-5182
Inconsistent effects of subsequent statement execution if failing during record refetch
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-5181
Build fails when HAVE_MMAP is not defined
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-5179
Database-level statistics (MON$STAT_GROUP = 0) may contain multiple rows under concurrent load
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-5166
Wrong error message with UNIQUE BOOLEAN field
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-5165
HAVING COUNT(*) NOT IN ( <Q> ) prevent record from appearing in outer resultset when it should be there (<Q> = resultset without nulls)
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-5162
SEC$ tables and tag/attributes
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-5161
Unique index could be created on non-unique data
Contributor(s):
Vlad Khorsun <hvlad at users.sf.net>
* Bugfix CORE-5159
Regression: engine may throw transliteration errors when running from non-ASCII system path
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-5157
Server goes into infinite loop when data is sent from client to the service in small packets
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-5155
[CREATE OR] ALTER USER statement: clause PASSWORD (if present) must be always specified just after USER
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-5153
Regression: Server crashes when aggregate functions are used together with NOT IN predicate
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-5149
Regression: LEFT JOIN incorrectly pushes COALESCE into the inner stream causing wrong results
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-5147
CREATE TRIGGER fails with "ambiguous field name between table B and table A" error
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-5146
Suboptimal join order if one table has a selective predicate and MIN is calculated for the other one
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-5144
Deadlock when database is encrypted or decrypted under high parallel load
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-5143
GBAK restore fails when there is SQL function accessing table and switch -O(NE_AT_A_TIME) is used
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-5140
Wrong error message when user tries to set number of page buffers into not supported value
Contributor(s):
Vlad Khorsun <hvlad at users.sf.net>
* Bugfix CORE-5134
Samples of dbcrypt-related plugins contain references to internal files
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-5133
ALTER SEQUENCE RESTART WITH does not change the initial value
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-5130
Message about "invalid request BLR" attempting to compile wrong DDL of view with both subquery and "WITH CHECK OPTION" in its DDL
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-5122
Expression index may not be used by the optimizer if created and used in different connection charsets
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-4645
Internal Firebird consistency check (cannot find tip page (165), file: tra.cpp line: 2375)
Contributor(s):
Vlad Khorsun <hvlad at users.sf.net>
* Improvement CORE-5180
Do not require root rights to build linux package
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
**************************
* v3.0 Release Candidate 2
**************************
* Bugfix CORE-5110
False PK\FK violation could be reported when attachment used isc_dpb_no_garbage_collect flag
Contributor(s):
Vlad Khorsun <hvlad at users.sf.net>
* Bugfix CORE-5107
SET AUTODDL OFF and sequence of CREATE + ALTER + DROP VIEW leads to server crash
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-5105
Deadlocks when database is initially encrypted
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-5104
External data source selects became slow
Contributor(s):
Vlad Khorsun <hvlad at users.sf.net>
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-5102
fbclient.dll API calls modify FPU control word
Contributor(s):
Vlad Khorsun <hvlad at users.sf.net>
* Bugfix CORE-5101
Restore is slow when the database contains many small tables with indices
Contributor(s):
Vlad Khorsun <hvlad at users.sf.net>
* Bugfix CORE-5097
COMPUTED-BY expressions are not converted to their field type inside the engine
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-5093
ALTER does not change type of a computed field
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-5092
ISQL extract command lose COMPUTED BY field types
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-5089
Metadata extration (ISQL -X): "CREATE PROCEDURE/FUNCTION" statement contains reference to column of table(s)
that not yet exists if this procedure had parameter of such type when it was created
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-5088
Segmentation fault when 'gstat -h' is closing
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-5087
Database shutdown can cause server crash if multiple attachments run EXECUTE STATEMENT
Contributor(s):
Vlad Khorsun <hvlad at users.sf.net>
* Bugfix CORE-5082
Server does not validate correctness of user/password pair provided in EXECUTE STATEMENT operator
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-5078
"Invalid BLOB ID" error is thrown unexpectedly
Contributor(s):
Vlad Khorsun <hvlad at users.sf.net>
* Bugfix CORE-5075
Trigger on DISCONNECT with EXECUTE STATEMENT: 1) does not work in 3.0; 2) leads FB to crash when it is recreated
Contributor(s):
Vlad Khorsun <hvlad at users.sf.net>
* Bugfix CORE-5067
Blocking new connections as a consequence of the sweeping the security database too long
Contributor(s):
Vlad Khorsun <hvlad at users.sf.net>
* Bugfix CORE-5062
CHAR_TO_UUID on column with index throws "expression evaluation not supported"
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-5061
ISQL plan output is unexpectedly truncated after a query is simplified to become shorter
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-5060
Cannot CREATE VIEW that selects from a system table, despite having all grants
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-5056
Write-lock of database file is cleared when retrieving the database statistics via the Services API
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-5053
changeServerMode.sh can mess with configuration
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-5049
Incorrect calculation of byte-length for view columns
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-5047
mapUser() routine establish secondary attach using wrong provider
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-5044
Pages are encrypted for each shadow separately
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-5042
FB3 client cannot create database on FB2.5 server
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-5041
Database may get corrupted after ALTER DATABASE ENCRYPT/DECRYPT issued multiple times per database open time
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-5039
Connecting to service with invalid servicename yields incorrect error message
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-5034
At least 5 seconds delay on disconnect could happen if disconnect happens close after Event Manager initialization
Contributor(s):
Vlad Khorsun <hvlad at users.sf.net>
* Bugfix CORE-5033
File fb_user_mapping could be left in Firebird lock directory after correct shutdown of all Firebird worker processes
Contributor(s):
Vlad Khorsun <hvlad at users.sf.net>
* Bugfix CORE-5032
Cannot connect to a database which have own security database without security3.fdb
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-5029
Crash in fbclient when multi-threaded application uses XNET protocol
Contributor(s):
Vlad Khorsun <hvlad at users.sf.net>
* Bugfix CORE-5026
Firebird authentication gives up after first common plugin
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-5020
ORDER BY clause on compound index may disable usage of other indices
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-5018
Non-indexed predicates may not be applied immediately after retrieval when tables are being joined
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-5017
Interrupt of aux connection during TCP setup phase causes server exit due to unhandled exception
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-5016
Server crashes during GC when DELETE is executed after adding new referencing column
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-5015
Server may crash when event is posted from ON DISCONNECT trigger
Contributor(s):
Vlad Khorsun <hvlad at users.sf.net>
* Bugfix CORE-5014
Interrupt of aux connection during TCP setup phase causes unclear error messages in firebird.log
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-5002
Windows installer includes malformed strings
Contributor(s):
Paul Reeves <preeves at ibphoenix.com>
* Bugfix CORE-4999
Deadlock when trying to access database with invalid crypt key
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-4998
Both client and server could not close connection after failed authentification
Contributor(s):
Vlad Khorsun <hvlad at users.sf.net>
* Bugfix CORE-4997
Races when two threads try to establish first enbedded connections to engine simultaneously
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-4991
Key holder plugin is loaded on connect to database but not on create
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-4990
Database is not decrypted completely
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-4982
Server crashes during "select from procedure" if exception is thrown while backing out the current savepoint
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-4980
Operator REVOKE can modify rights granted to system tables at DB creation time
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-4969
SEC$USERS table is unavailable in case of any error in any configured user manager plugin
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-4964
Real errors during connect to security database are hidden by Srp user manager
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-4910
Firebird build on Windows fail if path to sources contains spaces
Contributor(s):
Dimitry Sibiryakov <sd at ibphoenix.com>
* Bugfix CORE-4885
Error retrieving current user name when using Windows trusted authentication and OS user name contains non-ASCII characters.
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-4862
ibase.h from x64 package includes non-existing file
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-4842
Installer script fails in some Linux environments
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
Mykhaylo Masyk <miwaonline at gmail.com>
* Bugfix CORE-4840
Transactions with isc_tpb_autocommit can hang the server
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-4708
Content of MON$EXPLAINED_PLAN in MON$STATEMENTS is truncated if exceeds the 32KB limit
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-4179
Unable to read MON$ tables when there's intensive disk-bound load
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-2923
Problem with dependencies with views
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Improvement CORE-5112
Improve error messages for malformed SQDLA
Contributor(s):
Dimitry Sibiryakov <sd at ibphoenix.com>
* Improvement CORE-5100
Improve control over database crypt keys
See also:
/doc/sql.extensions/README.ddl.txt
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Improvement CORE-5083
Provide method to correcty set offsets in implemented by user IMessageMetadata
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Improvement CORE-5077
ISQL does not show encryption status of database
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Improvement CORE-5063
Make SHOW DATABASE command to show numbers of used and free pages in database
Contributor(s):
Vlad Khorsun <hvlad at users.sf.net>
* Improvement CORE-5028
Report the remote port number in MON$ATTACHMENTS
Contributor(s):
Vlad Khorsun <hvlad at users.sf.net>
* Improvement CORE-4978
Improve validation and fixup of lost data pages
Contributor(s):
Roman Simakov <roman.simakov at red-soft.biz>
Vlad Khorsun <hvlad at users.sf.net>
* Improvement CORE-2493
Append the IP address of the remote host to error messages in firebird.log for TCP connections
Contributor(s):
Vlad Khorsun <hvlad at users.sf.net>
* New feature CORE-4996
Need some SECURITY2.FDB --> SECURITY3.FDB upgrade feature
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* New feature CORE-1538
Add an option to isc_database_info() API to return the number of free pages in a database
Contributor(s):
Vlad Khorsun <hvlad at users.sf.net>
**************************
* v3.0 Release Candidate 1
**************************
* Bugfix CORE-4984
Ordering by compound index together with a range condition gives wrong results
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-4954
Packaged procedure with value by default isn't called if this parameter isn't specified
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-4952
SuperServer could hung on database shutdown
Contributor(s):
Vlad Khorsun <hvlad at users.sf.net>
* Bugfix CORE-4951
Message "Incorrect parameters provided to internal function INF_transaction_info Invalid token"
is reported when trying to commit 2PC transaction
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-4950
Statistics for any system index can not be updated/recalculated
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-4947
Compound ALTER TABLE statement with ADD and DROP the same check constraint fails
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-4943
Dialect 1 casting date to string breaks when in the presence a domain with a check constraint
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-4940
Add label about deterministic flag for stored function in SHOW and extract commands
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-4938
Cannot complete operations (get statistics, change FW, make backup) on database when FB works in embedded mode
Contributor(s):
Vlad Khorsun <hvlad at users.sf.net>
* Bugfix CORE-4929
Cannot compile source with "ELSE IF ( <expr> ) THEN" statement and commands to manipulate explicit cursor inside
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-4928
Impossible to save the connection information in the ON CONNECT trigger if the connection is created by GBAK
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-4921
Predicate IS [NOT] DISTINCT FROM is not pushed into unions/aggregates thus causing sub-optimal plans
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-4919
Classic server (all processes) hangs after death of one process (AIX / SOLARIS)
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-4917
ALTER DOMAIN ... TO <new_name> allows to specify <new_name> matching to 'RDB$[[:DIGIT:]]*'
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-4914
Moving database to 'full shutdown' state can corrupt index (at least) on long-key text field
Contributor(s):
Vlad Khorsun <hvlad at users.sf.net>
* Bugfix CORE-4909
MERGE / HASH JOINs produce incorrect results when VARCHAR join keys differ only by trailing spaces
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-4906
AV when server is shut down with active trace session(s)
Contributor(s):
Vlad Khorsun <hvlad at users.sf.net>
* Bugfix CORE-4904
Index corruption when add data in long-key-indexed field
Contributor(s):
Vlad Khorsun <hvlad at users.sf.net>
* Bugfix CORE-4902
Assertion (m_format->fmt_length == m_data.getCount()) failure
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
Vlad Khorsun <hvlad at users.sf.net>
* Bugfix CORE-4899
GFIX -online: message "IProvider::attachDatabase failed when loading mapping cache" appears in Classic (only) if access uses remote protocol
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-4897
FBSVCMGR can produce broken log when restoring database
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-4890
Placing comment (single-lined or multi-lined) between final `END` of creating SP code and terminal character (^)
produces compiling error when tool uses old API
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-4889
FBSVCMGR with `action_trace_start` prevents in 3.0 SuperServer from connecting using local protocol
Contributor(s):
Vlad Khorsun <hvlad at users.sf.net>
* Bugfix CORE-4887
AFTER CREATE/ALTER PACKAGE DDL triggers runs in incorrect moment
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-4884
Crash on parsing of script containing `execute block` with lot of nested begin..end statements
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-4882
ISQL input command (or -i option) reads large (> 64K) lines incorrectly
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-4876
Named trace session (launched by fbsvcmgr with non-empty value for 'trc_name' parameter) can not be stopped using its name
Contributor(s):
Vlad Khorsun <hvlad at users.sf.net>
* Bugfix CORE-4872
v3 fbclient cannot work with servers older than v2.5 via the remote protocol
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-4870
SET COUNT ON: issuing UPDATE on view which was created WITH CHECK OPTION produces wrong number of affected rows
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-4865
Online validation could wrongly report double allocated pages
Contributor(s):
Vlad Khorsun <hvlad at users.sf.net>
* Bugfix CORE-4864
CREATE DATABASE fails with ISQL
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-4861
Segmentation fault when working with saved exception in request
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-4860
Online validation fails on WINDOWS if `dbname` argument contains forward slash ('/') and concurrent attachment which also uses '/' exists
Contributor(s):
Vlad Khorsun <hvlad at users.sf.net>
* Bugfix CORE-4859
Firebird v3 embedded cannot work without folder C:\ProgramData\firebird
Contributor(s):
Vlad Khorsun <hvlad at users.sf.net>
* Bugfix CORE-4855
Online validation during DML activity in other connection leads to errors:
"Error while trying to read from file" and "page in use during flush (210)"
Contributor(s):
Vlad Khorsun <hvlad at users.sf.net>
* Bugfix CORE-4854
Client library incorrectly handles non-UTF8 representation of international characters in SPB
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-4848
MERGE ... WHEN NOT MATCHED ... RETURNING returns wrong (non-null) values when no insert is performed
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-4846
Altering a trigger indicating other table than the original does not reflect the change
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-4836
GRANT UPDATE(c) ON T TO U01 WITH GRANT OPTION: user U01 will not be able to revoke this privilege if some DML is executed before revoke
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-4710
Invalid request BLR at offset 361 context already in use (BLR error)
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-4680
Possible deadlock in firebird connect
Contributor(s):
Vlad Khorsun <hvlad at users.sf.net>
* Bugfix CORE-4585
Cannot create a column check constraint when the column is domain based
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-4497
Regression: wrong handling in FOR-cursor when NOT EXISTS( select from <VIEW> ) statement is used to check results obtained from SP
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-4292
Server ignores asynchronous (monitoring or cancellation) requests while preparing a query with lot of windowed functions
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-4279
Invalid error message: "CHARACTER SET OCTETS is not defined" on db creation with isc_dpb_lc_ctype = OCTETS
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-4277
It is possible to create a database with invalid character set
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-4276
Error on CREATE TABLE with "CHARACTER SET DOS775" field
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-4107
Wrong resultset (subquery + derived table + union)
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-3717
Anomalies between 3 methods of user management regarding valid user names and passwords
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-3548
GFIX returns an error after correctly shutting down a database
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-3545
Inconsistent domain's constraint validation in PSQL
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Improvement CORE-4965
Extend the transaction ID space beyond 2^32 transactions
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Improvement CORE-4955
Define a new option for DROP SHADOW command to leave the shadow file in the filesystem
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Improvement CORE-4939
Make I/O operations with nbackup backup file aligned at page size boundary
Contributor(s):
Vlad Khorsun <hvlad at users.sf.net>
* Improvement CORE-4936
Reduce internal contention in background garbage collector
Contributor(s):
Vlad Khorsun <hvlad at users.sf.net>
* Improvement CORE-4935
Increase performance of backout of dead record version (or undo of just created
primary record version) when backversions chain is too long
Contributor(s):
Vlad Khorsun <hvlad at users.sf.net>
* Improvement CORE-4923
Add ability to track domains rename in DDL triggers
See also:
/doc/sql.extensions/README.ddl_triggers.txt
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Improvement CORE-4911
Providers enumeration should not be continued on most of errors taking place in the provider
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Improvement CORE-4898
Speed up function creation and loading when there are many functions in the database
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Improvement CORE-4881
Increase maximum string literal length to 64KB while setting a lower limit (of characters)
for multi-byte charsets based on their maximum character length
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Improvement CORE-4880
Better performance of creating packages containing many functions
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Improvement CORE-4879
Minor inconvenience in user management via services API
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Improvement CORE-4851
Make tracing/audit aware of multiple security databases authentication
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Improvement CORE-3782
Convert password/user name into UTF-8 before encryption
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Improvement CORE-1999
Timestamps in the GBAK output
Contributor(s):
Vlad Khorsun <hvlad at users.sf.net>
*************
* v3.0 Beta 2
*************
* Bugfix CORE-4839
SHOW GRANTS does not display info about exceptions which were granted to user
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-4831
Revoke all on all from role <R> -- failed with "SQL role <R> does not exist in security database"
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-4821
Ensure CREATE DATABASE right is granted only to roles that do exist in security database
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-4819
EXECUTE PROCEDURE's RETURNING_VALUES and EXECUTE STATEMENT's INTO does not check validity of assignments targets leading to bugcheck
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-4817
ISQL doesn`t show number of affected rows for "MERGE ... WHEN MATCHING" in case when this number surely > 0
Contributor(s):
Claudio Valderrama C. <cvalde at usa.net>
* Bugfix CORE-4809
HASH/MERGE JOIN is not used for more than two streams if they are joined via USING/NATURAL clauses
and join is based on DBKEY concatenations
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-4807
Regression: List of aggregation is not checked properly
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-4806
Regression: generators can be seen/modified by unprivileged users
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-4802
GRANT UPDATE(<some_column>) on <T> acts like grant update on ALL columns of <T>
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-4798
Regression: MIN/MAX with a join ignores possible index navigation
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-4795
fbclient executes event callback function twice
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-4794
isc_cancel_events() returns error invalid events id (handle) (code: 335545021) if event is no longer queued
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-4789
Prohibit ability to cast timestamps that out of valid range to [VAR]CHAR
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-4788
SuperClassic server hangs when receiving network packet
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-4786
Problematic key value (when attempt to insert duplicate in PK/UK) is not shown where length of key >= 127 characters
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-4785
Bad packet of op_execute kills the server
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-4782
Command `SHOW TABLE` fails when the table contains field with unicode collation in its DDL
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-4781
Maximum string length (32765 bytes) is not validated by the parser
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-4774
Table aliasing is unnecessary required when doing UPDATE ... RETURNING RDB$ pseudo-columns
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-4768
CREATE USER ... TAGS ( argument_1 = 'value1', ..., argument_N = 'valueN' ) - wrong results of statement when there are many arguments
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-4767
CREATE USER ... TAGS ( attr = "prefix #suffix" ): "suffix" will be removed from storage because of character # in the value of attribute
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-4766
AV when trying to manage users list using EXECUTE STATEMENT on behalf of non-SYSDBA user which has RDB$ADMIN role
Contributor(s):
Vlad Khorsun <hvlad at users.sf.net>
* Bugfix CORE-4760
Cannot create user with non-ascii (multi-byte) characters in the name
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-4759
Request synchronization error when building an expression index
Contributor(s):
Vlad Khorsun <hvlad at users.sf.net>
* Bugfix CORE-4756
Firebird 3 events broken
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-4755
Parameterized exception: wrong output when number of arguments greater than 7
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-4754
Manipulations with GTT from several attachments (using ES/EDS and different roles) leads to:
"internal Firebird consistency check (invalid SEND request (167), file: JrdStatement.cpp line: 325)"
Contributor(s):
Vlad Khorsun <hvlad at users.sf.net>
* Bugfix CORE-4753
Firebird hangs in the embedded mode
Contributor(s):
Vlad Khorsun <hvlad at users.sf.net>
* Bugfix CORE-4752
EXECUTE STATEMENT using BLOB parameters results in "Invalid BLOB ID" error
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-4747
Error "invalid BLOB ID" can occur when retrieving MON$STATEMENTS.MON$SQL_TEXT using ES/EDS and db_connect argument is not specified
Contributor(s):
Vlad Khorsun <hvlad at users.sf.net>
* Bugfix CORE-4744
ALTER DATABASE SET DEFAULT CHARACTER SET: 1) take effect only for once for current attachment; 2) does not check that new char set exists untill it will be used
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-4743
Granted role does not work with non-ASCII user name
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-4740
SIMILAR TO with quantifier {n,} in the pattern: 1) fails on 2.5 ("Invalid pattern"), 2) strange result in 3.0
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-4733
Command "ALTER TABLE <T> ALTER TYPE <C> DOMAIN_WITH_NOT_NULL" does not verifies data in column <C> and makes incorrect assignments in <C> to ZERO / JULIAN_DATE / ASCII(0) for types INT, TIMESTAMP and VARCHAR
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-4725
Inconsistencies with ALTER DOMAIN and ALTER TABLE with DROP NOT NULL and PRIMARY KEYs
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-4719
Message "Statement failed, SQLSTATE = 00000 + unknown ISC error 0" appears when issuing REVOKE ALL ON ALL FROM <existing_user>
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-4715
Restore of shadowed database fails using -k ("restore without shadow") switch
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-4713
"BLOB not found" error at rollback after insert into table with expression index
Contributor(s):
Vlad Khorsun <hvlad at users.sf.net>
* Bugfix CORE-4712
Messages "Error in isc_release_request() ... when working with legacy security database" appear in firebird.log for CLASSIC server when connecting with legacy auth
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-4706
ISQL pads blob columns wrongly when the column alias has more than 17 characters
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-4705
FB3 SC crashes at disconnect after running EXECUTE STATEMENT as non-current user
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-4704
Generator/exception permissions get corrupted after backup/restore
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-4702
Join order in v3 is less optimal than in v2.x
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-4698
Typing "add -user SYSDBA -pw masterkey -admin yes" into GSEC crashes firebird.exe
Contributor(s):
Vlad Khorsun <hvlad at users.sf.net>
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-4684
Error while preparing a complex query ("Too many Contexts of Relation/Procedure/Views. Maximum allowed is 256")
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-4675
Conditions like WHERE <field> = <cursor>.<field> don't use existing index
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-4673
Computed index based on a computed column stores NULL for all its keys
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-4670
Constraint violation error may be swallowed in some cases
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-4668
SELECT FROM MON$TABLE_STATS doesn`t work on SC and CS
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-4665
Wrong result when use "where <field_C> STARTING WITH <:value> ORDER BY <field_N>' and field_C is leading part
of compound index key: { field_C, field_N }
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-4659
Error "Missing security context for .....\SECURITY3.FDB"
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-4656
Server could hang chasing dead record versions
Contributor(s):
Dmitriy Starodubov <dmitry.starodubov at red-soft.biz>
* Bugfix CORE-4655
MSVC8 and MSVC9 builds failed
Contributor(s):
Dmitriy Starodubov <dmitry.starodubov at red-soft.biz>
* Bugfix CORE-4653
Crash on infinite mutual SP calls (instead of "Too many concurrent executions of the same request.")
Contributor(s):
Vlad Khorsun <hvlad at users.sf.net>
* Bugfix CORE-4648
No permission for CREATE access to DATABASE (for RDB$ADMIN)
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-4646
Attach failure when using LegacyAuth on server and default configuration on client
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-4644
Get open database errors under heavy concurrent load
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-4639
Linux server may reject connections with a transliteration error
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-4634
ORDER BY via an index + WHERE clause: error "no current record for fetch operation"
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-4631
Lock manager "out of room" error hides the real cause of this problem
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-4624
Firebird handles ':' characters in mount table entries invalid
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-4623
PSQL "Domain" and "Type Of" based variables referring BLOB with sub_type < 0 no longer work
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-4622
Trigger with UPDATE OR INSERT statement and IIF() not working as expected
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-4618
Rollback doesn`t undo changes when MERGE statement updates the same target rows multiple times and PLAN MERGE is used
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-4604
EXECUTE STATEMENT raises CHAR_LENGTH() size for VARCHARs
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-4599
REPLACE function works incorrectly with multibyte charsets
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-4583
FB 3 embedded tries to load ICU DLLs from PATH folders
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-4582
Within linger period some database properties cannot be changed
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-4581
FB3 embedded server loads UDFs from wrong place
Contributor(s):
Vlad Khorsun <hvlad at users.sf.net>
* Bugfix CORE-4578
INPUT file not properly closed
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-4572
Incorrect error for PSQL function when the number of actual arguments does not match the number of formal arguments
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-4571
Can't select from table with ICU columns when database is created on Linux with ICU 4.2.1 and then copied to Windows
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-4561
BUGCHECK(183) when use cursor with "order by ID+0" and "for update with lock"
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-4539
Server does not accept the right plan
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-4507
Unable delete procedure source on Firebird 3.0 Alpha 2.0
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-4503
ISQL command SHOW USERS display only the current user
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-4472
Message "Modifying function <F> which is currently in use" when <F> is called from internal function declared in other unit
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-4471
Legacy_Auth plugin does not connect from FB3 to FB2.5 server when tried after Win_Sspi
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-4384
Problems when a table grows beyond 65535 pointer pages
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-4383
Index and BLOBs garbage collection doesn't work for in-place updates
Contributor(s):
Dimitry Sibiryakov <sd at ibphoenix.com>
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-4382
User savepoints are not released on commit
Contributor(s):
Dimitry Sibiryakov <sd at ibphoenix.com>
* Bugfix CORE-4369
BUGCHECK(177) for MERGE with multiple matches
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-4280
Stored PSQL functions accept duplicate input arguments
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-4259
Don't call setlocale(LC_CTYPE, "") in ISQL for Windows
Contributor(s):
Frank Schlottmann-Goedde <frank at schlottmann-goedde.de>
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-4161
Cannot insert records into table with column "GENERATED BY DEFAULT AS IDENTITY" in its DDL
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-4075
Server bugchecks or crashes on exception in calculated index
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-3632
Crash after calling fork() in a process using libfbembed.so
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-3373
It is possible to store string with lenght 31 chars into column VARCHAR(25)
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-2932
Wrong field position after ALTER POSITION
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-2848
Page-level "lock conversion denied" or "lock denied" errors
Contributor(s):
Vlad Khorsun <hvlad at users.sf.net>
* Bugfix CORE-214
COUNT (DISTINCT ...) is too slow
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Improvement CORE-4811
Make user names behave according to SQL identifiers rules
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Improvement CORE-4791
Make INSERTING/UPDATING/DELETING reserved words to fix ambiguity with boolean expresions
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Improvement CORE-4735
Expression 'where bool_field IS true | false' should also use index as 'where bool_field = true | false' (if such index exists)
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Improvement CORE-4731
Prohibit an ability to issue DML or DDL statements on RDB$ tables
Contributor(s):
Claudio Valderrama C. <cvalde at usa.net>
Alex Peshkov <peshkoff at mail.ru>
* Improvement CORE-4729
Add a flag to mon$database helping to decide what type of security database is used - default, self or other
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Improvement CORE-4696
Avoid flushing dirty pages to disk after creation of temporary table index
Contributor(s):
Vlad Khorsun <hvlad at users.sf.net>
* Improvement CORE-4685
Accessing DB in invalid manner when links (hard or symbolic) are used for it
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Improvement CORE-4671
Release internal temporary blobs early to free some memory\disk space
Contributor(s):
Vlad Khorsun <hvlad at users.sf.net>
* Improvement CORE-4610
Report a tag name in diagnostics when transliteration errors in Parameter Block values occur
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Improvement CORE-4607
Add support for having multiple UserManager's in firebird.conf and use them from SQL
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Improvement CORE-4605
Rename CryptPlugin configuration parameter to WireCryptPlugin
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Improvement CORE-4590
Change resulting data type of CHAR_LENGTH/BIT_LENGTH/OCTET_LENGTH of BLOBs to BIGINT
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Improvement CORE-4386
Report more details for "object in use" errors
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Improvement CORE-3526
Support for WHEN SQLSTATE error handlers in PSQL
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Improvement CORE-3234
Support for text BLOBs >= 32K as first argument for TRIM()
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Improvement CORE-3226
IPv6 support
Contributor(s):
Michal Kubeček <mike at mk-sys.cz>
* Improvement CORE-733
Compress data over the network
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* New feature CORE-4722
Aggregate linear regression functions
See also:
/doc/sql.extensions/README.regr_functions.txt
Contributor(s):
Hajime Nakagami <nakagami at gmail.com>
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* New feature CORE-4717
Aggregate statistical functions COVAR_SAMP, COVAR_POP and CORR
See also:
/doc/sql.extensions/README.statistical_functions.txt
Contributor(s):
Hajime Nakagami <nakagami at gmail.com>
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* New feature CORE-4714
Aggregate statistical functions STDDEV_POP, STDDEV_SAMP, VAR_POP and VAR_SAMP
See also:
/doc/sql.extensions/README.statistical_functions.txt
Contributor(s):
Hajime Nakagami <nakagami at gmail.com>
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* New feature CORE-4707
Ability to validate tables and indices online (without exclusive access to the database)
Contributor(s):
Vlad Khorsun <hvlad at users.sf.net>
* New feature CORE-4526
Support SQL-2008 compliant OFFSET/FETCH clauses instead of FIRST/SKIP or ROWS/TO clauses
Contributor(s):
Mark Rotteveel <mark at lawinegevaar.nl>
* New feature CORE-4438
Add support for UPDATE OR INSERT statement to Embedded SQL
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* New feature CORE-4437
Add support for the RETURNING clause to Embedded SQL
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* New feature CORE-803
Server bi-directional (aka scrollable) cursors
See also:
/doc/sql.extensions/README.scrollable_cursors.txt
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
*************
* v3.0 Beta 1
*************
* Bugfix CORE-4576
Cache writer thread could not start
Contributor(s):
Vlad Khorsun <hvlad at users.sf.net>
* Bugfix CORE-4575
Server crashes in the garbage collector thread at disconnect of last attachment
Contributor(s):
Vlad Khorsun <hvlad at users.sf.net>
* Bugfix CORE-4574
Regression: Incorrect result in subquery with aggregate
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-4570
Wrong error at ALTER PACKAGE
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-4568
Server may crash while disconnecting from the database under load
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-4566
Incorrect size of the output parameter/argument when execute block, procedure or function use system field in metadata charset
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-4565
GDSCODE can have value = 0 in WHEN-section under some concurrent env., only in SC or CS (not in SS)
Contributor(s):
Vlad Khorsun <hvlad at users.sf.net>
* Bugfix CORE-4555
DDL trigger remains active after dropped
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-4530
DB_KEY based join of two tables may be ineffective
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-4522
DDL permission do not protect against removal BLOB filters
Contributor(s):
Roman Simakov <roman.simakov at red-soft.biz>
* Bugfix CORE-4515
Regression: trace reports UPDATES in statistics when doing INSERT into <some_table>
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-4510
Database validation bug can cause server to crash
Contributor(s):
Vlad Khorsun <hvlad at users.sf.net>
* Bugfix CORE-4506
Server crashes when execute most of "show ..." commands after reconnect
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-4505
Use of named cursor fails if statement was not executed
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-4500
Firebird crashes after unsuccessful remapping of the lock table's shared memory
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-4498
Server crashes when getting an explained plan for a DBKEY based retrieval
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-4489
Error: statement already has a cursor <cursor_name> assigned
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-4488
Wrong results of FOR SELECT <L> FROM <T> AS CURSOR <C> and table <T> is modified inside cursor's begin...end block
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-4480
ISQL issues warning: "Bad debug info format" when connect to database with stored function after it's restoring
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-4478
Failure to load provider/plugin is reported nowhere
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-4477
Field RDB$MAP_TO_TYPE is not present in RDB$TYPES
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-4470
GBAK fails to restore database containing dependency between views and packaged functions
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-4468
CREATE USER GRANT ADMIN ROLE does not work
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-4464
Duplicate tags for CREATE/ALTER USER are not handled correctly
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-4461
NBACKUP prints error messages to stdout instead of stderr
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-4453
Regression: NOT NULL constraint, declared in domain, does not work
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-4447
Positioned UPDATE statement prohibits index usage for the subsequent cursor field references
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-4444
Engine could hung and block all attachments in out of disk space condition during physical backup
Contributor(s):
Vlad Khorsun <hvlad at users.sf.net>
* Bugfix CORE-4440
ISQL crashes without connect when execute command "show version"
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-4435
After calling release() for attachment to database (instead detach) in embedded mode attachment remains active forever
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-4433
GlobalRWLock could not downgrade EX lock to SH if readers are present
Contributor(s):
Vlad Khorsun <hvlad at users.sf.net>
* Bugfix CORE-4430
Properties of user created in Legacy_UserManager padded with space up to 10 character
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-4425
User-collations based on UNICODE are not upgrade to newer ICU version on restore
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-4422
Server crashes when using ROW_NUMBER()over( PARTITION BY x) in ORDER by clause
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-4419
Server crashes while sorting records longer than 128KB
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-4417
GBAK: cannot commit index; primary key with german umlaut
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-4415
Useless extraction of generic DDL trigger
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-4396
Incorrect query result if it is executed via EXECUTE STATEMENT
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-4395
EXECUTE STATEMENT ON EXTERNAL doesn't find Firebird 2.5 database
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-4394
Cursor not found error when using legacy API
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-4388
SELECT WITH LOCK may enter an infinite loop for a single record
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-4381
Incorrect line/column information in runtime errors
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-4380
ISQL truncates blob when reading an empty segment
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-4379
Poor performance of explicit cursors containing correlated subqueries in the select list
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-4376
Preparation of erroneous DDL statement does not show the main command failed
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-4375
Procedure executes infinitely if contains more than 32767 statements inside any BEGIN/END block
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-4374
Truncation error when using EXECUTE STATEMENT with a blob
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-4373
Duplicate names in package are not checked
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-4372
Deadlock is possible when two data pages contains record fragments pointing to each other
Contributor(s):
Vlad Khorsun <hvlad at users.sf.net>
* Bugfix CORE-4371
Create function/sp which references to non-existent exception: error message is "Error while parsing function's BLR"
instead of "exception not defined"
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-4366
Wrong result of WHERE predicate when it contains NULL IS NOT DISTINCT FROM (select min(NULL) from ...)
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-4365
Equality predicate distribution does not work for some complex queries
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-4360
SELECT from derived table which contains GROUP BY on field with literal value returns wrong result
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-4354
Parsing of recursive query returns error "Column does not belong to referenced table" for source having such a column
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-4353
Sorting records are larger than really necessary
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-4346
v3 GBAK cannot restore backups on pre-v3 server versions
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-4344
Error "no current record for fetch operation" when table inner join procedure inner join table
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-4334
Resources (e.g. sort files) owned by trigger may not be released when it's interrupted asynchronously
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-4331
LAG, LEAD and NTH_VALUE raise error when the second argument is NULL
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-4330
Incorrect result for function LAG if OFFSET value is assigned from a table
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-4327
Error in QLI when copying NULL blobs between databases
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-4326
Keyword SET should not be required in ALTER USER statement
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-4322
Engine crashes when use aggregate or window functions in recursive query
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-4321
Regression: ISQL does not destroy the SQL statement
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-4320
Regression: ISQL crashes when receiving statistics of execution of sql query
Contributor(s):
Vlad Khorsun <hvlad at users.sf.net>
* Bugfix CORE-4319
Engine crashes when trace config contains line "connection_id=NN" and we attempt to connect to non-existent database/alias
Contributor(s):
Vlad Khorsun <hvlad at users.sf.net>
* Bugfix CORE-4318
Regression: Predicates involving PSQL variables/parameters are not pushed inside the aggregation
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-4313
Error "Attempt to reopen an open cursor" may be raised if the query handle is reused in a different transaction
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-4309
'Cache Writer' record in MON$ATTACHMENTS dissapear when delete other connection that running some 'heavy update' on big table
via delete from MON$ATTACHMENTS
Contributor(s):
Vlad Khorsun <hvlad at users.sf.net>
* Bugfix CORE-4307
Fields present only in WHERE clause of views WITH CHECK OPTION causes invalid CHECK CONSTRAINT violation
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-4304
Engine crashes when attempt to REcreate table with FK after syntax error before such recreating
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-4303
Possible races while service destruction
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-4301
Non-ASCII data in SEC$USERS is not read correctly
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-4286
"Statement already has a cursor assigned" error when trying to execute another SQL statement using different cursor name
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-4275
CREATE DATABASE fault if fbclient.dll loaded from another directory (Providers = Engine12)
Contributor(s):
Vlad Khorsun <hvlad at users.sf.net>
* Bugfix CORE-4118
Expression index may be not used for derived fields or view fields
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-3305
"BLOB not found" error after creation/altering of the invalid trigger
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-2350
Too long column name for select alias should be rejected
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-2350
Too long column name for select alias should be rejected
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-1475
Database which has active attachments can not be replaced from backup file even after database shut down
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Improvement CORE-4573
Avoid need in fake -pas switch when using GSEC in embedded mode
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Improvement CORE-4564
Add per-table performance counters to the monitoring tables
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Improvement CORE-4562
Split all validation messages to critical and minor ones
Contributor(s):
Vlad Khorsun <hvlad at users.sf.net>
* Improvement CORE-4556
Allocate data pages in group of sequential ordered pages (extents)
Contributor(s):
Vlad Khorsun <hvlad at users.sf.net>
* Improvement CORE-4528
Allow hash/merge joins for non-field (dbkey or derived expression) equalities
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Improvement CORE-4487
Maintain package body after ALTER/RECREATE PACKAGE
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Improvement CORE-4484
Description (COMMENT ON) for package procedures and functions, and its parameters
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Improvement CORE-4469
Add field in SEC$USERS reflecting whether a user has RDB$ADMIN role in security database
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Improvement CORE-4457
DATEADD should support fractional value for MILLISECOND
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Improvement CORE-4451
Allow trace output to show the explained plan
Contributor(s):
Vlad Khorsun <hvlad at users.sf.net>
* Improvement CORE-4445
Extend main database file faster when physical backup state changed from stalled to merge
Contributor(s):
Vlad Khorsun <hvlad at users.sf.net>
* Improvement CORE-4443
Use fast file grow on those Linux systems that support it
Contributor(s):
Vlad Khorsun <hvlad at users.sf.net>
* Improvement CORE-4439
Raise the 1024 connections limit (FD_SETSIZE) on Windows SS/SC
Contributor(s):
Paul Beach <pbeach at ibphoenix.com>
* Improvement CORE-4434
Extend the use of colon prefix for read/assignment OLD/NEW fields and assignment to variables
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Improvement CORE-4432
Let attachments to not block others when allocation table is read first time
Contributor(s):
Vlad Khorsun <hvlad at users.sf.net>
* Improvement CORE-4431
Reduce contention for allocation table lock while database is in stalled physical backup state
Contributor(s):
Vlad Khorsun <hvlad at users.sf.net>
* Improvement CORE-4403
Allow referencing cursors as record variables in PSQL
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
Dmitry Yemanov <dimitr at firebirdsql.org>
* Improvement CORE-4398
Provide ability to specify extra-long name of log when doing gbak to avoid "attempt to store 256 bytes in a clumplet" message
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Improvement CORE-4387
IStatement::execute() and IAttachment::execute() functions should return on error pointer to old transaction interface
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Improvement CORE-4345
Ability to trace stored functions execution
Contributor(s):
Vlad Khorsun <hvlad at users.sf.net>
* Improvement CORE-4310
DATEADD: change input <amount> argument from INT to BIGINT
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Improvement CORE-4252
Add table name to text of validation contraint error message, to help identify error context
Contributor(s):
Vlad Khorsun <hvlad at users.sf.net>
* Improvement CORE-3881
Extend the error reported for index/constraint violations to include the problematic key value
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Improvement CORE-3242
Recursive stored procedure should not require execute right to call itself
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Improvement CORE-2897
Don't send full length of field over the wire when field is null
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Improvement CORE-2530
Denser data stream and better prefetch logic in the network protocol
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Improvement CORE-2303
Include PLAN in mon$statements
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Improvement CORE-2224
Upgrade ICU to version 52.1
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Improvement CORE-2119
Use entries in restrict list of ExternalFileAccess parameter to mangle filenames with relative path
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Improvement CORE-1900
Windows authentication: grant privileges to Windows groups
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Improvement CORE-1482
Make optimizer to consider ORDER BY optimization when making decision about join order
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* New feature CORE-3368
Make it possible to specify non-default security database for specific database
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* New feature CORE-2208
New gbak option to ignore specific tables data during the backup
Contributor(s):
Dmitriy Starodubov <dmitry.starodubov at red-soft.biz>
Alex Peshkov <peshkoff at mail.ru>
* New feature CORE-1377
Add an ability to change role without reconnecting to database
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* New feature CORE-735
User rights for metadata changes
Contributor(s):
Roman Simakov <roman.simakov at red-soft.biz>
Dmitry Yemanov <dimitr at firebirdsql.org>
**************
* v3.0 Alpha 2
**************
* Bugfix CORE-4302
Descending index could be very inefficient for some keys
Contributor(s):
Vlad Khorsun <hvlad at users.sf.net>
* Bugfix CORE-4298
fbsvcmgr doesn't recognise sts_record_versions and other sts switches
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-4297
GFIX crashes when description of limbo transaction have size large than 1KB
Contributor(s):
Vlad Khorsun <hvlad at users.sf.net>
* Bugfix CORE-4293
Server crashes on SELECT with long/complex list of compound AND/OR'd predicates
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-4289
NOT NULL field from derived table becomes NULL when referred outside DT
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-4283
Resource temporarily unavailable errors while simultaneously registering events
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-4281
TYPE OF arguments of stored functions hang the server if depending domain or column is changed
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-4271
Engine crashs in case of recreation of an erratic package body
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-4270
Error in case of subquery with windowed function + where <field> IN(select ...)
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-4269
Wrong output when field with result of windowed function is used in query
with useless WHERE 0=0 and GROUP BY clause
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-4268
Server may crash while disconnecting from a database
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-4267
Server crashes while sweeping the database
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-4265
Unexpected lock conflict error may be raised while connecting to a heavily loaded database
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-4262
Context parsing error with derived tables and CASE functions
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-4261
Wrong result of join when joined fields are created via row_number() function
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-4259
setlocale(LC_CTYPE, "") in ISQL should not be called on Windows
Contributor(s):
Frank Schlottmann-Goedde <frank at schlottmann-goedde.de>
* Bugfix CORE-4258
Wrong boundary for minimum value for BIGINT/DECIMAL(18)
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-4255
Parametrized queries using RDB$DB_KEY do not work
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-4251
Guardian service could write garbage after the end of message in the Event Log
Contributor(s):
Vlad Khorsun <hvlad at users.sf.net>
* Bugfix CORE-4250
AV in guardian at process shutdown
Contributor(s):
Vlad Khorsun <hvlad at users.sf.net>
* Bugfix CORE-4247
Positioned DELETE (WHERE CURRENT OF <CURSOR>) fails for tables with newly added fields
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-4244
Problem with creation procedure which contain adding text in DOS864 charset
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-4241
Empty password will pass login
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-4240
Recursive query in SQL query returns incorrect results if more than one branch bypass
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-4237
FB3 vs FB2.5. Different metadata for UDF return argument
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-4236
Database shutdown is reported as successfully completed before all active connections are in fact interrupted
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-4235
Deadlock is possible while accessing the monitoring tables under concurrent load
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
Vlad Khorsun <hvlad at users.sf.net>
* Bugfix CORE-4234
Error with IF (subfunc()) when subfunc returns a boolean
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-4229
Bidirectional cursor is not positioned by the first call of FETCH LAST
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-4227
Wrong evaluation of BETWEEN and boolean expressions due to parser conflict
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-4225
Server crashes when attempting to trace activity on database having a db-level trigger
Contributor(s):
Vlad Khorsun <hvlad at users.sf.net>
* Bugfix CORE-4219
Regular expressions with double-slash fail in trace
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-4216
Memory leak with TRIGGER ON TRANSACTION COMMIT
Contributor(s):
Vlad Khorsun <hvlad at users.sf.net>
* Bugfix CORE-4214
GTT should not reference permanent relation
Contributor(s):
Vlad Khorsun <hvlad at users.sf.net>
* Bugfix CORE-4212
Dropping FK on GTT crashes server
Contributor(s):
Vlad Khorsun <hvlad at users.sf.net>
* Bugfix CORE-4211
Embedded engine hangs for 5 seconds when closing, errors about timeout in shutdown process
and invalid mutex are written into firebird.log
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-4205
ISQL -x does not output the START WITH clause of generators/sequences
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-4203
Cannot create packaged routines with [VAR]CHAR parameters
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-4202
Backup/Restore from old version to v3.0 fails with BLR error
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-4201
Computed field returns null value inside BEFORE INSERT trigger
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-4200
An uncommitted select of the pseudo table sec$users blocks new database connections
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-4198
Incorrect "token unknown" error when the SQL string ends with a hex number literal
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-4185
Server crashes with "invalid lock id (NNNNN)"
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-4184
Error is raised while executing empty EXECUTE BLOCK with NOT NULL output parameter
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-4180
CREATE COLLATION does not verify base collation charset
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-4178
New API should return proper metadata properties, not the historical artifacts
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-4177
Problem with some boolean expressions not being allowed
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-4176
Monitoring tables return incomplete information in SC/CS configurations
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-4173
Setting generator value twice in single transaction will set it to zero
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-4168
Backup containing procedures or triggers that select from external tables
cannot be restored with ExternalFileAccess=None
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-4164
Owner name is missing for generators/exceptions restored from a backup
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-4163
Configuration fbtrace.conf contains syntax errors
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-4162
Warnings are not returned from attachDatabase() call
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-4160
The parameterized exception does not accept not ASCII characters as parameter
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-4159
Incorrect memory statistics is reported
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-4158
LIKE with escape doesn't work
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-4156
RDB$GET_CONTEXT/RDB$SET_CONTEXT parameters incorrectly described as CHAR NOT NULL instead of VARCHAR NULLABLE
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-4155
External routines DDL in packages wrongly report error for termination with semi-colon
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-4153
Attempting to use Legacy_Auth directly after install doesn't work, restart of service is required
Contributor(s):
Paul Reeves <preeves at ibphoenix.com>
* Bugfix CORE-4149
New permission types are not displayed by ISQL
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-4145
Memory leak when preparing EEXECUTE BLOCK which uses domains
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-3989
Bad performance / slow response when many concurrent sorts are executed
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-3921
Bugcheck 186 (record disappeared) and 100% CPU load (when bugcheckabort=1 and sweep starts at gap ~21000)
Contributor(s):
Vlad Khorsun <hvlad at users.sf.net>
* Bugfix CORE-2648
NBACKUP's delta file ignored Forced Writes database setting
Contributor(s):
Vlad Khorsun <hvlad at users.sf.net>
* Bugfix CORE-2165
Unnecessary 1 index read may occur when using strict inequality condition
Contributor(s):
Vlad Khorsun <hvlad at users.sf.net>
* Bugfix CORE-362
Impossible to enter certain characters in ISQL
Contributor(s):
Frank Schlottmann-Goedde <frank at schlottmann-goedde.de>
* Improvement CORE-4290
Extensible property support which can add properties (name-value pairs)
to users (stored in the security database and managed in some way)
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Improvement CORE-4285
Choose the best matching index for navigation
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Improvement CORE-4273
Per-database control on access to database from remote stations
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Improvement CORE-4222
Provide ability to know which authentication method was used for user connection
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Improvement CORE-4218
Add database owner to MON$DATABASE
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Improvement CORE-4215
Execution of SET STATISTICS INDEX statement could block or slow execution of concurrent attachments
Contributor(s):
Vlad Khorsun <hvlad at users.sf.net>
* Improvement CORE-4206
Add RESTART [WITH] clause for alter identity columns
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Improvement CORE-4199
Add optional START WITH clause to identity columns
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Improvement CORE-4165
Replace the hierarchical union execution with the plain one
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Improvement CORE-4154
Firebird.conf should list names of (standard) authentication + usermanager plugins
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Improvement CORE-4148
Increase ISQL command buffer size from 64 KB to 10 MB to match the new engine limits
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Improvement CORE-4085
Add systemd init scripts
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Improvement CORE-3931
SQL commands to query/alter users description
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Improvement CORE-3365
Extend syntax for ALTER USER CURRENT_USER
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Improvement CORE-1846
Allow index walk (ORDER plan) when there's a composite index {A, B}
and the query looks like WHERE A = ? ORDER BY B
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* New feature CORE-4263
Database linger
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* New feature CORE-2063
CREATE OR ALTER USER command
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* New feature CORE-2004
ALTER USER XXX INACTIVE command
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
**************
* v3.0 Alpha 1
**************
* Bugfix CORE-4144
Error "context already in use (BLR error)" when preparing a query with UNION
Contributor(s):
Vlad Khorsun <hvlad at users.sf.net>
* Bugfix CORE-4137
Wrong metadata output script generate by ISQL / CHARACTER SETISO8859_1 syntax error
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-4136
Sharp-S character treated incorrectly in UNICODE_CI_AI collation
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-4135
Sweep blocks establishment of concurrent attachments in SuperServer
Contributor(s):
Vlad Khorsun <hvlad at users.sf.net>
* Bugfix CORE-4134
Race condition when auto-sweep is started
Contributor(s):
Vlad Khorsun <hvlad at users.sf.net>
* Bugfix CORE-4074
Computed by columns and POSITION function
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-4027
Creating table with computed fields containing "SELECT FIRST" produces corrupted result
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-4018
Using system domain in procedures arguments/returns cause the SP to be unchangeable
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-4005
Wrong error message with recursive CTE
Contributor(s):
Vlad Khorsun <hvlad at users.sf.net>
* Bugfix CORE-3973
Original table name and column name and owner missing from SQLDA for aliased column in grouped query
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-3947
Wrong results when the column with collation using option (NUMERIC-SORT=1) is in WHERE clause
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-3941
Memory alignment problem with unique expression index
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-3929
Invalid error "attempted update of read-only column" when selecting MINVALUE from list with more than 255 elements
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-3894
Wrong numbers in error message for decreasing char/varchar columns
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-3874
Computed column appears in non-existant rows of left join
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-3820
RDB$TYPES contains duplicate character sets
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-3754
SIMILAR TO works wrongly
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-3737
EXECUTE BLOCK parameters definitions are not respected and may cause wrong behavior related to character sets
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-3735
Unprivileged user can delete from RDB$DATABASE, RDB$COLLATIONS, RDB$CHARACTER_SETS
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-3718
Client library hangs after unsuccessful connection to remote auxiliary (events) port
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-3694
Internal consistency check in query with grouping by subquery+stored procedure+aggregate
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-3672
Computed index by SUBSTRING function for long columns
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-3638
Introduce FR_CA_CI_AI collation and change FR_FR and FR_FR_CI_AI to be identical to FR_CA and FR_CA_CI_AI respectively
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-3575
Support of backup volumes with size more than 4GB
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-3545
Inconsistent domain's constraint validation in PSQL
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-3476
LIST function wrongly concatenates binary blobs
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-3475
Parameters inside the CAST function are described as not nullable
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-3431
ISQL pads UTF-8 data incorrectly
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-3416
Inserting Kase into a CHARACTER SET ASCII column succeeds
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-3401
Collation errors with [type of] <domain>, type of column
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-3338
Regression: code changes disabled support for expression indexes with COALESCE, CASE and DECODE
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-3317
Success of deleting rows depending on order of row insertion
Contributor(s):
Vlad Khorsun <hvlad at users.sf.net>
* Bugfix CORE-3310
RDB$GET_CONTEXT and BETWEEN in views
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-3269
When server gets unavailbale, client does not perform detach correctly
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-3260
Interlock.h not portable
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-3250
Cannot start firebird server under any username other than "root", "firebird" , "interbas"or "interbase"
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Bugfix CORE-3239
UTF8 UNICODE_CI collate can not be used in compound index
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-3204
Constraint violation error of CAST is not raised inside views
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-3201
ATAN2 returns incorrect value for (0, 0)
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-3174
Expression index with TRIM may lead to incorrect indexed lookup
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-3114
Attempt to drop non-existing generator produces bad error
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-3056
Problems may happen when issuing DDL commands in the same transaction after CREATE COLLATION was issued
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-3055
Variable/argument name could be absent or be wrong in error messages when more than 256 variables are used
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-3052
Wrong resultset for comparisons involving multiple index segments
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-3047
Wrong logic is used to resolve EXECUTE BLOCK parameters collations
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-2988
Concurrent transaction number not reported if lock timeout occurs
Contributor(s):
Nickolay Samofatov <skidder at users.sf.net>
* Bugfix CORE-2957
COUNT(*) from a big table returns negative result
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-2952
Case-sensitive character class names in SIMILAR TO
Contributor(s):
Dimitry Sibiryakov <sd at ibphoenix.com>
* Bugfix CORE-2922
Character set used in constants is not registered as a dependency
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-2913
COLLATE expressions are applied incorrectly
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-2798
Incomplete plan output (lack of view names) when selecting from views containing procedures inside
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-2796
DB_KEY is always zero for external tables
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-2788
ISQL extracts the array dimensions after the character set name
Contributor(s):
Claudio Valderrama C. <cvalde at usa.net>
* Bugfix CORE-2784
Guardian creates more and more threads each time FBServer dies
Contributor(s):
Claudio Valderrama C. <cvalde at usa.net>
* Bugfix CORE-2740
GBAK restores invalid views without any warning to the user
Contributor(s):
Claudio Valderrama C. <cvalde at usa.net>
* Bugfix CORE-2699
Common table expression context could be used with parameters
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-2696
ALTER TABLE command can add a field which has NOT NULL definition
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-2678
Full outer join cannot use available indices (very slow execution)
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-2606
Multibyte CHAR value requested as VARCHAR is returned with padded spaces
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-2547
Utilities need to honor their minimum number of characters to recognize an option
Contributor(s):
Claudio Valderrama C. <cvalde at usa.net>
* Bugfix CORE-2545
Lack of several validations in GBAK
Contributor(s):
Claudio Valderrama C. <cvalde at usa.net>
* Bugfix CORE-2543
NBACKUP may hide the real cause of failure
Contributor(s):
Claudio Valderrama C. <cvalde at usa.net>
* Bugfix CORE-2508
Tricky index names can defeat the parsing logic when generating a human readable plan
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-2484
Success message when connecting to tiny trash database file
Contributor(s):
Claudio Valderrama C. <cvalde at usa.net>
* Bugfix CORE-2431
String values in error messages are not converted to connection charset
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-2238
UTF8 and large varchar fields, IS DISTINCT FROM causes error "Implementation limit exceeded"
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-2204
Constraints on SP output parameters are checked even when the SP returns zero rows
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-2155
Join of SP with view or table may fail with error "No current record for fetch operation"
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-1748
Unrestorable backup
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-1712
Buffer overflow in conversion
Contributor(s):
Claudio Valderrama C. <cvalde at usa.net>
* Bugfix CORE-1620
Incorrect error message (column number) if the empty SQL string is prepared
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-1605
Bugcheck 232 (invalid operation) for an aggregated query
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-1595
Tray icon of Firebird Guardian disappears after Windows Explorer crash
Contributor(s):
Claudio Valderrama C. <cvalde at usa.net>
* Bugfix CORE-1550
Unnecessary index scan happens when the same index is mapped to both WHERE and ORDER BY clauses
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-1518
Adding a non-null restricted column to a populated table renders the table inconsistent
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-1355
Zero is displayed instead of NULL
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-1188
STARTING WITH :param (empty string) doesn't work if using index with many fields
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Bugfix CORE-634
Bad treatment of FIRST/SKIP in sub-selects
Contributor(s):
Vlad Khorsun <hvlad at users.sf.net>
* Bugfix CORE-304
Metadata security hole - any user can alter/drop generators and exceptions
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Bugfix CORE-92
Infinite insertion cycle
Contributor(s):
Vlad Khorsun <hvlad at users.sf.net>
* Improvement CORE-3972
Allow selection of SQL_INT64, SQL_DATE and SQL_TIME in dialect 1
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Improvement CORE-3919
Improve SIMILAR TO performance
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Improvement CORE-3879
Make FB_LOCK_PRINT a bit more handy
Contributor(s):
Vlad Khorsun <hvlad at users.sf.net>
* Improvement CORE-3788
Make all utilities follow same rules when expanding database name
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Improvement CORE-3779
Report OS user name in MON$ATTACHMENTS
See also:
/doc/README.monitoring_tables
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Improvement CORE-3704
Add new context variables to the SYSTEM namespace
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Improvement CORE-3639
Allow the use of multiple WHEN MATCHED / NOT MATCHED clauses in MERGE, as per the SQL 2008 specification
See also:
/doc/README.merge.txt
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Improvement CORE-3594
Include expected and actual string lenght into error message for sqlcode -802
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Improvement CORE-3588
More details in the error message "wrong page type"
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Improvement CORE-3546
Aliases for the RETURNING clause
See also:
/doc/sql.extensions/README.returning
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Improvement CORE-3343
Support for the RETURNING clause in positioned (WHERE CURRENT OF) UPDATE and DELETE statements
See also:
/doc/sql.extensions/README.returning
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Improvement CORE-3251
Use SSL/TLS support for both encryption and user authentication
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Improvement CORE-3085
Add clause ALTER DOMAIN <name> {DROP | SET} NOT NULL
See also:
/doc/sql.extensions/README.ddl.txt
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Improvement CORE-3076
Better performance for (table.field = :param or :param = -1) in the WHERE clause
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Improvement CORE-3057
Allow the usage of blobs in COMPUTED BY expressions
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Improvement CORE-3020
Add RETURNING ... INTO ... clause to the MERGE statement
See also:
/doc/sql.extensions/README.returning, /doc/README.merge.txt
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Improvement CORE-2868
Increase trigger and stored procedure body size above 32KB
Note(s):
Available via the new API only
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Improvement CORE-2812
Prohibit any improper mixture of explicit and implicit joins
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Improvement CORE-2787
Make RDB$SYSTEM_FLAG not null
Contributor(s):
Claudio Valderrama C. <cvalde at usa.net>
* Improvement CORE-2780
Include client library version and protocol version into MON$ATTACHMENTS
See also:
/doc/README.monitoring_tables
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Improvement CORE-2724
Validate or transform string of DML queries so that engine internals don't receive malformed strings
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Improvement CORE-2712
Do not print "invalid request BLR" for par.cpp errors with valid BLR
Contributor(s):
Claudio Valderrama C. <cvalde at usa.net>
* Improvement CORE-2697
Support the "? in (SELECT some_col FROM some_table)" subqueries
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Improvement CORE-2575
Make ISQL "input" command open relative filenames based on the directory
of last opened (and not closed) input file
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Improvement CORE-2565
Many hardcoded messages in Trace Manager
Contributor(s):
Claudio Valderrama C. <cvalde at usa.net>
* Improvement CORE-2554
Grant execute permissions for UDFs
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Improvement CORE-2553
Grants access on generators (gen_id, next value for)
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Improvement CORE-2542
QLI and NBACKUP accept arbitrary input after the first letter of an option
Contributor(s):
Claudio Valderrama C. <cvalde at usa.net>
* Improvement CORE-2541
Too many hardcoded messages in NBACKUP
Contributor(s):
Claudio Valderrama C. <cvalde at usa.net>
* Improvement CORE-2540
Utilities need a more coherent way to show help and version
Contributor(s):
Claudio Valderrama C. <cvalde at usa.net>
* Improvement CORE-2187
Return the client host name in MON$ATTACHMENTS
See also:
/doc/README.monitoring_tables
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Improvement CORE-2006
SUBSTRING with regular expression (SIMILAR TO) capability
See also:
/doc/README.substring_similar.txt
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Improvement CORE-2005
Support SQL 2008 syntax for MERGE statement with DELETE extension
See also:
/doc/README.merge.txt
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Improvement CORE-1906
Allow interactive arguments (seconds and intervals) of fb_lock_print to be 32-bit integers
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Improvement CORE-1898
Increased the password length from 8 characters, removed support
for LegacyHash and Authentication parameters in firebird.conf.
Support of pre-2.0 hashes is dropped, authentication is overridden
by AuthServer parameter.
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* Improvement CORE-1609
Remove limit of PSQL output parameter size
Note(s):
Available via the new API only
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Improvement CORE-1180
DDL syntax to change (not) nullable state of columns
See also:
/doc/sql.extensions/README.ddl.txt
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Improvement CORE-1117
Remove or extend limit of command text length (64K)
Note(s):
Available via the new API only
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Improvement CORE-832
Add support for parameterized exceptions
See also:
/doc/sql.extensions/README.exception_handling
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* Improvement CORE-800
Easy metadata extract improvements
Contributor(s):
Claudio Valderrama C. <cvalde at usa.net>
* Improvement CORE-675
Add entries to RDB$Types
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* Improvement CORE-672
"Over the wire" connection encryption
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* New feature CORE-4089
Runtime architecture configuration
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
Vlad Khorsun <hvlad at users.sf.net>
* New feature CORE-3626
Subfunctions in PSQL and EXECUTE BLOCK
See also:
/doc/sql.extensions/README.subroutines.txt
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* New feature CORE-3621
Window functions: NTH_VALUE
See also:
/doc/sql.extensions/README.window_functions.txt
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* New feature CORE-3620
Window functions: LAST_VALUE
See also:
/doc/sql.extensions/README.window_functions.txt
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* New feature CORE-3619
Window functions: FIRST_VALUE
See also:
/doc/sql.extensions/README.window_functions.txt
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* New feature CORE-3364
Blob filter to translate internal debug info into text representation
Contributor(s):
Vlad Khorsun <hvlad at users.sf.net>
* New feature CORE-3332
Provide more detailed information about the query execution plan
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* New feature CORE-3291
New pseudocolumn (RDB$RECORD_VERSION) to get number of the transaction
that created a record version
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* New feature CORE-3018
RECREATE and CREATE OR ALTER SEQUENCE/GENERATOR statements
See also:
/doc/sql.extensions/README.ddl.txt
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
Dmitry Yemanov <dimitr at firebirdsql.org>
* New feature CORE-2884
New object rights for enhanced security
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* New feature CORE-2869
Window functions: LAG and LEAD
See also:
/doc/sql.extensions/README.window_functions.txt
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* New feature CORE-2830
Window functions: DENSE_RANK, RANK and ROW_NUMBER
See also:
/doc/sql.extensions/README.window_functions.txt
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* New feature CORE-2823
Window functions: ORDER BY clause
See also:
/doc/sql.extensions/README.window_functions.txt
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* New feature CORE-2777
Make possible to alter the default database character set without manual update of system table
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* New feature CORE-2744
Inverse hyperbolic trigonometric functions as native functions
See also:
/doc/sql.extensions/README.builtin_functions.txt
Contributor(s):
Claudio Valderrama C. <cvalde at usa.net>
* New feature CORE-2700
C++ API supporting functions, triggers and stored procedures
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* New feature CORE-2639
Pseudo-table with list of users, available for management to current user
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* New feature CORE-2470
Support for alternate format of strings literals
See also:
/doc/sql.extensions/README.alternate_string_quoting.txt
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* New feature CORE-2312
PSQL packages
See also:
/doc/sql.extensions/README.packages.txt
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* New feature CORE-2310
DDL triggers
See also:
/doc/sql.extensions/README.ddl_triggers.txt
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* New feature CORE-2133
Window functions: PARTITION BY clause
See also:
/doc/sql.extensions/README.window_functions.txt
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* New feature CORE-2090
Window functions: Support OVER () clause with current aggregate functions
See also:
/doc/sql.extensions/README.window_functions.txt
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* New feature CORE-2047
User-defined PSQL functions
Contributor(s):
Dmitry Yemanov <dimitr at firebirdsql.org>
* New feature CORE-1952
Deprecate implementation IDs in ODS, thus simplifying new ports
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* New feature CORE-1385
Identity columns
See also:
/doc/sql.extensions/README.identity_columns.txt
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* New feature CORE-1288
Subprocedures in PSQL and EXECUTE BLOCK
See also:
/doc/sql.extensions/README.subroutines.txt
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* New feature CORE-1209
CONTINUE statement
See also:
/doc/sql.extensions/README.ddl.txt
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* New feature CORE-816
Stored procedures, triggers and functions in Java
See also:
/doc/README.external_routines.txt
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* New feature CORE-775
True SMP support for SuperServer
Contributor(s):
Vlad Khorsun <hvlad at users.sf.net>
* New feature CORE-726
Boolean data type
See also:
/doc/README.data_types
Contributor(s):
Adriano dos Santos Fernandes <adrianosf at gmail.com>
* New feature CORE-685
Location of user lists (DB permission)
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* New feature CORE-657
Database encryption
Contributor(s):
Alex Peshkov <peshkoff at mail.ru>
* New feature CORE-462
New option in addition to -V switch to specify a custom verbose interval
Contributor(s):
Claudio Valderrama C. <cvalde at usa.net>
View Git Blame Copy Permalink