Appendix A: NULL-related bugs in Firebird

Appendix A: `NULL`-related bugs in Firebird

Attention: both historic and current bugs are listed in the sections below. Always look if and when a bug has been fixed before assuming that it exists in your version of Firebird.

Bugs that crash the server

EXECUTE STATEMENT with NULL argument
EXTRACT from NULL date
FIRST and SKIP with NULL argument
LIKE with NULL escape

EXECUTE STATEMENT with `NULL` argument

EXECUTE STATEMENT with a NULL argument crashed Firebird 1.5 and 1.5.1 servers. Fixed in 1.5.2.

EXTRACT from `NULL` date

In 1.0.0, EXTRACT from a NULL date would crash the server. Fixed in 1.0.2.

FIRST and SKIP with `NULL` argument

FIRST and SKIP crash a Firebird 1.5.n or lower server if given a NULL argument. Fixed in 2.0.

LIKE with `NULL` escape

Using LIKE with a NULL escape character would crash the server. Fixed in 1.5.1.