FirebirdSQL logo

Firebird 5.0.1 Release: Bug Fixes

Core Engine

#8189 — Slow connection times with a lot of simultaneous connections and active trace session present

Implemented by Alexander Peshkov, Vlad Khorsun


#8186 — Fixed a few issues with IPC used by remote profiler

Implemented by Vlad Khorsun


#8180 — Sometimes a trace session is terminated spontaneously

Implemented by Artyom Abakumov


#8178 — Fix boolean conversion to string inside DataTypeUtil::makeFromList()

Implemented by Dmitry Yemanov


#8171 — Trace plugin unloaded if called method is not implemented

Implemented by Vlad Khorsun


#8168 — MAKE_DBKEY bug after backup/restore

Implemented by Vlad Khorsun


#8156 — Can not specify concrete IPv6 address in ES/EDS connection string

Implemented by Vlad Khorsun


#8150 — Process could attach to the deleted instance of shared memory

Implemented by Alexander Peshkov, Vlad Khorsun


#8138 — Bugcheck when replicator state is changed concurrently

Implemented by Vlad Khorsun


#8123 — Procedure manipulation can lead to wrong dependencies removal

Implemented by Adriano dos Santos Fernandes


#8120 — CAST dies with numeric value is out of range error

Implemented by Vlad Khorsun


#8115 — FB 5.0.0.1306 - unexpected results using LEFT JOIN with WHEN

Implemented by Dmitry Yemanov


#8112 — Error isc_read_only_trans (335544361) should report SQLSTATE 25006

Implemented by Adriano dos Santos Fernandes


#8108 — ICU 63.1 suppresses conversion errors

Implemented by Dmitry Kovalenko


#8100 — The isc_array_lookup_bounds function returns invalid values for low and high array bounds

Implemented by Adriano dos Santos Fernandes


#8094 — Index creation error when restoring with parallels workers

Implemented by Vlad Khorsun


#8086 — IN predicate with string-type elements is evaluated wrongly against a numeric field

Implemented by Dmitry Yemanov


#8085 — Memory leak when executing a lot of different queries and StatementTimeout > 0

Implemented by Vlad Khorsun


#8084 — Partial index uniqueness violation

Implemented by Vlad Khorsun


#8078 — SIMILAR TO with constant pattern using ‘|’, ‘*’, ‘?’ or ‘{0,N}’ doesn’t work as expected

Implemented by Adriano dos Santos Fernandes


#8077 — Error "Too many recursion levels" does not stop execution of code that uses ON DISCONNECT trigger (FB 4.x+)

Implemented by Alexander Peshkov, Vlad Khorsun


#8063 — (var)char variables/parameters assignments fail in stored procedures with subroutines

Implemented by Adriano dos Santos Fernandes


#8058 — Replicated DDL changes do not set the correct grantor

Implemented by Dmitry Yemanov


#8056 — Error "Too many temporary blobs" with BLOB_APPEND when selecting a stored procedure with rows-clause

Implemented by Vlad Khorsun


#8040 — Bugcheck 183 (wrong record length) could happen on replica database after UK violation on insert

Implemented by Vlad Khorsun


#8033 — Invalid result when string compared with indexed NUMERIC(x,y) field where x > 18 and y != 0

Implemented by Alexander Peshkov


#8027 — Broken gbak statistics

Implemented by Alexander Peshkov


#8011 — DECFLOAT error working with INT128 in UDR

Implemented by Alexander Peshkov


#8006 — INT128 datatype not supported in FB_MESSAGE macro

Implemented by Alexander Peshkov


#7997 — Unexpected results when comparing integer with string containing value out of range of that integer datatype

Implemented by Alexander Peshkov


#7995 — Unexpected results after creating partial index

Implemented by Dmitry Yemanov


#7993 — Unexpected results when using CASE WHEN with RIGHT JOIN

Implemented by Dmitry Yemanov


#7976 — False validation error for short unpacked records

Implemented by Dmitry Yemanov


#7969 — Characters are garbled when replicating fields with type BLOB SUB_TYPE TEXT if the character set of the connection and the field are different

Implemented by Dmitry Yemanov


#7942 — Database file appears corrupted after restore from backup

Implemented by Vlad Khorsun


#7937 — Inner join raises error "no current record for fetch operation" if a stored procedure depends on some table via input parameter and also has an indexed relationship with another table

Implemented by Dmitry Yemanov


#7927 — Some default values are set incorrectly for SC/CS architectures

Implemented by Vlad Khorsun


#7921 — Firebird 5 uses PK for ordered plan even if matching index with fewer fields exists

Implemented by Dmitry Yemanov


#7899 — Inconsistent state of master-detail occurs after reconnect + 'SET AUTODDL OFF' + 'drop <FK>' which is rolled back

Implemented by Vlad Khorsun


#7896 — replication.log remains empty (and without any error in firebird.log) until concurrent FB instance is running under different account and generates segments on its master. Significant delay required after stopping concurrent FB to allow first one to write in its replication log.

Implemented by Vlad Khorsun


#7873 — Wrong memory buffer alignment and I/O buffer size when working in direct I/O mode

Implemented by Vlad Khorsun


#7863 — Non-correlated sub-query is evaluated multiple times if it is based on a view rather than on an equivalent derived table

Implemented by Dmitry Yemanov


Server Crashes/Hangups

#8185 — SIGSEGV in Firebird 5.0.0.1306 embedded during update on cursor

Implemented by Adriano dos Santos Fernandes, Dmitry Yemanov


#8176 — Firebird 5 hangs after starting remote profiling session

Implemented by Vlad Khorsun


#8151 — Deadlock happens when running 'List Trace Sessions' service and there are many active trace sessions

Implemented by Vlad Khorsun


#8149 — A hang or crash could happen when connection fires TRACE_EVENT_DETACH event and a new trace session is created concurrently

Implemented by Vlad Khorsun


#8136 — Server crashes with IN (dbkey1, dbkey2, …​) condition

Implemented by Dmitry Yemanov


#8114 — Segfault in connection pool during server shutdown

Implemented by Vlad Khorsun


#8110 — Firebird 5 crash on Android API level 34

Implemented by Vlad Khorsun


#8101 — Firebird crashes if a plugin factory returns nullptr and no error in the status

Implemented by Vlad Khorsun, Dimitry Sibiryakov


#8089 — AV when attaching database while low on free memory

Implemented by Vlad Khorsun


#8087 — AV when preparing a query with IN <list> that contains both literals and sub-query

Implemented by Vlad Khorsun


#8083 — AV when writing to internal trace log

Implemented by Vlad Khorsun


#8079 — Engine could crash when executing some trigger(s) while another attachment modifies them

Implemented by Vlad Khorsun


#8039 — Segfault when opening damaged (last TIP is missing in RDB$PAGES, user’s FW was OFF) database

Implemented by Alexander Peshkov


#8026 — Crash LI-V5.0.0.1306 in libEngine13.so

Implemented by Alexander Peshkov


#7998 — Сrash during partial index checking if the condition raises a conversion error

Implemented by Dmitry Yemanov


#7985 — Hang in case of error when sweep thread is attaching to database (Classic Server)

Implemented by Alexander Peshkov


#7979 — Hang when database with disconnect trigger using MON$ tables is shutting down

Implemented by Alexander Peshkov