Firebird 5.0 Release Candidate 1: Bug Fixes

Core Engine

#7747 — Fix an issue where the garbage collection in indexes and blobs is not performed in VIO_backout

Fixed by Ilya Eremin

#7737 — Fix cases where the precedence relationship between a record page and a blob page is not set

Fixed by Ilya Eremin

#7731 — Display length of TIMESTAMP WITH TIMEZONE is wrong in Dialect 1

Fixed by Alexander Peshkov

#7730 — Server ignores the size of VARCHAR when performing SET BIND … TO VARCHAR(N)

Fixed by Alexander Peshkov

#7729 — SET BIND OF TIMESTAMP WITH TIMEZONE TO VARCHAR(128) uses the date format of Dialect 1

Fixed by Alexander Peshkov

#7727 — Index for integer column cannot be used when INT128/DECFLOAT value is being searched

Fixed by Dmitry Yemanov

#7723 — Wrong error message on login if the user doesn’t exist and WireCrypt is disabled

Fixed by Alexander Peshkov

#7713 — FOR SELECT statement can not see any changes made in DO block

Fixed by Vlad Khorsun

#7710 — Expression index — more than one null value cause attempt to store duplicate value error

Fixed by Vlad Khorsun

#7703 — Requests leak in AutoCacheRequest

Fixed by Alexander Peshkov

#7696 — SELECT from external procedure validates output parameters even when fetch method returns false

Fixed by Adriano dos Santos Fernandes

#7694 — Fix false positives of “missing entries for record X” error during index validation when a deleted record version is committed and has a backversion

Fixed by Ilya Eremin

#7691 — WITH CALLER PRIVILEGE has no effect in triggers

Fixed by Alexander Peshkov

#7683 — RDB$TIME_ZONE_UTIL.TRANSITIONS returns an infinite result set

Fixed by Adriano dos Santos Fernandes

#7676 — Error “attempt to evaluate index expression recursively”

Fixed by Dmitry Yemanov

#7670 — Cursor name can duplicate parameter and variable names in procedures and functions

Fixed by Adriano dos Santos Fernandes

#7665 — Wrong result ordering in LEFT JOIN query

Fixed by Dmitry Yemanov

#7664 — DROP TABLE executed for a table with big records may lead to “wrong page type” or “end of file” error

Fixed by Vlad Khorsun, Ilya Eremin

#7662 — Fix performance issues in prepare_update()

Fixed by Ilya Eremin

#7661 — Classic Server rejects new connections

Fixed by Vlad Khorsun

#7649 — Switch Linux performance counter timer to CLOCK_MONOTONIC_RAW

Fixed by Adriano dos Santos Fernandes

#7641 — Fix wrong profiler measurements due to overflow

Fixed by Adriano dos Santos Fernandes

#7638 — OVERRIDING USER VALUE should be allowed for GENERATED ALWAYS AS IDENTITY

Fixed by Adriano dos Santos Fernandes

#7627 — The size of a database with big records becomes bigger after backup/restore

Fixed by Ilya Eremin

#7626 — Segfault when new attachment is done to shutting down database

Fixed by Alexander Peshkov

#7611 — Can’t backup/restore database from v3 to v4 with SEC$USER_NAME field longer than 10 characters

Fixed by Adriano dos Santos Fernandes

#7610 — Uninitialized/random value assigned to RDB$ROLES → RDB$SYSTEM PRIVILEGES when restoring from FB3 backup

Fixed by Adriano dos Santos Fernandes

#7604 — PSQL functions do not convert the output BLOB to the connection character set

Fixed by Adriano dos Santos Fernandes

#7603 — BIN_SHR on INT128 does not apply sign extension

Fixed by Alexander Peshkov

#7599 — Conversion of text with '\0' to DECFLOAT without errors

Fixed by Alexander Peshkov

#7598 — DDL statements hang when the compiled statements cache is enabled

Fixed by Vlad Khorsun

#7582 — Missing isc_info_end in Firebird.pas

Fixed by Alexander Peshkov

#7574 — Derived table syntax allows dangling AS

Fixed by Adriano dos Santos Fernandes

#7569 — Multi-level order by and offset/fetch ignored on parenthesized query expressions

Fixed by Adriano dos Santos Fernandes

#7562 — Profiler elapsed times are incorrect in Windows

Fixed by Adriano dos Santos Fernandes

#7556 — FB Classic can hang when attempts to attach DB while it is starting to encrypt/decrypt

Fixed by Alexander Peshkov

#7555 — Invalid configuration for random fresh created database may be used after drop of another one with alias in databases.conf

Fixed by Alexander Peshkov

#7553 — Firebird 5 profiler error with subselects

Fixed by Adriano dos Santos Fernandes

#7548 — SET BIND OF TIMESTAMP WITH TIME ZONE TO CHAR is not working with UTF8 connection charset

Fixed by Adriano dos Santos Fernandes

#7537 — Wrong name in error message when unknown namespace is passed into RDB$SET_CONTEXT()

Fixed by Vlad Khorsun

#7535 — High CPU usage connect to Firebird 3 database using Firebird 4 Classic and SuperClassic service

Fixed by Vlad Khorsun

#7499 — Error during restore: “Index cannot be used in the specified plan”

Fixed by Vlad Khorsun

#7488 — Invalid real to string cast

Fixed by Alexander Peshkov, Artyom Abakumov

#7486 — No initialization of rpb’s runtime flags causes problems with SKIP LOCKED when config ReadConsistency = 0 and SuperServer

Fixed by Adriano dos Santos Fernandes

#7484 — External engine SYSTEM not found

Fixed by Adriano dos Santos Fernandes

#7480 — Firebird server stops accepting new connections after some time

Fixed by Alexander Peshkov

#7456 — Impossible to drop function in package with name of PSQL-function

Fixed by Adriano dos Santos Fernandes

#7387 — Unreliable replication behaviour in Linux Classic

Fixed by Dmitry Yemanov

#7233 — Postfix for #5385 (CORE-5101): Fix slow database restore when Classic server mode is used

Fixed by Ilya Eremin