Firebird 5.0 Release Candidate 2: Bug Fixes

#7904 — FB5 bad plan for query

Implemented by Dmitry Yemanov

#7903 — Unexpected results when using CASE-WHEN with LEFT JOIN

Implemented by Dmitry Yemanov

#7885 — Unstable error messages in services due to races related with service status vector

Implemented by Alexander Peshkov

#7879 — Unexpected results when using natural right join

Implemented by Dmitry Yemanov

#7867 — Error "wrong page type" during garbage collection on v4.0.4

Implemented by Ilya Eremin

#7853 — Do not consider non-deterministic expressions as invariants in pre-filters

Implemented by Dmitry Yemanov

#7839 — Potential bug in BETWEEN operator

Implemented by Vlad Khorsun

#7831 — Incorrect type of UDF-argument with array

Implemented by Dmitry Kovalenko

#7827 — Problem using Python firebird-driver with either Intel or M1 Mac builds with version 4.0.3 or 5.0+

Implemented by Adriano dos Santos Fernandes

#7817 — Memory leak is possible for UDF array arguments

Implemented by Dmitry Yemanov

#7795 — NOT IN <list> returns incorrect result if NULLs are present inside the value list

Implemented by Dmitry Yemanov

#7772 — Blob corruption in FB4.0.3 (embedded)

Implemented by Vlad Khorsun

#7767 — Slow drop trigger command execution under FB5.0

Implemented by Dmitry Yemanov

#7760 — Parameters inside IN list may cause a string truncation error

Implemented by Dmitry Yemanov

#7759 — Routine calling overhead increased by factor 6 vs Firebird 4.0.0

Implemented by Adriano dos Santos Fernandes

#7461 — Differences in field metadata descriptions between Firebird 2.5 and Firebird 4

Implemented by Dmitry Yemanov